EdmundTetteh23/Power-BI-Ghana-Mart-Dashboard

An e-commerce performance model evaluating store profitability, number of orders, product line velocity, and regional customer purchasing trends. # Ghana SuperMart — Sales Performance Dashboard A sales performance dashboard built for Ghana SuperMart, an 8-store retail chain across Ghana — transforming a single messy 2023–2024 transaction file into a clean data model and an interactive Power BI report the executive team can use to track revenue, cost, and quantity performance across stores, categories, and products. ## Table of Contents - Overview - Problem Statement and Project Objectives - Data Pipeline and Architecture - Data Transformation and Cleaning - Data Model and Relationships - Core DAX Measures and Formulas - Dashboards and Visualizations - Key Business Insights - Strategic Recommendations - Tech Stack ## Overview Ghana SuperMart's leadership handed over a single, massive, unstructured sales file spanning 2023–2024 with no clean way to see how the business was actually performing. This project establishes a robust business intelligence framework by structuring flat operational files into an optimized relational Star Schema, applying ETL transformations in Power Query, and building intuitive visuals that enable retail executives to track high-level KPIs, unit volume economics, store performance, and product trends. ## Problem Statement and Project Objectives ### Problem Statement Ghana SuperMart lacked a centralized view of its financial and sales performance. Decisions were traditionally made based on raw intuition and flat spreadsheets, making it difficult to analyze store efficiency, track category margins, optimize inventory movement, and identify unprofitable operations. ### Project Objectives • Centralize Financial Visibility: Consolidate raw transaction logs to track cumulative revenue, costs, and profit across all retail branches. • Category & Product Intelligence: Isolate top-selling product categories and evaluate exact sales performance and unit volume per product. • Store & Regional Analytics: Analyze branch performance across 8 retail stores in Ghana to identify operational leaders …