How raimujicac/business-intelligence-projects works
This repository appears to be a business-intelligence solution centered on a data warehouse, with staging and warehouse SQL scripts, an SSIS solution, SSAS and SSRS solutions, and Power BI/Excel reports. The filenames identify these product areas, but no README or source excerpts document how they connect or what each solution contains. The graph therefore shows the major components and report artifacts without asserting unsupported runtime flows.
Components 13
Data Integration
- Staging SQL
GROUP49_1_STAGING_AREA.sql - SSIS Solution
GROUP49_SSIS_SOLUTION.sln
Data Warehouse
- Warehouse SQL
GROUP49_2_DATAWAREHOUSE.sql - Warehouse Database
01 Data Warehouse/Group01_DW.bacpac
Analytics and Reports
- SSAS Solution
SSAS_Group1.sln - SSRS Solution
SSRS_Group01.sln - Imported Data Report
04 Self-Service Reports/PBI Solution Importing the Data from Data Warehouse with visualizations.pbix - DirectQuery Report
04 Self-Service Reports/PBI Solution with DirectQuery.pbix - Profit by Product
04 Self-Service Reports/Profit by Product with KPI.xlsx - Quantity and Profit by Location
04 Self-Service Reports/Quantity Sold and Profit by Store Location with Total Quantity KPI.xlsx - Quantity by Product
04 Self-Service Reports/Quantity Sold by Product with KPI.xlsx - Group 01 Report
Report_Group01.pdf - Group 49 Report
Report_Group49.pdf