Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

Project Details

Developed an interactive E-Commerce Sales & Customer Analytics Dashboard in Microsoft Excel to analyze retail performance, customer behavior, product trends, and operational efficiency through dynamic visual reporting. The project involved transforming raw transactional data into meaningful business insights using advanced Excel functionalities such as Pivot Tables, Pivot Charts, Slicers, Map Charts, Picture Links, calculated columns, and custom dashboard formatting.
The dashboard was designed using a structured “summary-to-detail” storytelling approach, enabling users to monitor high-level KPIs while exploring detailed analytical insights. Key metrics analyzed include total orders, revenue, quantity sold, customer satisfaction ratings, shipment duration, regional sales distribution, and product category performance. Interactive slicers were implemented to allow dynamic filtering across customer segments and purchasing channels such as App, Website, Instagram, and Partner Platforms.

Project Details

In this project, the goal is to create one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following:
1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

Learning from this project:
1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Project Details

This project was built using a complex multi-platform dataset and focused on transforming raw entertainment data into meaningful business insights through advanced data modeling and visual storytelling.
Dashboard content:Platform-wise content analysis,Comparative OTT insights dashboard,Genre distribution & rating analysis,Country-wise content presence using maps,Release trend analysis over time,Movie vs TV Show breakdown,KPI cards for titles, genres, ratings, countries, and more.
Tools & Techniques Used:
Power BI
Power Query for data cleaning & transformation
DAX for calculated measures and KPIs
Complex Data Modeling with relationships & optimized schema
Interactive slicers, navigation buttons & custom UI design
Advanced visual formatting for a modern OTT-themed dashboard experience
The main goal of this project was not just analysis, but also presenting the insights in a visually engaging and user-friendly way to simulate a real-world business intelligence solution.

Live Interactive Dashboard

Project Details

AtliQ Hardwares (imaginary company) is one of the leading computer hardware producers in India and has expanded well in other countries too.
Problem Statement:-
There are 10 ad hoc requests for which the business needs insights. Applying many important SQL concepts .