Project Details

Project Objective:-The RB-Enterprises Store wants to create an annual sales report for 2022. So that, the owner of the RB-Enterprises store can understand their customers and grow more sales in 2023.

Questions (KPIs):-
Compare the sales and orders using single chart.
Which month got the highest sales and orders?
Who purchased more - Men or Women?
What are different order status in 2022?
List top 10 states contributing to the sales?
Relation between age and gender based on number of orders.
Which Channel is contributing maximum to the sales?
Highest selling category?
Process:-
Verify data for any missing values and anomalies, and sort out the same.
Made sure data is consistent and clean with respect to data type, data format and values used.
Created pivot tables according to the questions asked.
Merge all pivot tables into one dashboard and apply slicer to make dashboard interactive and dynamic.

Project Details

AltiQ hardware is a company which has grown vastly in the recent years, and opened business all over the globe.
It is a company which sells, computer and computer accessories through three mediums/channel
Retailers
Direct
Distributors
Recently the company has faced a unforeseen loss by opening store in America based on the surveys,
intuition and some excel analysis and also the company’s competitors has handful of analytics team to perform analysis and make data driven decision.
So, the AltiQ hardware has no other option other than building their analytics team for data driven insights and decisions .

Live Interactive Dashboard

Project Details

Atliq Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, Atliq Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of Atliq Grands wanted to incorporate “Business and Data Intelligence” in order to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights. Their revenue management team had decided to hire a 3rd party service provider to provide them insights from their historical data.

Live Interactive Dashboard

Project Details

Swiggy's MySQL project harnessed diverse datasets for a comprehensive analysis. By identifying inactive users and understanding customer behavior, the platform optimized promotions for increased engagement. Determining the average dish price facilitated competitive pricing strategies and menu optimization. Recognizing top restaurants and evaluating monthly sales allowed for strategic partnerships, collaborations, and reward systems. Analyzing individual ordering patterns and identifying repeated customers aided in targeted marketing and retention strategies. Assessing platform and restaurant revenue growth unveiled performance trends, helping in strategic planning. Insights into popular menu items and frequently paired dishes further allowed personalized promotions and menu optimization. This holistic approach using MySQL data enhances Swiggy's operational efficiency, customer satisfaction, and overall market competitiveness.