This is a repository that I have created to showcase skills, share projects and track my progress in Data Analytics.
Hi, I'm Sonia! I'm currently following a Data Analyitics Course at GoIt Romania and here is where I would like to present the projects I have worked on so far.
In this section I will list data analytics projects briefly explaining what I did for each one.
- Project 1: https://docs.google.com/spreadsheets/d/1t7Bh5xxSYAe_CEy7jLbcuJJXac4E6_NlUkJtuQH8CD4/edit?usp=sharing-
- Calculated product metrics and evaluating the effectiveness of user acquisition spend.
- Project 2: https://docs.google.com/spreadsheets/d/10NTjjDbfkB_DYtJ0qIhoEuMCd8cG-ibywGrMYjgnEoQ/edit?usp=sharing
- Calculated product engagement metrics.
- Used linear regression to predict values and created graphs.
- Created tables showcasing user retention rate.
- Project 1: https://github.com/SoniaMoldovan21/Data-Analysis-Portfolio./blob/e34cce1319bb8577b0f2d2e049f21908f2ee3d6c/Project%201%20SQL.sql
- Created a temporary function that extracts the name of the ad campaign from a URL.
- Used functions to manipulate strings, find matches, and combine multiple tables.
- Utilized conditional statements and performed logical operations to deal with missing data according to specified conditions.
- Project 2: https://github.com/SoniaMoldovan21/Data-Analysis-Portfolio./blob/50a78594de28f893cd3abf15cf3aea479e49a283/Project%202%20SQL.sql
- Using the same CTE from the previous project I added the first day of the month from the date when the ad was displayed.
- For every campaign I created a new field in each month that shows the difference between CPM, CTR, and ROMI in the current month compared to the previous month in percentage.
- Project 1: https://public.tableau.com/views/Project1_17324639274970/Dashboard2?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
- The table in the middle represents a cohort analysis of monthly revenue from users.
- The left graph shows the change in total revenue as a percentage relative to the previous month.
- The bottom right graph shows the sum of revenue received from new users during the calendar month when they became paying.
- Project 2: https://public.tableau.com/views/Project2_17324638664070/Dashboard1?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
- The graph in the middle is a heat map containing data on the average time spent in the game, broken down by the age group of players and activity date quarters.
- The left graph shows the total number of players and the percentage of total users who spent any amount of time in activities related to the "Battle pass".
- The right graph shows how much time players spent playing the game on average every month.
- Project 3: https://public.tableau.com/views/Project3_17324645476660/Dashboard1?:language=en-US&:sid=&:display_count=n&:origin=viz_share_link
- The top left graph shows the number of paid users and the number of users that got from the registration step to starting their trial each month.
- The top right graph is funnel-shaped diagram showing how users progress through each step and how many of them make it to the last one.
- The bottom left graph shows on average how many days it takes for registered users to start their trial period per month.
- The bottom right graph changes based on the step selected in the funnel-shaped diagram and it shows on average how many days it takes for users to proceed to the next steps after registration per month.
- Project: https://lookerstudio.google.com/reporting/cada3a3b-3f51-4184-9edc-114cf16bb3d6
- Created a dashboard in order to monitor marketing campaigns investment and KPI performance.