Power-BI-Data-Analysis

This project presents an interactive Power BI dashboard built using retail sales data from January 2022 to December 2023. The analysis uncovers key trends in sales performance, product categories, store-wise comparisons, and customer purchasing behavior.

The goal of this project is to demonstrate practical data analysis and visualization skills, helping stakeholders make data-driven decisions in areas such as product focus, pricing, and store operations.

Visuals (PDF Copy)

PDF Report

Key Visuals Explained

Excecutive Dashboard

Total Sales, Quantity Sold, Number of Products, Avg. Price, KPI Indicators, Revenue Trends, Orders by Categories

Provide an overview of overall business performance across the years.

Product Dashboard

Target Vs Actuals, Product Scenarios, and Top Pick Product

Provide an overview of product performance across the years.

Customer Dashboard

Customer Segmentation by Occupation, Income Level, Spending Behavior. Revenue and Orders per customer

Sensitivity and Scenario Analysis

YoY Profit Analysis

Data Model

DAX Measures

Power Query Editor

Tools & Skills Used:

• Power BI

• Data modeling with relationships

• DAX Measures for KPIs

• Visual storytelling with slicers, bar charts, line graphs, and KPIs

• Drill-down analysis by store and product