Introduction In order to build a SQL Server business intelligence solution one needs to: Design a de-normalized data warehouse Build and schedule an Extract, Transform and Load (ETL) package that will feed the data warehouse at regular intervals with new data from the OLTP database. Setup, personalize and process a cube based on the data … Continue reading SQL Server Business Intelligence features – creating reports based on OLAP cubes