-
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
19 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
-
-
Module 3: Creating tabular projects
18 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
-
-
Module 4: Loading and transforming data
18 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
-
-
Module 5: Developing data models
23 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
-
-
Module 6: Creating suitable source data models
10 Lessons -
Module 7: What we do
14 Lessons-
StartModule introduction
-
StartPrefer cloud-based DB
-
StartDataLoad schema
-
StartSDU_Tools schema
-
StartStaging schema
-
StartExternal tables
-
StartDataModel schema
-
StartAnalytics schema
-
StartTabular data model
-
StartPower BI
-
StartReporting Services
-
StartAzure Data Factory
-
StartSSIS
-
StartModule 7 quiz
-
-
Module 8: Enhancing data models
22 Lessons-
StartModule introduction
-
StartCreating date tables
-
StartCreating tables from SQL queries
-
StartMark as date table
-
StartDAX time intelligence
-
StartCreating calculated tables
-
StartAuto-date table functions
-
StartCreating static tables
-
StartAllowed data types
-
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
-
StartUSERELATIONSHIP
-
StartModule 8 quiz
-
StartModule 8 lab
-
-
Module 9: Processing deployed data models
18 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
-
-
Module 10: Securing data models
22 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
-
-
Module 11: Advanced Analysis Services concepts
18 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
-
StartExtracting VPAX files for optimization
-
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
