Project Details

In this project, I have created a sales report utilizing Excel pivot tables. This report serves as a valuable tool for businesses to determine optimal customer discounts, streamline negotiation processes, and identify opportunities for expanding into promising markets. The reports I've crafted offer actionable insights to assist businesses in enhancing their sales strategies, enhancing customer satisfaction, and increasing revenue.
Throughout this project, I have acquired expertise in the following areas:
1. Utilizing pivot tables
2. Harnessing the capabilities of Power Query
3. Grasping the fundamentals of DAX (Data Analysis Expressions)
4. Enhancing data presentation through conditional formatting
5. Improving the visual appeal of reports
6. Gaining insights into sales-related metrics
Overall, this project revolves around equipping businesses with the tools and knowledge necessary to enhance their sales efforts. By delving into sales data, businesses can uncover growth.

Project Details

This project, which combines Power BI, SQL, and Excel, centres around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statements like GM, NP, NS etc. and performance over time chart w.r.t to key metrics.
💰Sales View: Shows customers and product performance, unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance, unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrics by customers and products.
👨‍🎓 Executive View: shows market share of competitors, trends, revenue by division and channel, top 5 customer

Live Interactive Dashboard

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving, and communication skills, contributing to my growth as a data analyst.

Project Details

In this project, we embark on a journey to gain a deeper understanding of our customer base and revenue generation at Shield Insurance. We prioritize tracking customer numbers and total revenue, while also closely monitoring daily growth rates for both. This real-time monitoring ensures we stay on course towards our goals.
I've tackled the following aspects:
Understand how many customers they have and how much money they make.
Monitor how fast the money and customer numbers are growing daily.
Looked at how the insurance policies change from one month to another to spot trends and areas to improve.
Sorting the customers by age groups and seeing which cities and age groups make the most money and have the most customers.
Used filters like sales methods, age groups, cities, months, and policy IDs to analyze our data faster.
Separate page to study how different age groups impact the business - like what policies they prefer and how they settle claims.

Live Interactive Dashboard