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

Online — Evenings

Registration open expand drawer icon collaspe drawer icon
SQL Server Analysis Services (SSAS)
hours icon

Total classroom hours

40 hours

schedule icon

Schedule

Online

Evenings, 6:30 PM - 9:20 PM, 14 T Th, 3/2/2021 - 4/15/2021

Quarter: Winter

cost icon

Total cost

$1,345

instructor icon

Instructor: Shankar Pal

notes icon

Notes

Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.

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