Azure Analysis Services and SQL Server Analysis Service 2017 Tabular Foundations 3-day training course. This course may be adapted (2 to 4 days) and combined with related training modules on DAX, Power Query & Power BI.
Objectives:
Learn to plan, develop and deploy AAS & SSAS Tabular solutions. Understand the relationship between: SSAS multidimensional, SSAS Tabular, Power Pivot & Power BI. Access and use the Azure Portal and AAS console. Understand the unique features & capabilities of AAS & SSAS Tabular and the business cases for each. Realize the advantages & trade-offs with storage modes.
Topic Outline:
- Prerequisites and Setup Steps
- Azure Analysis Services Overview
- Introducing Azure Analysis Services
- Tabular Model Design
- AAS: part of the larger Azure universe
- Planning the Solution
- Azure Analysis Services Solutions
- Reporting & Usability Requirements
- To Cache, or Not to Cache
- Tabular Model Design
- Setting up the Environment
- Development & Management Tools
- The Big Two
- Tools and Data Sources
- Integrated Workspace vs Workspace Server
- Project Planning & Setup Checklist
- Creating an AAS Instance
- Finding AAS in the Azure Portal
- Create the AAS Server
- AAS Server Address
- Common Settings
- Migrating a Power BI Model to AAS
- Getting Started with SQL Server Data Tools
- Analysis Services Tabular Project
- Workspace Database
- Get Data & Power Query
- Extract Transform Load Process
- Power Query SSDT Integration
- Transformations Available
- Power Query SSDT Integration
- Data Model Table Queries
- Views or Power Query? (Try to Pick One)
- Import from Data Source
- Create Data Model Tables
- Loading & Processing
- Power Query Checklist
- Data Modeling Essentials
- Tabular Model Design
- Relationships
- Creating Relationships
- Hiding Key Fields Users Don’t Care About
- Multi-Select to Make Life Easier
- Analyze with Excel
- Pivot Table Basics
- Data Modeling Checklist
- Calculations: Columns and Measures
- Calculated Columns
- Measures (Aggregation Algorithms)
- Designing Measures in SSDT
- Hands On: Ragged Chart of Accounts
- Ragged Hierarchies & Blank Level Members
- Creating a Hierarchy
- Deploying & Processing
- Deployment: Almost Live!
- Project Deployment Server
- Deploy & Process
- Scripting Processing Options
- Tabular Modeling Script Language (TMSL)
- Generating TMSL Processing Script
- Generating Partition Processing Script
- Processing with PowerShell
- Designing Partitions
- Table Partitions
- Common Partition Strategies
- Table Partitions
- Data Storage and Performance
- Database Objects vs Power Query
- SQL Server Table-valued UDF for partitioning (examples)
- Create Multiple Parameters
- Modern Partition Design with Power Query
- Check for Query Folding
- Data Storage and Performance
- Sort Optimization
- Dynamic Duo: Storage and Formula Engine
- Browsing & Reporting with AAS
- Connecting to AAS from Excel
- Creating a Connection
- Creating Another Pivot Table
- Converting to Cube Functions
- Connecting to AAS from Power BI
- On-premises Gateway
- Gateway Flow
- Gateway Requirements
- Row Level Security
- Row Level Security, Simple
- Row Level Security, Dynamic
- Perspectives
- Questions & Answers
- Performing Analysis on an AAS Source
- Basic DAX (hands-on)
- Advanced DAX
- AAS Database & Server Management
- Resources