Ntombi-the-analyst/South-Africa-Transactions-Dashboard

# South Africa Transactions Dashboard An end-to-end data analytics project focused on cleaning and analyzing a transactional dataset representing 2,000 retail sales in South Africa. The final product is an interactive Power BI dashboard designed for business decision-makers. ## 📊 Tools & Technologies - MySQL - Power BI - Excel - DAX - Power Query ## 🧩 Project Overview This project demonstrates my ability to transform raw, messy data into meaningful insights. Using SQL, I cleaned and prepared the dataset for analysis. I then developed an executive-level Power BI dashboard with filters and visualizations tailored for the South African retail market. ## ✅ Key Features - Sales by region, product, and time period - Average spend per customer - Monthly trends and profitability analysis - All values in South African Rands (R) ## 📂 Files - `transactions_cleaned.sql` – SQL script for cleaning the data - `SouthAfricaDashboard.pbix` – Power BI file - `case-study.md` – Full case study breakdown ## 📸 Sample Dashboard Screenshot *Insert screenshot here* ## 📥 How to Use 1. Open the `.pbix` file in Power BI Desktop. 2. Load your dataset if needed and explore interactive visuals. ---