I developed an end-to-end Data Warehouse and Business Intelligence project using the Northwind da...I developed an end-to-end Data Warehouse and Business Intelligence project using the Northwind da...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Areeba's avatar
Areeba Ali
• 9h
I developed an end-to-end Data Warehouse and Business Intelligence project using the Northwind dataset. The goal was to transform raw business data into a structured analytical system that supports reporting, OLAP analysis, and business-driven insights.
My work included designing a star-schema data warehouse, building ETL workflows in SSIS, developing an SSAS multidimensional cube with measures and hierarchies, performing OLAP operations such as roll-up, drill-down, slice, and dice, and writing MDX queries for analysis. I also deployed and validated the solution using SQL Server Management Studio.
The final result demonstrates a complete BI workflow — from source data extraction and transformation to cube development and analytical reporting. This type of solution is useful for businesses that need organized data, performance tracking, sales analysis, and decision-support reporting.
Data VisualizationData AnalysisData EngineeringMicrosoft SQL ServerMicrosoft Power BI
Post image
Post image
Post image
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started