Анастасия Чистикова

Предложите Анастасии работу над вашим следующим проектом или зарегистрируйте профиль фрилансера и начинайте зарабатывать прямо сейчас.

Hamburg, Германия

3 месяца 24 дня назад

свободен для работы

возраст 25 лет

на сервисе 3 месяца 24 дня

Рейтинг

Успешных проектов

Средняя оценка

Рейтинг

Базы данных и SQL

607 место из 1203

Python

2023 место из 4457

Уровень владения языками

Навыки и умения

Программирование

Marketing Campaign Performance Dashboard

Базы данных и 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

Базы данных и 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

Базы данных и SQL

ools: 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

Базы данных и 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.