Microsoft SQL Server 2019 Analysis Services (SSAS)

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. You will learn about creating cubes and their constituent components, the use of MDX to query the cubes, as well as how to customize a cube with KPI, actions, perspectives, and language translations. You will also learn about the differences and similarities between cubes and tabular data models, how to create a tabular data model, and the use of DAX to query the model.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.Key Learning Topics In This Course You will learn about creating cubes and their constituent components The use of MDX to query the cubes How to customize a cube with KPI, actions, perspectives, and language translations. Differences and similarities between cubes and tabular data models, How to create a tabular data model The use of DAX to query the model. Course Video Content: 8 Hours 56 MinutesTest Questions: 75 Course Content Module 1 - Introduction to Business Intelligence and Data Modeling1.1 Course Introduction1.2 Module 1 Introduction1.3 Introduction to Business Intelligence1.4 The Microsoft Business Intelligence Platform1.5 Exploring a Data Warehouse1.6 Exploring a Data ModelModule 2 - Multidimensional Databases2.1 Module 2 Introduction2.2 Introduction to Multidimensional Analysis2.3 Overview of Cube Security2.4 Creating and Configuring a Cube2.5 Data Sources2.6 Data Source Views2.7 Adding a Dimension to a CubeModule 3 - Cubes and Dimensions3.1 Module 3 Introduction3.2 Dimensions3.3 Attribute Hierarchies and Relationships3.4 Sorting and Grouping Attributes3.5 Slowly Changing DimensionsModule 4 - Measures and Measure Groups4.1 Module 4 Introduction4.2 Measures4.3 Measure Groups and Relationships4.4 Measure Group StorageModule 5 - Introduction to MDX5.1 Module 5 Introduction5.2 MDX Fundamentals5.3 Adding Calculations to a Cube5.4 Querying a cube using MDXModule 6 - Customizing Cube Functionality6.1 Module 6 Introduction6.2 Key Performance Indicators6.3 Actions6.4 Perspectives6.5 TranslationsModule 7 - Tabular Data Models7.1 Module 7 Introduction7.2 Introduction to Tabular Data Models7.3 Creating a Tabular Data Model7.4 Configure Relationships and Attributes7.5 Configuring Data Model for an Enterprise BI SolutionModule 8 - Data Analysis Expressions (DAX)8.1 Module 8 Introduction8.2 DAX Fundamentals8.3 Calculated Columns8.4 Relationships8.5 Measures8.6 Time Intelligence8.7 KPI8.8 Parent - Child HierarchiesModule 9 - Data Mining9.1 Module 9 Introduction9.2 Overview of Data Mining9.3 Custom Data Mining Solutions9.4 Validating a Data Mining Model9.5 Consuming a Data Mining Model9.6 Course Wrap Up LEARN365 Courses Include 12 Months Unlimited Online Access to: Expert Instructor-Led Training: Learn 365 uses only the industry's finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7. Visual Demonstrations & Multimedia Presentations: Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor. Learn 365 always focuses on real world scenarios and skill-set development. Quizzes & Exam Simulators: Learn 365's custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course. Learn 365 courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.