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. 

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

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