The sales director of the company is facing a lot of issues in terms of understanding how the business is performing and what are all the problem company is facing currently as the sales are not as expected and declining gradually. The Sales Director wants insights on the top performing and underperforming Customers/Markets, Revenue Contribution, Profit Margin Contribution.
- Performed a High level analysis of data in SQL to get better understanding over the data.
- Connected the SQL data set to PowerBI.
- Performed ETL and data cleaning on the imported data.
- Created measures, calculated Columns used them for creating visuals in PowerBi.
- Dehli is the largest market in term of revenue contributing around 53%
- Mumbai and Dehli are the largest contributors in terms of Profit Margin. Mumbai contributing about 24% and Dehli around 22%.
- The Revenue trend is steadily declining from past 4 months in 2020.
- ElectricalSara stores is top performing Customer contributing around 65M Revenue i.e around 37.7 % profit.
- In the year 2020, Excel stores, Surge Stores and ElectricalSara stores are the highest profit contributors.
- The Profit Margin for the ElectricalSara stores which was vey narrow around 0.4%, the customer was able to contribute significant profit around 11% giving highest sales orers in the year 2020.
- Around 80% of the revenue is from Brick & Mortar customers and other 20% are from E-commerce customers.
- North is the highest contributor in terms of Revenue with 70%, Central contributing around 25% and South contributing around 4.6% in the year 2020.