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

The AtliQ Hardware company is grappling with significant customer issues across various countries, prompting the need for extensive data analysis. With a dataset exceeding 1.8 million records stored in MySQL, a comprehensive approach utilizing SQL syntaxes has been devised to tackle the challenge. Through the implementation of derived functions, stored procedures, views, and Common Table Expressions (CTEs), the project aims to provide AtliQ with valuable insights into areas of deficiency and potential improvement opportunities. By leveraging these advanced SQL techniques, the project seeks to pinpoint specific regions or aspects where the company may be falling short in meeting customer expectations. Ultimately, this analytical endeavor aims to empower AtliQ Hardware with actionable intelligence to address underlying issues and enhance overall customer satisfaction across their global operations.