Regular Course Price: £150.00   
Total Duration: 5 Hours
Course level: Beginner
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course.

Course Overview:
This course introduces SQL Server Analysis Services Tabular to deliver business intelligence solutions. The course helps those new to SSAS Tabular model and relate data from diverse sources, and to then build and query basic Tabular models.

Skills Required

Knowledge about SQL Server and Data Warehouse concepts. Our Database Design with Microsoft SQL Server and SQL Server Integration Services (SSIS) Training Courses cover all of the prerequisites.

Course Dates, Prices & Enrolment

Dates and Times
(in the UK)
Dates and Times
(if not in the UK)
Online Training using Zoom 24 Jun 2021 - 25 Jun 2021
Thursday & Friday
11am - 1:30pm
Start Date & Time
End Date & Time
Enrol Now

Full Course Outline

  1. Introduction to SSAS Tabular
    • Introduction to SSAS Tabular
    • Creating a Project
    • Relationship and measures
    • Measures and their usage
    • Advantages of Tabular model
    • Limitations
  2. Tabular Model Basics
    • Tabular – Development Server
    • Workspace Server configuration
    • SSAS Configuration management
    • Project, Model – Properties
  3. Tabular Model – Design
    • Creating new model
    • Importing data from different sources
    • Create and Maintain relationship across data sources
    • Creating measures and their usage
    • Creating calculated columns
    • Creating Hierarchies based on data sources
    • Deployment
  4. Manage Tabular Model using SSMS
    • Managing Server Properties
    • Managing Cube properties
    • Explore – Cube
  5. Querying SSAS Tabular Model
    • Introduction and Objectives
    • Language Options and Editors
    • Language Options DAX and MDX
    • Query With Excel Basics
    • Query With Excel PivotTables
    • PivotTables - Create With Tabular Data
    • PivotTables - Slice, Sort, and Filter
    • PivotTables - Named Sets Overview
    • PivotTables - Excel Cube Formulas
    • Excel- Power View Intro and Connections
    • Excel - Create the Basic Power View Report
    • Excel - Work With Power View Reports

Course Tutors

The course is working as an independent SQL BI consultant in the UK. He is a specialist consultant for building CI (Continuous Integration) solution for BI projects (SSIS, SSRS). He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). He has been presenting sessions in SQLBits, SQLPass and London SQL Server user Group since 2015.

Save Money with Packages

SAVE more than 15% by booking this course with other related courses as shown below:

Newsletter Sign-up

Have a Question?