📌 Project Overview
This project focuses on:
. Cleaning and transforming data using Power Query . Designing a structured data model (star schema) . Creating DAX measures for KPIs and advanced calculations . Building dynamic and interactive Power BI visuals . Presenting financial performance in a user-friendly dashboard
📊 Key Insights
The analysis includes:
. Total Revenue, Expenses, Profit, and Profit Margin . Year-over-year revenue trend . Profitability performance across time periods . Expense structure explored through drill-through visuals . Department or product-level performance comparison
📈 Dashboard Pages & Visuals
⭐ KPI Summary
Displays essential financial metrics:
. Total Revenue . Total Expenses . Profit . Profit Margin
📉 Revenue Trends
A line chart visualizing revenue performance across months or years.
🧾 Expense Drill-Through
A detail view allowing exploration of expense categories.
🏢 Department / Product Performance
A dynamic bar chart comparing performance across business segments.
🧩 Data Model & Transformations
Data preparation includes:
. Cleaning and formatting data in Power Query . Creating DAX measures and calculated columns . Establishing relationships between tables
🛠️ How to Use This Project
. Download the .pbix file
. Open with Power BI Desktop
. Explore dashboard pages and drill-throughs
. Interact with slicers and filters
. Extend the dashboard using new datasets if needed
⚙️ Tools & Technologies
. Power BI Desktop . Power Query . DAX . Data Modeling
👤 Author
Name: Onagadanalyst Data & Market Analyst | Building expertise in Augmented Analytics & AI Automation Email: onagatheanalyst@gmail.com Github: https://github.com/o-danalyst linkendin: https://www.linkedin.com/in/clinton-onaga-b86027375/