Працювала в 1 компанії 6 років 1 місяць
Інше
Database administrator and operator
State law enforcement agencies
Інше
6 років 1 місяць
01.2010 - 01.2016
Analytical dashboard for evaluating the
effectiveness of advertising campaigns
the goal of the "revenue metrics" project is to develop and implement an
interactive dashboard in tableau public for analyzing cash flows.
during the implementation of this project, i built a tool that will help businesses
effectively monitor and analyze important metrics, the dynamics of financial
indicators and identify key factors of revenue changes, which will allow you to
optimize work and increase profitability
Ключова інформація
Visualization of 10+ key metrics, including monthly recurring revenue (mrr),
new mrr, paid users, arppu, churn rate, expansion mrr, etc.
filters by date, language, and user age for flexible analysis.
the project demonstrates my skills in:
sql and working with databases, data analysis, data visualization in tableau
project report in google looker studio with visualization of
the obtained data results.
in google looker studio, i developed an interactive
dashboard with graphs, a pivot table with calculated indicators
with a heat map, and added two filters by date and name
of the advertising company. this report is aimed at assessing the
effectiveness of advertising campaigns in digital channels. it is built on
data from a postgresql database containing information on advertising
impressions, costs, clicks, and other marketing indicators. provide the
marketing team with a convenient tool for tracking the dynamics of
advertising costs and campaign performance over time.
identify the most effective campaigns by key metrics: romi, cpc, cpm,
ctr.
provide the ability to flexibly filter data for deeper analysisSql/postgresql
python
tableau/data visualisation
advertasing companies analysis
a/b tests
tools
sql
python
tableau
google bigquery google
sheets/exel
Навчалась в 1 закладі
Classical private university
"Law"
9, 2021
Володіє мовами
Англійська
середній
Російська
рідна
Українська
рідна
Курси, тренінги, сертифікати
Data analysis
2025
Посилання на сертифікат про навчання https://drive.google.com/file/d/15rtEtVpfMYtsdOQCVH0ER_0o0ha1vcs0/view?usp=sharing
Додаткова інформація
Особисті якості
Communication skills
self - motivation
critical thinking
team collaboration
Karina
Karina
Junior data analyst

Дніпро
Готовий переїхати: Київ, Львів, Одеса
повна зайнятість, неповна зайнятість, проектна робота
Характер роботи: стажування / практика, віддалена робота, гібридна
Остання активність 3 дні тому