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. <
See our detailed course information including course content, learning objectives, and prerequisites.