Building a SQL Server 2012 BI Platform

Presenters: Brian Knight (@brianknight) and Devin Knight (@knight_devin)

In this day-long seminar, you'll learn how to build a Business Intelligence solution for your company and support it with the Microsoft platform. We'll start with how to design and data model a data warehouse, including the system preparation. Then, we'll jump into using SQL Server Integration Services to load the data warehouse.

After the data warehouse is loaded, you're ready to roll up the data and provide slice and dice reporting with SQL Server Analysis Services. We'll walk through cube development and enriching your cubes with added business metrics, which are essential for your future dashboards. Last, we'll cover how to report against the data warehouse with SQL Server Reporting Services and SharePoint BI. Make sure you bring your own optional laptop so you can follow along as we design, load, and report against our BI solution.

• Design
• Project Management Methodology
• Designing a Data Warehouse
• Load
• Loading a Dimension Table
• Loading a Fact Table
• Scaling the Data Load
• Aggregate
• Analysis Options
• Tabular Vs Multidimensional
• Designing a Tabular Model
• DAX
• Calculations
• KPIs
• Report
• Building a Basic Matrix Report on SSAS
• Building a Dashboard
• Using other Microsoft Presentation Layer Tools

Seminar includes lunch and refreshments.

Be sure to return back the following day for SQL Saturday #215 which is filled with many free sessions and networking. For more info and to register for SQL Saturday, please visit the event website: http://www.sqlsaturday.com/215/eventhome.aspx