Project Details

In this project, I crafted a sales report using Excel, a software that helps organize data neatly. This report acts as a comprehensive overview of a business's sales performance. It assists businesses in understanding which customer discounts are most effective, improving communication with customers, and exploring potential growth opportunities in promising countries.

The report delves into customer purchasing behaviors and preferences, aiding businesses in determining the best discount strategies. By presenting this data in clear tables and charts, businesses can quickly grasp important trends and make informed choices.

I have learned the following:

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

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


Throughout this project, I picked up some cool skills:

1. I learned how to use Power Query to handle data easily.
2. I got the hang of making both simple and fancy formulas with DAX.
3. I tackled big puzzles by connecting over 10 tables.
4. I figured out how to choose the best charts and make them look neat.
5. I learned the art of making dashboards that people love.
6. I explored using bookmarks to make things smoother.
7. I even put our work up on the Power BI service.
8. I listened to feedback from everyone and made improvements.
9. I dove into numbers from sales, marketing, finance, and supply chain to tell stories.

Live Interactive Dashboard