Univ of N. Florida
1 UNF Drive
8:30 a.m. Friday, April 26, 2013
Building a SQL Server 2012 BI Platform--[if gte vml 1]> [endif]-->--[if gte vml 1]> [endif]-->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.DesignProject Management MethodologyDesigning a Data WarehouseLoadLoading a Dimension TableLoading a Fact TableScaling the Data LoadAggregateAnalysis OptionsTabular Vs MultidimensionalDesigning a Tabular ModelDAXCalculationsKPIsReportBuilding a Basic Matrix Report on SSASBuilding a DashboardUsing 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
Early Bird Special 102.47
Regular Price 123.99