Microsoft SQL Server Analysis Services - SSAS (Tabular DAX)

Download SQL Server Developer Edition 2022 from the free specialized editions. Choose a custom install to access SSAS, SSIS, and SSRS, with the developer edition free but not for production.

Learn how to install SQL Server Developer 2022, configure database engine and Analysis Services in tabular mode, choose the developer edition, set authentication, and prepare the instance for front-end setup.

Install visual studio 2022 to build SQL Server Analysis Services projects, meeting 64-bit Windows and hardware requirements, and explore older 2019 and free community editions for data solutions.

Install Visual Studio 2022 and the Microsoft Analysis Services projects 2022 extension, then create mdx analysis and analysis services multidimensional or tabular projects.

Explore creating a pivot table analysis from our SSAS model by importing the fact internet sales table, configuring pivot fields in Excel, and creating an explicit measure for sales amount.

Explore how to manage and configure columns in SSAS tabular models: create relationships, copy data, insert, rename, freeze or hide columns from client tools, adjust width, and use perspectives.

Create an SSAS tabular model by importing data from SQL Server Adventureworks DW, define relationships, add a sum of sales amount measure, and build a pivot table in Excel.

Discover pivot table design: configure rows, columns, and values; switch layouts (compact, outline, tabular); adjust subtotals, grand totals, repeat labels, blanks, and include filtered items in totals.

Explore pivot table options in SSAS tabular models and learn to show items with no data on rows and columns, enabling analysis of unsold products across tables.

Practice activity four shows manipulating pivot tables in SAS tabular: switch to outline layout, add subtitles, and create running total of sales by region with a slicer for English education.

Explore DAX functions for SSAS tabular, focusing on the IF function to create calculated columns from a logical test. Test results in pivot tables and manage slicers and refresh.

Use the blank and is blank functions in Tabular DAX to produce blanks instead of zeros, ensuring accurate counts and averages in sales analysis.

Learn the logical functions in ssas tabular dax, including coalesce, if, and if error, with a practical example of handling division by zero by returning blanks.

Explore rounding functions in ssas tabular dax, including int, trunk, ceiling, floor, iso dot ceiling, and em round, to eliminate rounding errors in pivot table totals.

Explore the abs and sign functions, using absolute values and sign to build a switch-based logic that classifies sales amounts as less, same, or more.

Explore trigonometric and statistical functions, including degrees and radians conversion, and learn how to use rank.eq to rank values in a dataset, with practical examples like sales amount.

Explore other text functions in SSAS tabular DAX, including concatenate and concatenatex, combined values with delimiters, distinct, exact, lower and upper, repeat, Unicode, and trim.

Explore information functions in SSAS tabular DAX, including contains, contains rows, contains string, isblank, mod, and is error for handling errors like division by zero.

Parse addresses and birth dates by building dax calculated columns with functions like find, search, left, mid, substitute, and trim; handle errors and format dates.

Learn how to use sumx and calculate to compute sales amounts within different contexts. Apply filter to drill down the data, such as restricting fact internet sales by promotion key.

Learn to remove filters from the context with all and all except, using category, promotion key, and currency key, and compute the grand total and percentage of sales amount.