- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft SQL Server Analysis Services (SSAS)
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!
Included In This Course
Included In This Course
8 Training Hours
50 On-demand Videos
Closed Captions
9 Topics
75 Prep Questions
Certificate of Completion
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.
Frequently Asked Questions About Microsoft SQL Server Analysis Services (SSAS)
Who is the instructor for the course?
The course is led by James Ring-Howell, a Microsoft Certified Trainer, Developer, and Database Expert. James is a full-stack developer with over 40 years of experience, and he has developed applications across all major industries, for Fortune 100 companies as well as local small businesses
How is this Microsoft course delivered?
The course is delivered online, and you can access it anytime with the All Access Monthly Subscription. The subscription not only gives you access to this course but also to over 2,500 hours of on-demand content. You can start a 7-day free trial with no obligation, and you have the option to cancel anytime​.
What’s the history of SSAS? How has it evolved?
In 1996, Microsoft entered the OLAP Server industry after acquiring Panorama Software’s OLAP software technology. The technology was later renamed to Analysis Services in 2000 when data mining services were added. Analysis Services 2000 saw several improvements, including a more flexible dimension design and an advanced calculation engine. Microsoft Analysis Services released the Unified Dimensional Model (UDM) in 2005 as a major update. This model supports MOLAP, ROLAP, and HOLAP all in one place, meaning it remains neutral in the ongoing debate between MOLAP and ROLAP in OLAP products.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
Microsoft SQL Server 2019 Analysis Services (SSAS) Course Content
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
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.
$49.00
OR
Subscribe To All-Access
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
$49.00 $14.99 Monthly
Microsoft SQL Server Analysis Services (SSAS)
Microsoft SQL Server Analysis Services (SSAS)
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
7 Days Free - $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
$49.00
Learn how to handle Big Data with Microsoft SQL 2019. Master the art of data analysis & management with our online training course. Enroll now!
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
Master the skills to effectively manage SQL Server with our Microsoft 70-764 training course. Get started today!
The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks.
$49.00
Learn Java programming language with our online course and gain skills to build robust applications. Join now and get certified!
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!
I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.