Project Details

In this project, I crafted a sales report using Excel pivot tables, equipping businesses with the means to assess customer discounts, streamline negotiations, and pinpoint expansion prospects in promising markets. The resulting reports offer actionable insights and recommendations to refine sales strategies, elevate customer satisfaction, and optimize revenue generation.

Throughout this project, I acquired proficiency in the following key areas:

Pivot Tables
Power Query
Conditional Formatting
Report Enhancement
Sales Domain Metrics
In essence, this project serves as a tool for businesses to take charge of their sales operations. With data-driven analysis, they can seize untapped opportunities, foster growth, and thrive in today's competitive market landscape.

Project Details

The Management hired Data Analytics team to utilize this data and find out the current business problems. As an Analyst I have created different report view(Finance, Sales, Marketing, Supply chain) which would address the need of various stakeholders in a company. These report views contains key matrices which reflects the company's issues in different regions/states.

Tools Used:
Excel, MySQL, Power BI, Power BI service, DAX studio

Learnings:
Project Planning & Scoping, Data Collection & Exploration, Data load to Power BI & Initial Validation, Data transformation in Power BI, Data Modelling & Calculated Columns, Important DAX formulas

Live Interactive Dashboard

Project Details

Analyzing data to drive business performance in different categories of pizza.

The charts which are created to understand insights are:

1)Daily trend for total orders
2)Monthly trends for total orders
3)Percentage of sales by pizza category
4)Percentage of sales by pizza size
5)Top5 best sellers by Revenue, total quantity and total orders.
6)Bottom 5 best sellers by Revenue, total quantity and total orders.

Tools used: Excel, SQL, DAX, Power query

Live Interactive Dashboard

Project Details

Derived from Codebasics and Atliq Technologies' Resume Project Challenge 4 in the consumer goods domain, AdHoc_Analysis focuses on Atliq Hardware, a prominent computer hardware manufacturer facing data-driven decision challenges.

Problem
Atliq Hardware struggles with timely and informed decision-making based on data. To address this, the management aims to augment the data analytics team, a SQL challenge is employed to identify junior analysts with both technical and soft skills.

Tools & Approach
Utilizing MySQL, Excel. The project applies MySQL concepts such as Joins, CTEs, Subqueries, and various functions.
The project uncovers critical metrics, including Gross Profit, Contribution %, Order by Overall Amount Sold, Average Gross Sales, and Average Manufacturing Cost.

Project Details

Zomato is a food delivery app where we can order any food items we want. We have a dataset of goldusers_signup, product, users and sales. Gold user signup offers customer to avail extra benefits. Using SQL , we are able to analyze key metrices and the customer order behavior.

Important concepts which is used in project:
Window function
JOINS
Subquery

Project Details

Project Overview:
The IPL Data Analysis and Visualization project aim to explore and analyze data related to the Indian Premier League (IPL), one of the most popular Twenty20 cricket leagues globally. The project will involve collecting, cleaning, and analyzing various datasets associated with IPL matches, teams, players, and performance statistics.

Objectives:

Data Collection:

Gather comprehensive datasets containing information on IPL matches, teams, players, and performance metrics.
Utilize reputable sources and APIs to ensure the accuracy and completeness of the data.
Data Cleaning and Preprocessing:

Perform data cleaning and preprocessing to handle missing values, outliers, and inconsistencies.
Standardize and format the data for consistency and ease of analysis.
Exploratory Data Analysis (EDA):

Conduct exploratory data analysis to uncover patterns, trends, and insights within the IPL data.