SQL Server Analysis Services (SSAS)
Design data marts, develop multi-dimensional cubes and utilize Office tools to present BI analytical data.
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
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
- Database Design and Structured Query Language: (T-SQL) Level 2 or equivalent knowledge
Syllabus
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
SQL Server Analysis Services (SSAS)
Total classroom hours
40 hours
Schedule
Online
Evenings, 6:30 PM - 9:20 PM, 14 T Th, 4/20/2021 - 6/3/2021
Quarter: Spring
Total cost
$1,345
Instructor: Shankar Pal
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