SQL Server Analysis Services for beginners -SSAS (2022)

About Course

Analysis Services is an analytical data engine  used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms

Tabular models in Analysis Services are databases that run in-memory or in DirectQuery mode, connecting to data from back-end relational data sources. By using state-of-the-art compression algorithms and multi-threaded query processor, the Analysis Services VertiPaq analytics engine delivers fast access to tabular model objects and data by reporting client applications like Power BI and Excel.

Show More

What Will You Learn?

  • Setup Analysis Services Environment
  • Create a Tabular Model
  • Connect to data source
  • Create Table Relationships
  • Create Calculated Columns
  • Create Measures
  • Create Key Performance Indicators

Course Content

01 – Installations

  • 001 Introduction
    00:00
  • 002 What is SQL Server
    00:00
  • 003 SQL Server Editions
    00:00
  • 004 Download SQL Server
    00:00
  • 005 Install SQL Server
    00:00
  • 006 Install SSMS
    00:00
  • 007 Connect SSMS to SQL Server
    00:00
  • 008 Install Sample Database
    00:00
  • 010 Installing SSAS
    00:00
  • 011 Connecting to SSAS
    00:00
  • 012 What is Visual Studio
    00:00
  • 013 Installing Visual Studio
    00:00
  • 014 Installing SSDT
    00:00
  • 015 Installing SSDT Designers
    00:00

02 – Creating a Tabular Model