Project1

Explore my projects and technical skills

📊 DAX Analysis Using Power BI

Author: Deepak Annapureddy

Tools Used: Power BI, DAX, Excel, Power Query

🔍 Project Overview

This Power BI project demonstrates data analytics and dashboard building for tech product sales using DAX formulas. The visuals help understand trends across cities, product types, payment modes, and delivery channels.

🎯 Project Objectives

Analyze product-wise and city-wise sales performance
Track total orders, deliveries, quantity, and online sales
Use DAX measures to calculate KPIs (Sales, Quantity, Margin, etc.)
Create user-friendly dashboards with slicers and filters

📊 Sample Dashboard Visuals

🧠 Key DAX Measures

Total Sales = SUM(Sales[Total Sales])
Total Quantity = SUM(Sales[Quantity])
Total Orders = DISTINCTCOUNT(Sales[Order ID])
Online Deliveries = CALCULATE(SUM(Sales[Delivery]), Sales[Channel]= "Online")
Profit Margin % = DIVIDE(SUM(Sales[Profit]), SUM(Sales[Total Sales]), 0)

📈 Insights Gained

996 Total Customers made 1000 Total Orders across India
Online deliveries were 336; non-online deliveries were 664
Total Online Sales reached ₹17M with an average unit price of ₹10.5K
Top cities and product types contributed over 50% of total revenue

📄 Report Download

← Back to Main Profile Page