Using SSAS and the Business Intelligence (BI) tools, this class covers how to design OLAP data models and develop multi-dimensional cubes. Students will get hands-on experience with Star and Snowflake schema designs, dimensional attributes, hierarchies, measures, measure groups, MDX queries, cube security and cube administration. Additional topics include data mining models and PowerPivot. 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.