All Projects
Conference Paper
Automated Real-Time Sales Dashboard
Power BI dashboard pipeline integrating multi-source transactional databases.
200K+Records Processed
6SQL Databases
1Conference Paper
45msQuery Latency
Power BISQL ServerETL PipelinesDAX QueriesData Architecture
Overview
Presented at Sharda University International Conference 2025, this project integrates SQL Server ETL pipelines with a Power BI interface. The dashboard handles 200,000+ transactional rows across 6 regional databases with minimal query latency.
Problem Statement
- —How to unify fragmented sales databases across 6 regional subsidiaries?
- —How to minimize dashboard latency while dealing with 200,000+ records?
- —How to represent nested transaction hierarchies cleanly for C-level executives?
Data & Analysis
Initializing Interactive Dashboard...
Key Findings
10x
Latency Reduction
Index optimization and incremental refreshes cut dashboard query times by 90%.
6 to 1
Data Unification
Aggregated 6 separate relational databases into one normalized data warehouse.
DAX
Advanced Modeling
Custom time intelligence DAX calculations enable real-time year-over-year growth analytics.
2025
Conference Presented
Presented design pattern and data pipelines at Sharda University International Conference.
Skills Demonstrated
SQL Database ETLPower BI DAXRelational NormalizationC-Level ReportingPerformance Optimization