-
Module 1: Core concepts and tools
19 Lessons-
StartModule introduction
-
StartWhat is Analysis Services?
-
StartSemantic models in Analysis Services
-
StartChoosing tabular vs multi-dimensional
-
StartTabular storage
-
StartSQL Server Analysis Services
-
StartAzure Analysis Services
-
StartTabular data models in Power BI
-
StartAzure AS vs Fabric
-
StartChoosing data access modes
-
StartProviding suitable source data
-
StartUsing Analysis Services tooling
-
StartSSMS
-
StartSQL Server Integration Services
-
StartAzure Data Factory
-
StartTabular Editor
-
StartDAX Studio
-
StartVertipaq Analyzer
-
StartModule 1 quiz
-
-
Module 2: Installing or provisioning Analysis Services
20 Lessons-
StartModule introduction
-
StartInstallation sources for SQL Server AS
-
StartSQL Server components and instances
-
StartChoosing editions
-
StartDefault vs named instances
-
StartAzure Extension
-
StartFeature selections and instance configuration
-
StartService accounts and collations
-
StartServer and folder configuration
-
StartApplying cumulative updates
-
StartViewing and reconfiguring installed instances
-
StartConnecting with SSMS
-
StartRemoving SQL Server Analysis Services
-
StartCreating a Resource Group
-
StartProvisioning Azure Analysis Services
-
StartConnecting SSMS to Azure AS
-
StartUsing multi-factor authentication
-
StartModule 2 quiz
-
StartModule 2 lab
-
StartModule 2 lab solution
-
-
Module 3: Creating tabular projects
19 Lessons-
StartModule introduction
-
StartAnalysis Services project templates
-
StartImport from PowerPivot
-
StartCreating projects and solutions
-
StartConfiguring workspace databases
-
StartDefault workspace datatabase
-
StartChoosing compatibility levels
-
StartSetting project properties
-
StartSetting data model properties
-
StartAuthenticating to Analysis Services
-
StartAuthenticating to data sources
-
StartChanged menu locations
-
StartKey development windows
-
StartUsing Get Data to import data
-
StartDeploying a tabular project
-
StartConnecting to the deployed model
-
StartModule 3 quiz
-
StartModule 3 lab
-
StartModule 3 lab solution
-
-
Module 4: Loading and transforming data
19 Lessons-
StartModule introduction
-
StartIntroduction to Power Query
-
StartPower Query for Excel
-
StartAvailable data sources in AS
-
StartEditing queries to transform data
-
StartEditing query settings and steps
-
StartAvailable transformations
-
StartContext menus
-
StartAdding columns
-
StartM language introduction
-
StartM language reference
-
StartAppending queries
-
StartMerging queries
-
StartUsing queries as functions
-
StartAltering data sources
-
StartAltering permissions
-
StartModule 4 quiz
-
StartModule 4 lab
-
StartModule 4 lab solution
-
-
Module 5: Developing data models
24 Lessons-
StartModule introduction
-
StartWorking with data and diagram views
-
StartAdding additional tables
-
StartChanging existing tables
-
StartFiltering table data
-
StartConfiguring relationships
-
StartRelationship filter directions
-
StartRelationship properties
-
StartIntroduction to the DAX language
-
StartTable and column references
-
StartDAX operators
-
StartCreating calculated columns
-
StartCorrect level for calculated columns
-
StartCreating measures
-
StartCALCULATE function
-
StartData model vs report measures
-
StartHiding columns from clients
-
StartCreating hierarchies
-
StartData access modes
-
StartMinimizing model size
-
StartConnecting to Analysis Services with Excel
-
StartModule 5 quiz
-
StartModule 5 lab
-
StartModule 5 lab solution
-
-
Module 6: Creating suitable source data models
10 Lessons -
Module 7: What we do
13 Lessons -
Module 8: Enhancing data models
20 Lessons-
StartModule introduction
-
StartCreating calculated tables
-
StartCreating static tables
-
StartCreating and managing KPIs
-
StartConfiguring table behavior
-
StartConfiguring data categories
-
StartConfiguring data formats
-
StartConfiguring data types
-
StartConfiguring encoding hints
-
StartUsing other columns for sorting
-
StartConfiguring summarization
-
StartConfiguring other column properties
-
StartCreating calculation groups
-
StartDAX time intelligence
-
StartAuto-date table functions
-
StartCreating date tables
-
StartMark as date table
-
StartModule 8 quiz
-
StartModule 8 lab
-
StartModule 8 lab solution
-
-
Module 9: Processing deployed data models
19 Lessons-
StartModule introduction
-
StartProcessing core concepts
-
StartDatabase processing options
-
StartTable processing options
-
StartPartition processing options
-
StartScripting processing steps
-
StartScripting databases with TMSL
-
StartScripting databases with TMDL
-
StartProcessing from agent jobs
-
StartProcessing from SSIS
-
StartProcessing options for Azure AS
-
StartIntroduction to Azure Data Factory
-
StartEditing pipelines in ADF
-
StartScheduling pipelines with ADF triggers
-
StartAzure AS REST API
-
StartProcessing Azure AS from ADF
-
StartModule 9 quiz
-
StartModule 9 lab
-
StartModule 9 lab solution
-
-
Module 10: Securing data models
23 Lessons-
StartModule introduction
-
StartOverview of Analysis Srvices security
-
StartConfiguring role based security
-
StartAdding role members
-
StartRole table permissions
-
StartRole row filters
-
StartDynamic role row filters
-
StartTesting row filters
-
StartConfiguring object level security
-
StartIdentity aims
-
StartIntroduction to Microsoft Entra ID
-
StartMicrosoft Entra ID directory models
-
StartMicrosoft Entra ID Connect
-
StartManaged service identities
-
StartAssigning ADF permissions to Azure AS
-
StartAssigning ADF permissions to SQL Database
-
StartMinimizing database attack surfaces
-
StartConfiguring Azure server firewalls
-
StartEnterprise and personal gateways
-
StartTypical security architecture
-
StartModule 10 quiz
-
StartModule 10 lab
-
StartModule 10 solution
-
-
Module 11: Advanced Analysis Services concepts
17 Lessons-
StartModule introduction
-
StartCreating perspectives
-
StartConfiguring translations
-
StartLoading performance and partitions
-
StartDatabase table partitions
-
StartTabular data model partitions
-
StartAvoiding string collation issues
-
StartTracing server activity
-
StartBackup and restore databases
-
StartQuerying dynamic management views
-
StartCommon useful DMV groups
-
StartAMO core concepts
-
StartXMLA core concepts
-
StartChecking database consistency
-
StartTOM and TMSL core concepts
-
StartIntegrating with source control
-
StartModule 11 quiz
-
Analysis Services for Data Professionals
Learn to create user-friendly analytic models with SQL Server Analysis Services and Azure Analysis Services
Unlock your potential with Analysis Services!
Are you ready to elevate your skills in working with Analysis Services?
Our comprehensive course is your gateway to becoming proficient at working with both SQL Server Analysis Services, and with Azure Analysis Services. Ask Yourself:
- Have you worked with Analysis Services?
- Are you looking to get the best out of Analysis Services by building great data models?
- Do you have existing multi-dimensional models and need to move to tabular models?
- Would you like to be comfortable with how security applies to Analysis Services?
- Are you ready to move beyond the basics and learn from an expert?
If any of these relate to you, this course is tailor-made for you! Join us for detailed instruction, engaging practical exercises, and quizzes designed to reinforce your learning.
Don’t miss this opportunity to invest in your career and unlock your full potential in working with Analysis Services! This is one of the most comprehensive courses on the market today.
Course Curriculum
Greg Low
