- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft SQL Server Analysis Services (SSAS)
Take an extra 30% off this course! No coupon needed; auto applies in cart.
$20.00
Sale Ends Soon
- 00Days
- 00Hours
- 00Minutes
- 00Seconds
With this course, you will be able to become an expert in employing both engines within a company’s infrastructure. Analysis Services is composed of two powerful applications – VertiPaq and Data Mining for multidimensional cubes, as well as xVelocity for Tabular Data Models. It provides enterprise-level semantic data modeling abilities to construct business intelligence systems such as Power BI, Excel Reporting Services and other information visualization tools that can make your organization even more successful!
8 Training Hours
50 Videos
9 Topics
75 Practice Questions
Course Description
Analysis Services is a combination of two analytical engines (VertiPaq for multidimensional cubes and Data Mining and xVelocity for Tabular Data Models) 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. This course provides a full introduction to the use of both of these engines in an enterprise environment.
The third major component of the course is a form of Machine Learning called Data Mining. Data Mining is the analysis of large data set to reveal hidden patterns and trends. This course will teach you how to create a Data Mining solution, how to compare and validate different data mining options (models) for a given data set, and how to use your chosen model in a consumer-friendly client.
Your Training Instructor
James is a full-stack developer with over 40 years of experience. He has developed applications across all major industries and for Fortune 100 companies as well as local small businesses. James has also been teaching technology courses for over 20 years. In addition to his extensive background in technology, he has also worked as a professional opera singer.
Course Outline
Microsoft SQL Server 2019 Analysis Services (SSAS) Course Outline
Module 1 - Introduction to Business Intelligence and Data Modeling
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Business Intelligence
- 1.4 The Microsoft Business Intelligence Platform
- 1.5 Exploring a Data Warehouse
- 1.6 Exploring a Data Model
Module 2 - Multidimensional Databases
- 2.1 Module 2 Introduction
- 2.2 Introduction to Multidimensional Analysis
- 2.3 Overview of Cube Security
- 2.4 Creating and Configuring a Cube
- 2.5 Data Sources
- 2.6 Data Source Views
- 2.7 Adding a Dimension to a Cube
Module 3 - Cubes and Dimensions
- 3.1 Module 3 Introduction
- 3.2 Dimensions
- 3.3 Attribute Hierarchies and Relationships
- 3.4 Sorting and Grouping Attributes
- 3.5 Slowly Changing Dimensions
Module 4 - Measures and Measure Groups
- 4.1 Module 4 Introduction
- 4.2 Measures
- 4.3 Measure Groups and Relationships
- 4.4 Measure Group Storage
Module 5 - Introduction to MDX
- 5.1 Module 5 Introduction
- 5.2 MDX Fundamentals
- 5.3 Adding Calculations to a Cube
- 5.4 Querying a cube using MDX
Module 6 - Customizing Cube Functionality
- 6.1 Module 6 Introduction
- 6.2 Key Performance Indicators
- 6.3 Actions
- 6.4 Perspectives
- 6.5 Translations
Module 7 - Tabular Data Models
- 7.1 Module 7 Introduction
- 7.2 Introduction to Tabular Data Models
- 7.3 Creating a Tabular Data Model
- 7.4 Configure Relationships and Attributes
- 7.5 Configuring Data Model for an Enterprise BI Solution
Module 8 - Data Analysis Expressions (DAX)
- 8.1 Module 8 Introduction
- 8.2 DAX Fundamentals
- 8.3 Calculated Columns
- 8.4 Relationships
- 8.5 Measures
- 8.6 Time Intelligence
- 8.7 KPI
- 8.8 Parent - Child Hierarchies
Module 9 - Data Mining
- 9.1 Module 9 Introduction
- 9.2 Overview of Data Mining
- 9.3 Custom Data Mining Solutions
- 9.4 Validating a Data Mining Model
- 9.5 Consuming a Data Mining Model
- 9.6 Course Wrap Up
Microsoft SQL Server Analysis Services (SSAS)
$20.00
With this course, you will be able to become an expert in employing both engines within a company’s infrastructure. Analysis Services is composed of two powerful applications – VertiPaq and Data Mining for multidimensional cubes, as well as xVelocity for Tabular Data Models. It provides enterprise-level semantic data modeling abilities to construct business intelligence systems such as Power BI, Excel Reporting Services and other information visualization tools that can make your organization even more successful!
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
$39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$39.00
Dive into the depths of SQL Server with this Microsoft SQL – SQL Big Data course and discover one of its most invaluable tools, SQL Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine.
$49.00
Python, which has been around for nearly three decades, is one of the most widely used programming languages in existence. This Python programming course is particularly helpful to data scientists and machine learning professionals, Python stands out due to its ease-of-use – it’s no wonder that universities now make it their go-to language when teaching coding.
$49.00
In this Microsoft 70-487 course you will learn how to access data, query and manipulate data by using the entity framework, create and consume web API-based services, design and implement web services, and deploy in Microsoft Azure and Web Services.
$49.00
You should Learn Java as it is a must-have technology for a range of applications and websites, including business solutions, data centers, game consoles, utilities, desktop computers (as well as laptops and smartphones). That’s why this online training course explores the whole spectrum of Java Programming from beginner to advanced. With it you can confidently tackle any challenge that comes your way!