Lindiinc/Retail-FMCG-Data-Analytics-Revenue-decline

Imbewu Retail: Project to investigate declining revenue in the Western Cape stores of a South African retailer # Imbewu Retail - Data Analytics End-to-end retail analytics project following a step-by-step data lifecycle - ERD design: database modelling > SQL: data exploration > Power BI: dashboard design > Data dictionary and Executive summary. The project objective is to investigate the declining revenue in the Western Cape stores of a South African retailer operating in the FMCG industry. ## 🔑Table of contents \ \ \ \ \ \ \ \ \ )\ \ ### ⏱️The business probelm Imbewu Retail is a South African retailer with a national footprint comprising of 45 stores of varying formats located in Gauteng, the Western Cape, Kwa-Zulu Natal, and the Eastern Cape. With no hard proof Head of Sales speculated that revenue is declining in the Western Cape. The task was to use the given dataset to analyse the numbers, loyalty programme trends, promotion effectiveness and extract insights that must answer the three main questions "what's happening, why, and what we should do about it". The end result expected - a meaningful Power BI dashboard that will be sent to the COO. ### ⚙️The dataset Imbewu Retail's transactional database contains six tables covering 18 months of operations (January 2024 through to June 2025) across all 45 stores nationwide. A brief description of the tables follows: Further exploration of the dataset is available here: , using tools such as Excel. The SQL scripts can be viewed here ### 🔍 Data quality issues Imbewu's dataset has some NULLs, minor inconsistencies, the occasional duplicates that were discovered whilst running the query profiles on SQL and during the data cleaning phase on Power BI. One of the key issues that arose when cleaning the data was, what would be the impact of removing the null records such as the customer_ids found in the Transaction table?. Due to the relationship that exists between the transactions, customer and transactions_items table deletion of null customer_ids would have a major impact on the transactions_items table that holds the r …