All the projects completed for the Practicum's Data Analyst professional training program in 2020-2021
Please note that for legal reasons I can't publish the datasets and the full project descriptions.
| Project name | Short Description | Libraries used |
|---|---|---|
| Final project | The final project includes subprojects based on the use of complex SQL-queries, the study of A/B Test results, as well as the separate study of the most profitable telecom operator tariffs, including the creation of presentation and dashboard with the results. | pandas, matplotlib, scipy, datetime |
| Forecasts and Prediction (Machine learning) | The project goal are to predict a churn rate in a fitness club chain using EDA and compare the results with prediction of ML algorithms and determine the most suitable for this goal ML algorithm. | sklearn, pandas, matplotlib, seaborn, plotly |
| Event-based Analytics (Integrated Project 2) | The project goals are to analyze the results of the A/A/B test of new fonts in the company's app, to investigate user behavior for the company's app to check, how users reach the purchase stage, how many users make it to a certain stage, how many get stuck at previous stages and where exactly. | pandas, matplotlib, numpy, scipy, seaborn, plotly, datetime, math |
| Finding Video Trends on Youtube | The goal of this project is to create a dashboard, publish it on the Tableau Public Server and use the dashboard to answer questions like "Which video categories trended most often?", "How were trends distributed among regions?", "What categories were especially popular in the United States? etc." | |
| Telling a story using data | The goal of this project is to perform out of the house food and drinking market research in LA to gain additional information which can help us to find out what kind of establishments are popular in the city, how big they are and where they are located. | pandas, matplotlib, seaborn, plotly, usaddress |
| A/B Test Evaluation | The project goals are: 1. to prioritize hypotheses which may help boost revenue; 2. to analyze results of an A/B test; 3. to draw a general conclusion and recommendations for our colleges from the marketing department. | pandas, matplotlib, numpy, scipy, datetime |
| Business Analysis With Data | The project goal is to help optimize marketing expenses at the project Yandex.Afisha using the logs and building an event funnel. | pandas, matplotlib, numpy, seaborn, plotly, datetime |
| Integrated Project 1 | The project goal is to find out patterns in games sales data and plan an advertising campaign for the next year. | pandas, matplotlib, numpy, seaborn, scipy, requests, io |
| Statistical Data Analysis | The project goal is to find out which of the prepaid calling plans brings the telecom provider more revenue to adjust the advertising budget. | pandas, matplotlib, scipy, math, functools |
| Exploratory Data Analysis | The project goal is to find out which factors influence the price of vehicles, which were sold on a given website. | pandas, matplotlib |
| Data Preprocessing | To find out if a bank customer’s marital status and the number of children have an impact on whether they will default on a loan. | pandas |