SQL Server Analysis Services (SSAS)

Design data marts, develop multi-dimensional cubes and utilize Office tools to present BI analytical data.

course image

Course details

ceus icon CEUs 4

schedule icon Schedule Evenings

location icon Location Online

cost icon Cost

$1,345

payment plan

Registration details

SQL Server Analysis Services (SSAS)

Design data marts, develop multi-dimensional cubes and utilize Office tools to present BI analytical data.

What you’ll be able to do — 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 

Course description

expand drawer icon collaspe drawer icon

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. 

Pre-requisites

expand drawer icon collaspe drawer icon
  • Database Design and Structured Query Language: (T-SQL) Level 2 or equivalent knowledge  

Syllabus

expand drawer icon collaspe drawer icon

Session 1  

Determine the architectural requirements of a Business Intelligence Solution 

  • Business Intelligence from an end user’s perspective 
  • Business problems that BI addresses 
  • Skill check 1 

Translate an Online Transactional Processing data model design into an Online Analytical Processing data model 

  • Data Marts vs. Data Warehouses 
  • Dimensional modeling and fact modeling 

Session 2  

Translate an Online Transactional Processing data model design into an Online Analytical Processing data model, continued 

  • Measures vs Attributes 
  • Granularity design  
  • Star schemas 
  • Snowflake schemas  
  • Migrate an OLTP model into an OLAP model 

Session 3  

Translate an Online Transactional Processing data model design into an Online Analytical Processing data model, continued 

  • OLAP Architecture 
  • How to populate a Data Mart  
  • Measure group design 
  • Skill check 2 

Session 4  

Implement an Online Analytical Processing solution 

  • Creating a Visual Studio Data Tools solution 
  • Data sources 
  • Data source views 
  • Named calculations 

Session 5  

Implement an Online Analytical Processing 

  • Dimensions 
  • Attribute properties 
  • Translations 
  • Dimension hierarchies 
  • Attribute relationships 
  • Processing dimensions 

Session 6  

Implement an Online Analytical Processing solution 

  • Unique attributes 
  • Creating SSAS Cubes 
  • Building and Processing Cubes 
  • Named Queries 

Session 7  

Implement an Online Analytical Processing solution  

  • Cube Measure Groups 
  • Calculated Members 
  • Perspectives 
  • Excel Pivot tables 

Session 8  

Implement an Online Analytical Processing solution 

  • Snowflake Dimensions 
  • Time Dimensions  
  • KPIs (Key Performance Indicators) 
  • Business Intelligence on a Time Dimension 

Session 9  

Implement an Online Analytical Processing solution 

  • Parent child dimensions 
  • Naming templates 
  • Discretization 
  • Skill check 3 

Session 10  

Administer an Online Analytical Processing 

  • Finish Skill check 3 
  • Cube processing options 
  • Creating partitions 
  • Creating aggregations 

Session 11  

Administer an Online Analytical Processing 

  • Cube Security 
  • Skill Check 4 
  • Query a Business Intelligence solution 
  • OpenQuery 
  • MDX Basics 

Session 12  

Query a Business Intelligence solution using Multi-dimensional Expressions (MDX) 

  • MDX Relationships  
  • MDX Calculations 
  • Skill Check 5 

Session 13  

Use Business Intelligence in Microsoft Office 

  • Data Mining 
  • Power Pivot 
  • Power View 
  • Skill check 6 

Next available start dates

We aren’t currently offering this course, but we do update our course offerings on a regular basis. Please check back or browse our catalog for more courses that may be available now.

Want more information about Technology programs at Tombolo?

Interested in custom learning solutions for your team?

Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.

Get started