SSAS Tabular Model Training Course

Course Price: £183.33 excl. VAT (£220.00 incl. VAT)
Total Duration: 10 Hours
Course level: Intermediate
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

Please check back our website again soon for dates or contact us.

Introduction to SSAS Tabular
- Introduction to SSAS Tabular
- Creating a Project
- Relationship and measures
- Measures and their usage
- Advantages of Tabular model
- Limitations
Tabular Model Basics
- Tabular – Development Server
- Workspace Server configuration
- SSAS Configuration management
- Project, Model – Properties
Migrating Power Pivot Model to tabular
- Power Pivot – Overview
- Usage and Limitations of Power Pivot
- Steps to Migrate for Tabular Model
- Points to consider
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
Manage Tabular Model using SSMS
- Managing Server Properties
- Managing Cube properties
- Explore – Cube
Introduction to DAX (Data Analysis Expression) - I
- Introduction to DAX Functions
- Create a New Tabular Environment
- Verify the New Tabular Environment and Review Calculated Columns
- DAX Calculations: Examples
- DAX RELATED() Function
- DAX Text-Type Functions
Introduction to DAX (Data Analysis Expression) - II
- DAX Date/Time-Type Functions
- DAX Logical-Type Functions
- DAX Aggregate and Table Functions
- Time Intelligence Functions Overview
- Review Measures and Evaluation Context
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
Advanced DAX
- EVALUATE Options
- Query Output The Basics
- Filters
- Grouping Basics
- SUMMARIZE
- Working with Inline Measures
Time and Date Calculation
- Date Table Introduction
- Date Table Design & Creation
- DAX Time/Date Functions
- Opening/Closing Balances
Advanced SSAS Tabular concepts
- Role-Playing Dimensions
- Parent-Child Hierarchy
- Many-to-Many Relationships

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.

Related Courses

Newsletter Sign-up

First Name

Last Name

Email address

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

Tel: +44 (0)208 432 6218

Database, SQL and Reporting

Web Design and Development

Programming Languages and Testing