Using SSAS and Microsoft Business Intelligence (BI) development tools, this class covers how to design data marts, develop multi-dimensional cubes, and utilize Office tools to present BI analytical data. Additional topics include Star and Snowflake schema designs, dimensional attributes, hierarchies, measures, measure groups, MDX queries and cube administration. Students will be introduced to creating cube driven reports with Excel 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.