Ayushi Mishra

This package offers 7 Best Data Analysis Projects (including SQL, hypothesis testing, EDA, visualisations, report making, business problems) using python that you can add in your resume/portfolio.

Note:

1. You will get all the resources (Code, Data, Report PDF) for these projects and also video tutorials.
2. You can even watch tutorial before purchasing resources.
3. All these projects are also available individually on the home page, if you do not want to purchase them all.

Vendor Performance Analysis (Company Standard)

1. Understanding the Business Problem
2. SQL Data Analysis & Cleaning
3. EDA with Python (Matplotlib, Seaborn, Pandas)
4. Hypothesis Testing & Confidence Interval
5. Power BI Dashboard
6. PDF Report Making

Video Tutorial: https://www.youtube.com/watch?v=Jk8lCFnEmtM&list=PLunlGNVWDAabWhgYxuaeVES_20YZ8Ycp2&index=1

A/B Testing & Regression Analysis Project

1. Business Problem
2. Exploratory Data Analysis
3. Comparing Campaign Performance
4. AB Testing (Hypothesis Testing)
5. Regression Analysis
6. Time Series Analysis

Video Tutorial: https://www.youtube.com/watch?v=iCj4lT5KvJk

Hotel Booking Analysis

1. Business Problem
2. Exploratory Data Analysis
3. Data Analysis for different research questions
4. Analyzing and Visualizing Insights
5. PDF Report Making

Video Tutorial: https://youtu.be/obJZ1rB7TKc?si=esXE8xQclRWbiXe6

Airlines data analysis using Python and SQL:

1. Business Problem
2. Database connection and EDA using SQL query
3. Data Analysis for different research questions using SQL query
4. Analyzing and Visualizing Insights
5. PDF Report Making

Video tutorial: https://youtu.be/LcMjsqZiSjY?si=Ko6tg07m82ch1Wsc

CAPM web application using Python (Financial Analysis):

1. Financial Time Series Analysis
2. Capital Asset Pricing Model (CAPM)
3. Risk Free Asset and Market Portfolio Return
4. Calculating Beta
5. Creating Web Application for presenting insights

Video tutorial: https://youtu.be/ibkrdqM2naU?si=v9J8xJ30n-96uNwv

User Engagement Analysis using YELP Dataset (SQL Project):

1. Business Problem
2. Research Objectives
3. Hypotheiss Testing
4. Analysis using SQL query and visualization
5. Report Making

Video tutorial: https://www.youtube.com/watch?v=2VMAdlzNuTw

Maximizing Revenue for Drivers using Python

1. Craft a compelling research question about a company's operations.

2. Set up null and alternative hypotheses for rigorous testing.

3. Choose the right statistical test based on your data type.

4. Analyse real-world data and draw data-driven conclusions.

5. Present your findings in a clear and impactful way (PPT)

6. Storytelling with data

Video Tutorial: https://www.youtube.com/watch?v=fNdUIzq8sb0