Course Catalog
>
Data & Analytics
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.
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:
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
