Course Catalog

SQL Server Analysis Services (SSAS)

Competencies:

Determine the architectural requirements of a Business Intelligence Solution
Translate an Online Transactional Processing data model design into an Online Analytical Processing data model
Implement an Online Analytical Processing solution using SQL Server 2012 Analysis Services
Administer an Online Analytical Processing solution using SQL Server 2012 Analysis Services
Query a Business Intelligence solution using Multi-dimensional Expressions (MDX)
Use Business Intelligence in Microsoft Office

Design data marts, develop multi-dimensional cubes, and utilize Office tools to present BI analytical data. Explore Star and Snowflake schema designs, dimensional attributes, hierarchies, measures, measure groups, MDX queries and cube administration. Create cube-driven reports with Excel and PowerPivot.

Prerequisites:

Database Design and Structured Query Language: (T-SQL) Level 2 or equivalent knowledge

See our detailed course information including course content, learning objectives, and prerequisites.

Students must have a Bellevue College NetID before the first class session. Please click here to create your NetID account.

Some Title