top of page

In this section you will find a collection of my data analytics projects showcasing my proficiency in Excel, SQL, Python, Tableau, and PowerBI. These projects reflect my ability to extract meaningful insights from complex data sets, enabling data-driven decision-making. Through my expertise in data manipulation, visualization, and analysis, I have successfully delivered actionable solutions to real-world problems. Explore my projects to see how I have leveraged these tools to drive business growth and optimize processes.

About Analytics Projects

Zomato Data Analysis

Goal :

To optimize restaurant operations and drive competitive advantage, it is crucial to focus on improving the customer experience, increasing profitability, and enhancing decision-making. By implementing effective strategies, restaurants can streamline their processes, create memorable dining experiences, and maximize their financial success. This entails optimizing workflow, utilizing technology solutions, training staff to deliver exceptional service, and leveraging data analytics for informed decision-making. Improving the customer experience will lead to increased customer satisfaction, loyalty, and positive word-of-mouth. Additionally, increasing profitability involves cost control measures, menu optimization, and strategic pricing. Lastly, harnessing data-driven insights empowers restaurants to make informed decisions regarding menu offerings, marketing campaigns, and operational improvements. By prioritizing these areas, restaurants can stay ahead of the competition and thrive in the industry.

                                                                      

Flight Delay Analysis

The dataset contains over 10 lakh flights, consisting of three tables. Our goal is to analyze the various reasons for flight delays and extract meaningful insights from the dataset. This analysis will assist our clients in improving their businesses.

Given KPI's :-

●  Weekday Vs Weekend total flights statistics.

●  Total number of cancelled flights for JetBlue Airways on first date of every month.

●  Week wise, State wise and City wise statistics of delay of flights with airline details.

●  Number of airlines with No departure/arrival delay with distance covered between 2500 and 3000.

                                                                 

Employee Retention

The employee retention project involved analyzing a dataset with over 50,000 rows. By conducting thorough data analysis, key patterns and trends were identified, providing valuable insights into factors influencing employee retention. This project contributes to understanding and improving employee retention strategies within the organization.

Given KPI's :-

●  Average Attrition rate for all Departments

●  Average Hourly rate of Male Research Scientist

●  Attrition rate Vs Monthly income stats

●  Average working years for each Department

●  Job Role Vs Work life balance

●  Attrition rate Vs Year since last promotion relation

                                                                 

IPL Data Analysis

Description: This data analysis project explores the Indian Premier League (IPL) dataset from 2008 to 2022 using Python. Various statistical techniques and visualizations were employed to gain insights into team performance, player statistics, and overall tournament trends.

Key Features:
1. Visualized team performance over the years using line charts and bar graphs.
2. Investigated the impact of venue and toss on match outcomes.
3. Utilized statistical tests to determine the significance of factors affecting match results.
4. Developed interactive Visualization using libraries like Matplotlib and Plotly.
5. Conducted exploratory data analysis to identify trends and patterns in the data.

6. Incorporated data cleaning and preprocessing techniques to ensure data quality.
7. Employed machine learning algorithms for predicting match outcomes based on historical data.

 

Netflix Dashboard

I have successfully created a captivating Tableau dashboard showcasing insightful visualizations using Netflix data. The dashboard provides a comprehensive overview of the vast collection of TV shows and movies available on the platform. Through interactive charts and graphs, viewers can gain valuable insights into various genres, ratings, and trends. This project demonstrates my proficiency in data analysis, visualization, and storytelling, as I effectively highlight the diversity and popularity of Netflix content. The dashboard serves as a valuable tool for users to explore and make informed decisions regarding their entertainment preferences.

netflix.png
amazon.png

Amazon Sales Dashboard

This project showcases a Tableau dashboard analyzing Amazon sales data specifically focused on ladies' wear in India. The interactive dashboard provides valuable insights into the performance and trends of women's clothing sales on the e-commerce platform. By visualizing key metrics, such as revenue, top-selling products, and customer demographics, this dashboard offers a comprehensive view of the market. The project highlights the ability to leverage Tableau's powerful data visualization capabilities to facilitate informed decision-making for businesses operating in the Indian fashion industry. Explore the dashboard to gain actionable insights and optimize strategies for success in this lucrative market segment.

bottom of page