LIVE · SQL Server   Power Query · Power BI Pipeline

Sales Master Data Analysis

End-to-end pipeline: SQL Server extraction → Power Query transformation → Power BI visualization

SQL Server Power Query Power BI ETL Pipeline YTD Analysis
Total Revenue
$48.7M
▲ 12.4% vs LY
Total Orders
14,320
▲ 8.1% vs LY
Avg Order Value
$3,401
▲ 3.9% vs LY
Return Rate
2.8%
▼ 0.4pp vs LY
Monthly Revenue Trend
Revenue by Region
Top Products
ProductRevenuevs LY
Pro Series X$12.1M+18%
Enterprise Hub$9.4M+11%
Core Lite$7.2M-3%
Flex Module$5.8M+22%
Base Pack$4.1M-7%
Channel Mix
66% Direct
Direct — 66%
Partners — 40%
Online — 22%
Pipeline Health
StageCountValue
Qualified284$18.2M
Proposal137$11.4M
Negotiation62$6.8M
Closed Won41$4.9M
Closed Lost29$3.1M