How hrishikesh26/powerbi-sales-performance-dashboard works
Project type and purpose
• This is a BI/dashboard project built in Power BI (SalesReport.pbix), designed to connect to AtliQ Hardware’s MySQL sales database, perform ETL and data modeling, compute DAX measures, and display interactive visuals for sales insights and decision-making.
File structure
• Top level:
• SalesReport.pbix (Power BI desktop file containing queries, model, visuals)
• db_dump.sql, db_dump_version_2.sql (MySQL dumps under sales-insights-data-analysis-project folder)
• ScreenRecordings/ (clips showing data tables, data model, measures, performance tuning)
• README.md & sales-insights-data-analysis-project/README.md (project description)
Key architectural components
a. Data Source
• MySQL database (live connection or imported via dumps).
b. ETL / Data Integration
• Power Query within Power BI: data cleaning (null removal), currency normalization, type conversions.
c. Data Model
• Star schema: central fact table (sales_transactions) with dimension tables (customers, products, markets, date).
d. Analytical Engine
• DAX measures for revenue, profit margins, YOY calculations, contribution percentages.
e. Visualization Layer
f. Reporting & Delivery
• Power BI Service (cloud workspace), scheduled data refresh, user access (web/mobile).
g. Optional Predictive Layer
• Embedded Python/R scripts or Power BI Forecast visuals.
Architectural patterns & design principles
• ETL/ELT pattern using Power Query
• Star schema for high-performance analytical queries
• Semantic layer (DAX measures) separating business logic
• Interactive, self-service BI design
• Data artifacts (SQL dumps, pbix file) in parallelogram form