Data Analyst / PowerBI Developer

I developed a comprehensive Business Intelligence (BI) solution using Power BI to analyze sales performance for a global retail company. The goal of this project was to transform raw, complex data into actionable insights for decision-makers.

Key Technical Achievements:

Data Modeling: Designed a robust Star Schema with 8 related tables, ensuring optimized filter performance across Territories, Categories, and Products.

ETL Process: Cleaned and transformed raw SQL/Excel data using Power Query, handling null values and establishing consistent data types.

DAX Calculations: Created custom measures for Total Revenue and Distinct Order Counts to provide 100% accurate financial reporting.

Advanced Visualizations: Implemented interactive line charts for trend analysis, clustered bar charts for category performance, and geographic analysis by territory.

Interactivity: Built dynamic slicers (Years, Regions, Categories) allowing users to drill down into specific data points instantly.

Tools Used:

Power BI Desktop

DAX (Data Analysis Expressions)

Power Query (M Language)

AdventureWorks Dataset