How ramaniravi/business_insights_360 works
Project type and purpose
• This is not a traditional multi-tier web app but an end-to-end Business Intelligence solution built entirely in Power BI Desktop.
• Its purpose is to extract transactional data from a MySQL source, transform and model it into a snowflake schema, calculate key metrics with DAX, and present interactive dashboards for Finance, Sales, Marketing, and Supply Chain stakeholders.
Main components of the system
a. Data Source
• MySQL database containing raw sales, forecast, cost, deduction tables
b. ETL / Data Preparation
• Power Query (M language) steps inside Power BI Desktop
• Connection via MySQL connector
c. Data Model
• A Snowflake schema of fact and dimension tables
• Relationships defined in Power BI’s model view
d. Calculation Engine
• DAX measures and calculated columns
• Performance tuning via DAX Studio
e. Report Layer
• Power BI report file (.pbix) with Home, Finance, Sales, Marketing, Supply Chain pages
• Interactive features: bookmarks, slicers, tooltips, conditional formatting
f. DevOps / Version Control
• Git + GitHub LFS for storing the large .pbix
g. End Users
• Business stakeholders interacting via Power BI Desktop or Service
Relationships and data flow
• Side connections:
• DAX Studio ←→ Data Model (for performance analysis)
• GitHub LFS ← .pbix + Resources folder (version tracking)
Architectural patterns and design principles
• ETL pipeline embedded in the authoring tool (Power Query)
• Semantic layer / Tabular Model with a snowflake schema
• Separation of concerns: data ingestion, modeling, calculation, presentation
• Single monolithic BI artifact (.pbix) that packages everything
Putting it all together
• Snowflake schema visually by showing dimension tables branching off a central fact table.
• “Home View” node as the navigation hub linking to each business-area page.
• Finally, annotate any performance-critical steps (e.g., “Optimized with DAX Studio”) to capture design considerations.