Designed an interactive sales dashboard using raw SQL data (Orders, Customers, Products). I built visual KPIs, DAX measures, and data visuals in Power BI to deliver insightful dashboards for business decision-making.
π SQL + Power BI Sales Dashboard
π§βπΌ Role: Data Analyst (Project)
π Timeline: July 2025
π§° Tools Used: Power BI, MYSQL , MS Excel
π‘ Key Insights Uncovered
- π₯ High Performing Product: Weather Display generated the highest revenue among all products.
- π€ Top Customer: John Doe contributed the most revenue, followed by Bob Lee and Jane Smith.
- π Sales Trend: Revenue peaked during February and May, with a dip in MarchβApril.
- π§ Category Breakdown: Revenue is fairly distributed between Widgets and Gadgets.
- π¦ Inventory Alert: One product is flagged as low stock (under 100 units), indicating a potential restock need.
- π§Ύ Order Activity: Only 4 unique orders placed, indicating a low but concentrated transaction count.
