Maven Market Analysis
About this project
Analyzing the trends in sales of Maven Market, a multi-national grocery chain with locations in Canada, Mexico and the United States.
Problem Break Down:
Basic QA/Profiling was done using Excel.
Data Set: More than 250000 records
Visualaization: Power Bi
š My dashboard showcases key performance indicators (KPIs) that matter most:
1.Total Transaction
Total Revenue
Total Return
Total Profit
š I've also included a Weekly trend analysis, giving us insights into how our business fluctuates throughout the year. š
For more detailed analaysis , i have delved into transactions based on countries and cities. Additionally gave an idea about how the top 15 products based on transactions performing, This can be usefull to make strategic decisions of inventory management.
Insights:
Plato products drove the strongest overall profit margin (63.55%) in 1998
High Top product returns doubled in Mexico (4 to 8), at a return rate of 1.2%
Portland reached 1,000 sales in December to close out the year
Data set from @mavenanalytics
