Uchechukwu-Efifie/Nigeria-Agricultural-Export-Analytics-Strategic-BI-Market-Intelligence

A Power BI project analyzing Nigeria’s agricultural exports to 10 European markets over 4 years. Built on a relational star schema, it tracks revenue, profit, and port logistics. Features advanced DAX for YoY growth and dynamic filtering. Designed to transform raw trade data into actionable, stakeholder-ready commercial intelligence. # Nigeria Agricultural Export Analytics Dashboard **Interactive Business Intelligence Dashboard — Microsoft Power BI** > An end-to-end data analytics project analysing Nigeria's agricultural export trade across 10 European markets over a 4-year period. Built on a relational data model spanning four tables, the dashboard delivers actionable commercial intelligence on revenue performance, profitability, product mix, port logistics, and year-on-year growth trends, with dynamic filtering across countries, years, and quarters. Designed to demonstrate production-grade Power BI development skills including advanced DAX time-intelligence, custom data modelling, and stakeholder-ready visual design. --- ## Table of Contents 1. Project Overview 2. Business Problem 3. Dataset Overview 4. Data Model & Relationships 5. Data Cleaning & Preparation 6. DAX Measures & Calculations 7. Dashboard — Visual Walkthrough 8. Key Findings & Insights 9. Recommendations 10. Technical Workflow — Step-by-Step 11. Skills & Competencies Demonstrated 12. Tools & Technologies 13. Limitations & Future Work --- ## 1. Project Overview Nigeria is Africa's largest economy and a significant player in global agricultural commodity trade. Despite the scale of its exports, spanning cashew, cocoa, palm oil, sesame, ginger, cassava, rubber, and plantain, export performance data is rarely presented in a form that enables commercial decision-making at the product, destination, or logistics level. This project addresses that gap by building a comprehensive, single-page Power BI dashboard that transforms raw transactional export data into a decision-ready commercial intelligence tool. The dashboard enables export managers, trade analysts, and business leadership to monitor revenue and profit performance, benchmark products against each other, identify high-value export destinations, and track growth or decline across time periods — all with dynamic, slicer-driven interactivity. | Dimension | Detail | |---| …