Project Details

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 individual project for Maven Analytics, I transformed the dashboard by implementing various enhancements:
1. Renamed the "Topline Performance" tab and incorporated the Maven Market logo.
2. Introduced a Matrix visual displaying Total Transactions, Total Profit, Profit Margin, and Return Rate by Product_Brand, with conditional formatting for enhanced visualization. Utilized visual level Top N filters to spotlight the top 30 product brands and sorted them by Total Transactions. Incorporated KPI Cards for Total Transactions, Total Profit, and Total Returns, complete with trend analysis and target goals. Added a Map visual to illustrate Total Transactions by store city, with store country slicer and enhanced selection controls. Implemented a Treemap visual for a detailed breakdown of Total Transactions by store country. Introduced a Column Chart to depict Weekly Revenue trending for 1998. Included a Gauge Chart for a clear view of Total Revenue vs. Revenue Target

Live Interactive Dashboard