Data warehouse / BI:

This blog is about building a Data warehouse / BI project to show the full life cycle of a data warehouse project.

 I selected one of the popular data sets on www.census.gov site i.e. US County Business Patterns (http://www.census.gov/econ/cbp/) for this project.

Explore:

• Explore/Identify the Data 

Loading DBs:

• Load the Staging DB
• Normalize and Load Staging DB to Relational DB 
• Load the DW DB

Analysis Services:

• Creating a Cube
• Cube - Partitions and Aggregations
• PowerPivot

Reports:

• Report Template, Report based on analysis Services, Drillthrough and Pie charts
• Reports - Drilldown + Subreport
• Reports-Sparklines, Databars and Indicators

Naming conventions:

• SSIS
• Data warehouse

Platform: 

                 SQL Server 2012

                 SQL Data Tools
                 Data size: 30+ Million rows

Please watch the videos in High resolution: 720P

Watch for the posts in coming days!!!