Mastering in TabularSSAS | Azure Analysis services

Course details

Course Outline:

• Getting started
  
• Multidimensional Vs Tabular
  
• Separate Named Instances
  
• Visual Studio basics
  
• Visual Studio windows
  
• Setting startup options
  
• Creating a project
  
• Connecting to SQL Server
  
• Creating and using connections
  
• Filtering rows and column
  
• Creating a data model
  
• Hiding from client tools
  
• Renaming tables/columns
  
• How column storage works
  
• How processing works
  
• Relationships
  
• Diagram view
  
• Creating relationships
  
• Measures
  
• Creating measures
  
• SUMX, AVERAGEX, etc.
  
• Hierarchies
  
• Creating a hierarchy
  
• Viewing hierarchies
  
• KPIs
  
• The parts of a KPI
  
• Absolute and relative measures
  
• Creating and viewing KPIs
  
• Perspectives
  
• Creating perspectives
  
• Using in Excel
  
• Security
  
• How security works
  
• Creating roles
  
• Filtering rows by role