The purpose of this project is to provide detailed analytics for the Microsoft MAPS Database. The MAPS product can be downloaded here - http://technet.microsoft.com/en-us/library/bb977556.aspx

This solution builds a data warehouse that pulls data from any number of MAPS inventory databases. The solution consists of:
1- SSIS ETL Package to move data from the MAPS Database into the SQL Server Data Mart
2 - SQL Data Mart for storing the historical MAPS data
3 - SQL Server Analysis Services Cube for analyzing the MAPS data
4 - A set of SQL Reporting Services Reports for detail on the MAPS data

Future additions
1 - Time series information on previous MAPS inventory runs
2 - Additional product information other than SQL Server

Last edited Feb 25, 2010 at 2:06 PM by DanSand, version 2