SSAS Tabular Model with Power BI - A comprehensive training

Import tables and secure the SSAS tabular model. Build a diagram linking geography, reseller, product category and subcategory to fact internet sales, and apply filters at table and model levels.

Explore star and snowflake schemas in SSAS tabular, linking a fact table to dimension tables such as customer and product, and understand how normalization and keys influence relationships and calculations.

Explore role playing dimensions in ssas tabular model by mapping a single date dimension to due date, order date, and ship date with active relationships and calculator tables for performance.

Deploy the tabular model to analysis services, connect Power BI to the new database, rename and sort the English week column by day number, and hide unused columns.

Define a date table for time intelligence, then build a product hierarchy from category to subcategory to product name, deploying and refreshing the model to display the hierarchy automatically.

Create and manage perspectives in an SSAS tabular model to tailor data visibility for the marketing team, selecting relevant tables and columns and deploying to Power BI.

Create calculated columns and measures in the ssas tabular model to compute total sales, deploy to power bi, and adjust currency formatting and display properties for accurate reporting.

Create and compare KPIs in SSAS Tabular model using a time intelligence function to calculate last month sales versus this month, assign target values, and visualize status with color-coded indicators.

Learn to partition a large SSAS tabular model fact table using script and UI, creating year-based partitions to minimize processing time in analysis services.

Explore SSAS tabular model processing options at the database level, including process database default, full, clear, and recalculate, and learn how partitions manage data without duplicates and recalculate hierarchies.

Learn how to automate SSAS tabular model processing with SQL Server Agent, including table, partition, and database level options, scripting, and daily scheduling for incremental and full refreshes.

Implement row level security in an SSAS tabular model with DAX scripts by creating roles, assigning test users, and applying filters on the customer table by English occupation.

Learn to deploy a SSAS tabular model database using a script, preserving existing partitions and roles while deploying via analysis services with correct server and database settings.