The project aimed to create a finance report to get insights from the business which helps in business strategy, customer engagement, and increase the sales and profits.
Extracted data from Excel, processed analytical approach in Power Query, and injected it into the Power BI Desktop.
Delhi NCR is the highest contributor in the revenue, the north zone tops first with 0.59 billion, and Bhubaneshwar is leading in the percentage of profit margin.
Revenue trended down between Sunday, September 1, 2019, and Monday, June 1, 2020, with a drop of ₹10,156,340 where the possible reason is 'Own Brand' accounted for the majority of the decrease among product types. The relative contribution made by 'Own Brand' changed the most.