• Venue
  • Register
  • FAQs
  • Contact
  • Time Zone

SSAS Tabular Model

Batch Price From £150 (approx. $187 USD) View Dates & Prices
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.

Requirements

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

All Training Physical Classes Virtual Classes
Time Zone:
There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later.

Course Content

  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

Share This Course

Newsletter Sign-up

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT
Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom
UK: +44 (0)208 432 6218
USA: +1 610-234-7870
CANADA: +1 416-900-1211

Share this page now!

2012 - 2024 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992.