Using SSAS and the Business Intelligence (BI) tools, this class covers how to develop multi-dimensional cubes, KPIs, MDX queries, DMX queries, and data mining models. Additional topics include Star and Snowflake schema designs, dimensional attributes, hierarchies, measures, measure groups, and cube administration. Students will be introduced to creating a data warehouse, creating ETL processes to load measure and dimensional tables with SSIS, and creating cube driven reports with Excel and Reporting Services. Bring a USB flash drive (minimum 2 GB) to class.
Prerequisites: Database Design and Structured Query Language: (T-SQL) Level 2 or equivalent.
Please bring to class your SSIS book - Pro SQL Server 2012 BI Solutions, ISBN 978-1430234883.
See our detailed course information including course content, learning objectives, and prerequisites.