What is Analysis Services? Overview What's new in SQL Server Analysis Services 2016 What's new in SQL Server Analysis Services 2017 New and recently updated articles Tools and applications Comparing Tabular and Multidimensional solutions Analysis Services features supported by SQL Server 2016 editions Backward compatibility (SQL Server 2016 Analysis Services) Backward compatibility (SQL Server 2017 Analysis Services) Globalization and translation Languages and collations Translations Currency conversions Tips and best practices Samples Analysis Services samples Tutorials Tabular Modeling (Adventure Works Tutorial) Lesson 1: Create a New Tabular Model Project Lesson 2: Add Data Lesson 3: Mark as Date Table Lesson 4: Create relationships Lesson 5: Create calculated columns Lesson 6: Create measures Lesson 7: Create Key Performance Indicators Lesson 8: Create perspectives Lesson 9: Create hierarchies Lesson 10: Create partitions Lesson 11: Create roles Lesson 12: Analyze in Excel Lesson 13: Deploy Supplemental Lesson - Implement dynamic security by using row filters Supplemental Lesson - Configure reporting properties for Power View reports Multidimensional modeling (Adventure Works Tutorial) Tutorial scenario Install sample data and projects for the Analysis Services Multidimensional modeling tutorial Lesson 1: Defining a data source view within an Analysis Services project Lesson 1-1 - Creating an Analysis Services project Lesson 1-2 - Defining a data source Lesson 1-3 - Defining a data source view Lesson 1-4 - Modifying default table names Lesson 2: Defining and deploying a cube Lesson 2-1 - Defining a dimension Lesson 2-2 - Defining a cube Lesson 2-3 - Adding attributes to dimensions Lesson 2-4 - Reviewing cube and dimension properties Lesson 2-5 - Deploying an Analysis Services project Lesson 2-6 - Browsing the cube Lesson 3: Modifying measures, attributes and hierarchies Lesson 3-1 - Modifying measures Lesson 3-2 - Modifying the customer dimension Lesson 3-3 - Modifying the product dimension Lesson 3-4 - Modifying the date dimension Lesson 3-5 - Browsing the deployed cube Lesson 4: Defining advanced attribute and dimension properties Lesson 4-1 - Using a modified version of the Analysis Services tutorial project Lesson 4-2 - Defining parent attribute properties in a parent-child hierarchy Lesson 4-3 - Automatically grouping attribute members Lesson 4-4 - Hiding and disabling attribute hierarchies Lesson 4-5 - Sorting attribute members based on a secondary attribute Lesson 4-6 - Specifying attribute relationships between attributes in a user-defined hierarchy Lesson 4-7 - Defining the unknown member and null processing properties Lesson 5: Defining relationships between dimensions and measure groups Lesson 5-1 - Defining a referenced relationship Lesson 5-2 - Defining a fact relationship Lesson 5-3 - Defining a many-to-many relationship Lesson 5-4 - Defining dimension granularity within a measure group Lesson 6: Defining calculations Lesson 6-1 - Defining calculated members Lesson 6-2 - Defining named sets Lesson 7: Defining Key Performance Indicators (KPIs) Lesson 7-1 - Defining and browsing KPIs Lesson 8: Defining actions Lesson 8-1 - Defining and using a drillthrough action Lesson 9: Defining perspectives and translations Lesson 9-1 - Defining and browsing perspectives Lesson 9-2 - Defining and browsing translations Lesson 10: Defining administrative roles Lesson 10 - Granting process database permissions Data Mining How-to Tabular modeling Multidimensional modeling Data mining Power Pivot for Sharepoint Manage servers Trace-events Developer Tabular models Tabular Model Programming for Compatibility Level 1200 and higher Tabular Model Scripting Language (TMSL) Tabular Model Scripting Language (TMSL) commands Tabular Model Scripting Language (TMSL) objects Tabular Model Programming for Compatibility Levels 1050 and 1103 Multimdimensional models Analysis Services Scripting Language (ASSL) + ADOMD.NET + Analysis management objects + OLAP logical + OLAP physical + Extending OLAP + Schema rowsets Analysis Services Scripting Language (ASSL for XMLA) Reference Data Analysis Expressions (DAX) on MSDN Data Mining Extensions (DMX) Multidimensional Expressions (MDX) Power Query M PowerShell Server properties XML for Analysis (XMLA)