Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
  1. Freelancers

Anastasiya Chistikova

Offer Anastasiya work on your next project.

Germany Hamburg, Germany
3 months 24 days back
Available for hire available for hire
age 25 years
on the service 3 months 24 days
Freelancer Anastasiya C. — Germany, Hamburg. Core skill — Databases & SQL, Python

Rating

Successful projects
No data
Average rating
No data
Rating
118
Databases & SQL
607 place out of 1203
Python
2025 place out of 4457

Language proficiency level

Українська Українська: fluent
Русский Русский: fluent
English English: intermediate

Skills and abilities

Programming

Portfolio


  • Marketing Campaign Performance Dashboard

    Databases & SQL
    Tools: SQL, Looker Studio
    Description: Built an interactive dashboard to analyze marketing campaign performance from 2020 to 2025. The dashboard visualizes key metrics such as ROMI, ad spend, CPC, CTR, and CPM, allowing users to track campaign efficiency and identify the most effective marketing strategies.
    My tasks:
    - Data extraction and preprocessing using SQL.
    … - Building data models and visualizations in Looker Studio.
    - Analyzing campaign performance and ROI dynamics.
    - Creating filters and interactive elements.
    Result:
    - Highlighted trends and performance patterns across campaigns.
    - Provided insights through data visualization to support marketing decisions and reporting.

  • Game Engagement Dashboard

    Databases & SQL
    Tools: Tableau, Excel
    Description: Developed an interactive analytics dashboard to explore user gaming activity across different age groups and game categories in 2022. The dashboard provides insights into average playing time, user engagement trends, and the percentage of unique users in “Battle Pass” games. It includes dynamic filters by date range, age group, game type, and language to support detailed behavioral analysis.
    My tasks:
    - Collected, cleaned, and transformed raw gaming activity data using Excel.
    … - Designed and built visual dashboards in Tableau.
    - Performed cohort analysis by age groups to identify gameplay time trends.
    - Calculated key metrics such as average playing time per user and engagement percentage.
    - Implemented interactive filters for flexible data exploration by segment.
    Result:
    - Identified the most engaged age groups and peak activity periods.
    - Revealed user preference dynamics for “Battle Pass” games.
    - Provided actionable insights to support user retention and engagement strategies.

  • Ecommerce funnel

    Databases & SQL
    Tools: Google Looker Studio, BigQuery
    Description: Developed an interactive analytics dashboard to track the ecommerce funnel and user behavior on the website. The dashboard allows analyzing session starts, checkout initiation, completed purchases, and conversion rates by campaigns, languages, and countries. Dynamic filters by date, traffic source, device type, and other parameters were implemented for detailed behavioral analysis.
    My tasks:
    -Collected, cleaned, and transformed user data from BigQuery.
    … -Designed and built visualizations and interactive dashboards in Google Looker Studio.
    -Calculated key metrics: conversion rate, percentage of users completing purchases, and activity by traffic sources.
    -Performed segmentation by country, language, and campaign for comparative analysis.
    -Implemented interactive filters for flexible data exploration.
    Result:
    -Identified top traffic sources with up to 3.16% CR and key funnel drop-offs (-17%).
    -Defined highest-converting markets (Germany, Western Europe, North America) to optimize ad spend.
    -Showed user activity dynamics by language and country.
    -Provided actionable insights to optimize marketing strategies and improve conversion.

  • Delivery Time Analysis in the United States

    Databases & SQL
    Tools: Tableau, Excel
    Description: Built an interactive dashboard to analyze delivery times across the United States. The dashboard visualizes average delivery days by state, shipping method, and customer segment.
    My tasks:
    - Data extraction and preprocessing using Excel.
    … - Developing data visualizations and dashboards in Tableau.
    - Analyzing delivery times by region and shipping method.
    - Creating interactive filters for segment, shipping type, and date range.
    Result:
    - Highlighted delivery trends, showing faster and slower regions and shipping methods.
    - Provided actionable insights through data visualization to support logistics decision-making.