Богдан

BOHDAN BASOV
Junior Data Analyst

SUMMARY
CONTACTS
Junior Data Analyst with hands-on experience in SQL-based data analysis, product analytics,
[open contact info](look above in the "contact info" section) cohort and retention analysis, and business intelligence. Developed analytical dashboards and
[open contact info](look above in the "contact info" section) reports using PostgreSQL, Google Sheets, Tableau, Power BI, Looker Studio, BigQuery and
Telegram Python depends e-commerce, educational, and product-focused datasets. Analyzed user
engagement, retention, sales performance, demand trends, and key business metrics,
LinkedIn
transforming raw data into actionable insights through interactive dashboards and
Kryvyi Rih, Ukraine visualizations. Actively expanding analytical and technical skills. Seeking a Junior Data Analyst
or Product Analyst role to support data-driven decision-making and business growth.
HARD SKILLS
SQL PROJECT EXPERIENCE
Data Analysis
Product Analytics Cohort & Retention Analysis of Video Platform Users
Data Cleaning & Tools: PostgreSQL (SQL, CTEs, Joins, Date Functions), Google Sheets (Pivot Tables, Cohort
Transformation Analysis)
Data Visualization
Dashboard Description: Conducted a 6-month retention analysis based on user registration and
Development activity events. Processed raw user and event data, built cohort retention tables, and
KPI Analysis compared engagement trends between promotional and organic user segments.
Data Storytelling My tasks: Cleaned and transformed raw datasets using SQL. Built cohort logic using CTEs,
Basic Statistics joins, aggregations, and date calculations. Created retention matrices and pivot tables in
Conversion Rate Google Sheets. Analyzed user engagement and retention trends. Provided business
Retention Analysis recommendations to improve long-term retention.
Cohort Analysis
Result: Identified significant retention differences between promotional and organic
Business Metrics
cohorts. Found that organically acquired users demonstrated stronger long-term
(Retention Rate,
engagement. Proposed retention and loyalty improvements aimed at increasing user
Churn Rate, ARPU,
return rates.
AOV , ROMI, DAU /
WAU / MAU, LTV) Advertising Performance Dashboard in Tableau
A/B Testing
Tools: Tableau (Calculated Fields), PostgreSQL (SQL, CTEs, Joins, UNION ALL, Regular
TOOLS Expressions)
PostgreSQL Description: Developed a marketing performance dashboard in Tableau to analyze and
BigQuery compare advertising campaign performance across Facebook and Google Ads. The
Power BI (DAX) dashboard helps evaluate campaign efficiency, compare channels, and track key
Tableau marketing metrics across time, campaigns, and audience segments.
Data (Looker) Studio
My tasks: Combined Facebook and Google Ads datasets into a single analytical table using
Google Sheets
SQL joins and UNION ALL, standardized the data structure across sources, decoded
Python
utm_campaign values from URL parameters for cleaner campaign analysis. In Tableau,
Amplitude
created calculated fields for CTR, CPC, CPM, CPL, ROMI, Click-to-Lead Conversion, and
SOFT SKILLS Reach-to-Lead Conversion, and built an interactive dashboard with KPI cards, a Select
Metric parameter, campaign ranking, metric trends, spend vs leads analysis, campaign
Attention to Detail
efficiency analysis, correlation analysis, and filters.
Adaptability
Teamwork Result: Built an interactive dashboard for analyzing Facebook and Google Ads
Communication Skills performance across campaigns. It supports campaign comparison by multiple dimensions
Time Management and helps evaluate conversion efficiency and the relationship between ad spend and lead
Continuous Learning generation.

LANGUAGES GoIT - start your career in IT Kryvyi Rih National University
English - Intermediate EDUCATION Data Analysis Master's degree, Computer Engineering
Ukrainian - Native 2026 2021–2026