Yana S.
Offer Yana work on your next project.
Private message
Offer work
Kyiv,
Ukraine
8 months 9 days back
available for hire
on the service 8 months 30 days
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Русский: fluent
English: intermediate
CV
Junior Data Analyst with hands-on experience in SQL, Python (pandas, matplotlib), Tableau, and Google Sheets. Skilled in analyzing data, building dashboards, and creating analytical reports to support decision-making. Portfolio includes projects on GitHub and Tableau Public (MRR, LTV, churn rate, interactive visualizations). Continuously improving both technical skills and English proficiency.
Skills and abilities
Programming
Services
Portfolio
-
Dynamic Google Sheets Calendar
Javascript and Typescript
Built a fully automated calendar in Google Sheets powered by Google Apps Script. The solution dynamically displays events from multiple sheets, applies color-coded highlights, adds hoverable comments, and includes a daily task checklist with auto-reset via time-driven triggers.
-
JSON File Processing & Data Analysis
Python
Developed a Python-based solution to process JSON files containing air raid alert and cancellation messages. The project extracts key information (date, time, location, message type), converts it into a structured CSV format, and visualizes the results in Tableau through an interactive calendar chart with regional filters.
-
Game Revenue Metrics Dashboard
Databases & SQL
Developed an interactive Tableau dashboard powered by SQL queries (Google BigQuery) to analyze key revenue metrics for an online game. The project provides insights into user behavior, subscription trends, churn, MRR growth, and ARPPU dynamics over time.
-
Advertising ROMI & Metrics Dashboard
Databases & SQL
- Dashboard Development: Created a Looker Studio dashboard to track and analyze Facebook and Google Ads performance.
- Key Metrics & Analysis: Visualized ROMI, ad spend, CPC, CPM, and CTR to evaluate campaign effectiveness.
- Interactive Insights: Implemented dynamic filters for detailed, data-driven decision-making.
-
Funnel Analysis & Conversion Metrics
Databases & SQL
- Funnel Visualization: Built a funnel analysis dashboard in Tableau to track user progression across key stages of the customer journey.
- Conversion Metrics: Measured and visualized key conversion rates, such as registration to purchase, to identify bottlenecks and optimize the sales process.
- Interactive Insights: Added dynamic filters for detailed, data-driven conversion analysis.
- Funnel Visualization: Built a funnel analysis dashboard in Tableau to track user progression across key stages of the customer journey. - Conversion Metrics: Measured and visualized key conversion rates, such as registration to purchase, to identify bottlenecks and optimize the sales process. - Interactive Insights: Added dynamic filters for detailed, data-driven conversion analysis.
-
User Onboarding, Conversion & Retention Analysis - US
Databases & SQL
I developed a cohort-based dashboard in Amplitude to analyze user onboarding, conversion, and retention for users in the US who performed the "Welcome" action in June 2023. The analysis focuses on both iOS and Android platforms, providing insights into how users progress through the onboarding funnel and engage with key app features. Key Metrics and Visualizations: - Cohort: Welcome Action - US June 2023: Tracks the number of users in the US who completed the "Welcome" action during June 2023, segmented by platform (iOS/Android). - User Onboarding Funnel: Welcome to Play - Platform Breakdown: Shows the conversion rate from completing the welcome action to the first in-app activity (e.g., Play Song/Video), broken down by platform. - User Retention: Welcome to Active Event & Play Song/Video: Analyzes retention by tracking users who engaged with core events like Play Song/Video after completing the "Welcome" action. - Daily Conversion Rate by Platform: Monitors daily conversion rates from onboarding to key user actions, segmented by platform (iOS/Android). - Daily Onboarding Duration by Platform: Measures the time spent by users in the onboarding process, segmented by platform, to assess the efficiency of the flow. - User Engagement Dynamics: Play Song/Video vs. Active Events: Compares user engagement between key actions (e.g., Play Song/Video vs. other events), providing insights into user preferences. This cohort analysis helped identify key drop-off points and areas for optimization in the user journey, enabling data-driven insights for improving user retention and conversion. By segmenting the data by platform and analyzing engagement patterns, I was able to draw actionable conclusions to enhance the user experience and increase long-term user retention.I developed a cohort-based dashboard in Amplitude to analyze user onboarding, conversion, and retention for users in the US who performed the "Welcome" action in June 2023. The analysis focuses on both iOS and Android platforms, providing insights into how users progress through the onboarding funnel and engage with key app features. Key Metrics and Visualizations: - Cohort: Welcome Action - US June 2023: Tracks the number of users in the US who completed the "Welcome" action during June 2023, segmented by platform (iOS/Android). - User Onboarding Funnel: Welcome to Play - Platform Breakdown: Shows the conversion rate from completing the welcome action to the first in-app activity (e.g., Play Song/Video), broken down by platform. - User Retention: Welcome to Active Event & Play Song/Video: Analyzes retention by tracking users who engaged with core events like Play Song/Video after completing the "Welcome" action. - Daily Conversion Rate by Platform: Monitors daily conversion rates from onboarding to key user actions, segmented by platform (iOS/Android). - Daily Onboarding Duration by Platform: Measures the time spent by users in the onboarding process, segmented by platform, to assess the efficiency of the flow. - User Engagement Dynamics: Play Song/Video vs. Active Events: Compares user engagement between key actions (e.g., Play Song/Video vs. other events), providing insights into user preferences. This cohort analysis helped identify key drop-off points and areas for optimization in the user journey, enabling data-driven insights for improving user retention and conversion. By segmenting the data by platform and analyzing engagement patterns, I was able to draw actionable conclusions to enhance the user experience and increase long-term user retention.