Atliq hardware company supplies computer hardware and peripherals (like desktop, headphone, pen drive, webcam, speaker, mouse etc.) to many of the clients like Excel store, Nomad Stores, Surge Stores, Electricalsara Stores across India. It has head office in Delhi and lots of regional offices throughout India.
Designed a Power BI dashboard for Atliq Hardware to track KPIs (Sales and Revenue), compared regional performance and to analyzed top 5 products & customers. stakes directors are more interested in dashboards where they can look the real data visualization and get how the numbers are trending. Sales director can make data driven decisions which will help him to increase the sales of the company.
- Load all the required data records (tables) to Power BI (Get data --> my SQL)
- Clean and transform the raw data.
- Removed irrelevant data like rows where sales amount is 0 or negative.
- removed other countries as we are looking for sales insight in India.
- Normalized data by creating new conditional column to convert other currencies to INR as we are looking for sales insight in India.
- Build a relational data model.
- Created required calculated coloums and DAX measures
- Design an interactive report to analyze and visualize the data by adding.
- KPI Cards to show total revenue and total Quantity sale.
- Bar chart to show total revenue WRT regions.
- Bar chart showing quantity sales WRT regions.
- Slicer to filter out report based on year and months.
- Top 5 Customers and products by revenue.
- Revenue trends based on Months and last year revenue.
Hooray! Finally, this is what final output looks like:
Give a ⭐️ if you like this project!
© 2021 Subala Singh