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

In this project, the goal is to be 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

I learned the following things in 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 leverages MySQL to deliver end-to-end finance and supply chain analytics for Atliq Hardware. The focus is on product performance, sales forecasting, and customer behavior. Using SQL queries, user-defined functions, views, and stored procedures, the project provides actionable insights such as product-wise sales reports, top customers and markets, supply chain efficiency, and forecast accuracy comparisons. Key techniques include joins, CTEs, window functions, and stored procedures to transform raw transactional data into meaningful insights. The outcome is a comprehensive analytics framework that supports data-driven decision-making, enhances financial visibility, and improves strategic planning across products and markets.

Project Details

The project focus is on analyzing the revenue trends of a hotel over a 3-month period. The project involves collecting and processing data on room bookings, revenue generated, occupancy rates, and other key financial indicators.

Live Interactive Dashboard