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