This project analyzes NE's sales performance, customer satisfaction, and inventory distribution using Power BI. The goal is to generate insights and optimize business strategies based on key metrics.
- Requirement Gathering β Define business needs & key metrics.
- Data Walkthrough β Understand data structure & sources.
- Data Connection β Import & link data in Power BI.
- Data Cleaning & Quality Check β Ensure accuracy & consistency.
- Data Modeling β Structure relationships for analysis.
- Data Processing β Transform data for insights.
- DAX Calculations β Implement business logic & KPIs.
- Dashboard Layouting β Design an intuitive report.
- Chart Development β Build visualizations.
- Insight Generation β Extract meaningful business insights.
- Total Sales
- Average Sales
- Number of Items Sold
- Average Rating
- Total Sales by Fat Content (Donut Chart)
- Total Sales by Item Type (Bar Chart)
- Fat Content by Outlet for Total Sales (Stacked Column Chart)
- Total Sales by Outlet Establishment (Line Chart)
- Sales by Outlet (Pie/Donut Chart)
- Sales by Outlet Location (Funnel Map)
- All Metrics by Outlet Type (Matrix Card)
π’ Note: This project was inspired by a YouTube tutorial but significantly modified. I changed the entire color scheme, designed a custom company logo in Canva, adjusted the currency to Ringgit (RM), sourced all necessary logos, and tailored the visualizations for better insights. This was part of my Power BI learning journey, where I gained hands-on experience in data preprocessing, modeling, and dashboard design.
π For full details, refer to: NEmart Power BI Report.pdf

