Ucheanny/Federal-Account-Allocation-Committee-FAAC-Allocations-to-LGC-s-in-Nigeria

# Federal-Account-Allocation-Committee-FAAC-Allocations-to-LGC-s-in-Nigeria ## Project Overview This project provides an in-depth analysis of the Federal Account Allocation Committee (FAAC) allocations to Local Government Councils (LGCs) in Nigeria. Using Power BI, I visualize the trends, distribution patterns, and disparities in allocations across various states and local government councils. The insights from this analysis support policy recommendations and data-driven decision-making. ## Objective - To analyze the **FAAC allocations** across different states and LGCs in Nigeria. - To identify trends, patterns, and disparities in revenue distribution. - To provide **interactive dashboards** for policymakers, researchers, and the public to explore allocation data. - To support **data-driven fiscal planning** at the local government level. ## 🛠️ Tools & Technologies - **Power BI** – Data visualization and interactive reporting. - **Excel** – Data preprocessing and structuring. ## Steps Followed ### **1️⃣ Data Collection & Cleaning** - Extracted **FAAC allocation data** from official sources. - Cleaned and structured the data using **Excel**. ### **2️⃣ Data Transformation & Modeling** - Loaded data into **Power BI**. - Created relationships between **fact tables** and **dimension tables** to establish a **star schema**. - Performed data normalization to ensure accuracy. ### **3️⃣ Data Analysis & DAX Calculations** - Developed **DAX measures** for key financial insights: - **Total Allocation** - **Monthly Trends** - **State-wise Distributions** - **Average Allocation Per LGC** ### **4️⃣ Visualization & Dashboard Creation** - **Card Visuals**: Displaying total FAAC allocations. - **Bar Charts**: Showing top/bottom states in terms of allocations. - **Line Charts**: Trends over time to identify seasonal patterns. - **Map Visuals**: Geographical distribution of allocations across Nigeria. ## Key Insights ### **1️⃣ Allocation Trends** - The data shows a **fluc …