This repo introduces a way to build a Business Intelligence solution namely, a Data warehouse using SQL Server 2012.
This repo introduces a way to build a Business Intelligence solution namely, a Data warehouse using SQL Server 2012
This prototype uses data from the department for work and pension located here http://data.gov.uk/dataset/financial-transactions-data-dwp
Data integration was performed using Microsoft SQL Server 2012 Integration services
The Data Warehouse was designed using SQL Analysis Database Services