End to End PowerBi Project I'm excited to share my latest project, where I utilized MySQL Workbench and Power BI skills to tackle real-world problems for AtliQ Hardware, an emerging tech giant in the competitive computer hardware market. This project features interactive dashboards that analyze sales transactions and customer reports, aiding in quick, data-driven decisions.
Used MySQL Workbench to execute SQL queries for data extraction., ETL for data transformation, and Power BI for visualization. Some key insights from the Power BI dashboard developed to analyze and visualize the company's financial and sales data over the past few years:
✅ Revenue Growth: A remarkable total revenue of $984.81M, reflecting significant business expansion. The revenue trend from Jun-17 to Sep-20 shows a steady increase, with noticeable peaks in mid-2018 and early 2019.
✅Sales Quantity: A total of 2M units were sold over the period, showcasing robust sales performance. Delhi NCR leading in sales quantity, reflecting high demand and strong market penetration. Peak in 2018 followed by a decline in subsequent years.
✅Top Revenue Markets: 🏆 Delhi NCR leading the way with 52.73% of the total revenue ($519.51M), Mumbai contributing 15.24% and Ahmedabad adding another 5.95%.
✅Customer Contribution: The top customer, Electricalsara Stores, contributed 41.97% of the total revenue from the top 5 customers, with a significant $413.33M. The top 5 customers collectively contribute a major portion of the revenue.
✅Product Performance: The top-performing product, generating 47.61% of the revenue from the top 5 products and are key drivers of revenue, necessitating focused marketing and inventory strategies.
✅Revenue by Zone: North Zone leads in sales quantity with 1M units, accounting for 50% of the total sales quantity indicating a strong market presence and potential for further growth.
✅Overall Market Insights: The top 5 markets collectively contribute a substantial portion of the total revenue, suggesting that strategic efforts should focus on these key regions for sustained growth.
✅Sales by Product Type: Brick & Mortar dominates the sales with $800M compared to $200M from E-Commerce. I am grateful to W3Schools.com, Dhaval Patel, Hemanand Vadivel, and the Codebasics, team for their invaluable mentorship and for providing real-world datasets that were instrumental throughout this journey.