SQL Server SSAS (Tabular) - Analysis Services & DAX

Name: SQL Server SSAS (Tabular) - Analysis Services & DAX
Rating: 4.2 (339 reviews)

Data Science + Microsoft BI Introduction. Create your own SSAS Tabular Cubes from SQL databases 2017. Trainer is MCSE

Created bySteffen Weiler

Last updated 7/2020

English

English [Auto],

What you'll learn

How to develop your own tabular Cubes with Visual Studio
Analyse and work with Big Data
Design a valid tabular data Model
Create calculated columns / measures / hierarchies
Learn DAX Syntax
Setup security guidance
Query Tabular Cubes

Course content

6 sections • 28 lectures • 3h 40m total length

Introduction to Analysis Services5:34
Explore what analysis services is, how to install it with secret server, and the two engines—multidimensional and tabular—with DAX—highlighting fast in‑memory analytics in the tabular engine.
Differences between Multidimensional and Tabular Cubes8:01
Compare multidimensional and tabular cubes by contrasting row-based versus columnar in-memory storage, highlight compression and real-time measures, and note scripting language differences and on-prem and cloud deployment options.
SSAS Architecture9:41
Explore the SSAS architecture, comparing multidimensional and tabular engines, their query languages, and how client tools like Power BI and Excel connect to a unified semantic model.
SSAS vs. Power BI: What to choose?13:00
Compare SSAS tabular and Power BI for data modeling and reporting, examining shared development, data volume, security, incremental refresh, and model transferability across SSAS and Power BI.

Our first sample project11:56
Create your first sempre project in Visual Studio by loading tables from SQL Server into a tabular model, then explore measures, calculated columns, and relationships.
Workspace Server7:57
Explore how the workspace server stores tabular data in a workspace database within Analysis Services, either as an integrated workspace in Visual Studio or on a remote server.
Deployment Options & Project Properties6:34
Explore project properties for SQL Server SSAS Tabular deployments, including deployment server, deployment addition, database name, and processing options like not processing versus full processing.
Model Properties (Workspace Retention & Database Backup)10:05
Explore model properties, including workspace retention and data backup, in Visual Studio for SQL Server SSAS Tabular. Understand when to keep in memory, unload, or delete the workspace.
Calculated Columns6:50
Explore calculated columns in a tabular SSAS model by creating a new column in the fact sales table, computing values in memory, and understanding when to use them versus measures.
Create Measures9:56
Learn to create measures in SQL Server SSAS tabular models, compute at query time with DAX, compare measures with calculated columns, and explore measures in the tabular model explorer.
Create Calculated Tables5:58
Create calculated tables in SQL Server Analysis Services tabular models using DAX formulas like ADDCOLUMNS to derive new in-memory tables stored in the model during processing.
Visual Studio Views & Hierarchies5:27
Explore Visual Studio's data view and diagram view for table management and relationships; create hierarchies in the diagram view, using product table fields like brand name and color name.
Querying with Excel7:47
Learn to query a tabular cube from Excel using Analyze in Excel, leveraging measures, hierarchies, and pivot tables for immediate results and live workspace connections.
Querying with Power BI5:31
Learn to query a tabular analysis services cube with Power BI using the native language, compare it to Excel's MDX, and explore live connections, measures, and cross-client calculations.
Useful Tools0:07

Loading Data from SQL Server5:37
Load data into the SSAS tabular cube using the table import wizard, setting server and database names. Choose impersonation between Windows authentication and a service account to control access.
Issues when working with Big Tables6:50
discover how to manage big tables in tabular cubes by using development filters and views, avoid import pitfalls, and keep production stable when source changes occur via view-based data sources.
General Guidelines12:00
Learn naming guidelines for tables, columns, and measures in a tabular model, including refactoring names, using friendly names and display folders to improve readability and debugging.
Perspectives5:25
Learn to use perspectives in ssas tabular models to tailor which measures and columns users see, via metadata, while noting perspectives are not security features.
Translations9:39
Translate metadata into multiple languages using the translations feature in sql server analysis services tabular, export and import translations through visual studio and the model translation tools.
KPI11:02
Learn to build KPIs in a tabular cube with DAX measures like margin percent, dynamic targets against the overall average, and color-coded status indicators.

Security Features10:10
Explore granular security in Analysis Services tabular, including static and dynamic role-based access, permissions (read, process, admin), row filters, and managing members via Active Directory and groups.
Admin Role6:12
Learn how the admin role in SQL Server SSAS tabular overrides security and how to manage admin rights in management studio with full control or read-only permissions.
Fixed Data Security7:55
Create a new filter context in tabular analysis services and assign a role to restrict users to German customers, ensuring cross-table data is filtered accordingly and tested with Excel.
Testing fixed Data Security in Excel10:51
Learn how to set up a date table and role filters in a tabular model to show sales by calendar year and color, using related and bidirectional filters with tradeoffs.

Requirements

You don't need specific knowledge before starting this course
No prior knowledge of SSAS, DAX or Dimensional modeling is required

Description

This is the number 1 course for learning Tabular SSAS according to many successful real life customers. Most times customers didn't know how to handle SSAS (Analysis Services) because they were missing the technical basis to develop their business intelligence solution. Occasionally they already have a multidimensional Analysis Services Model, which offers some drawbacks in comparison with the new possibilities, that come with Tabular Cubes.

I have another course that deals with multidimensional Cubes. Feel free to preview section "Differences between Multidimensional and Tabular Cubes" to consider which course fits better.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Welcome to my practical Course on SSAS Tabular Cube Tutorial for non techies // Power BI // Practice:

You are looking for modern and meaningful Business Intelligence (BI) reports? So far, you're missing the experience and the confidence in your technical skills, to just get started and create a comprehensive data model, that suits your needs of a modern state of the art BI solution?

Or are you about to make a big move into a highly trained job and therefore want to improve your data analytics skills? The business intelligence market is one of the fastest growing branches of business, according to relevant expert opinions. Increase your personal value for your current employer or future companies, by convincing them with your practical, custom-designed Know-How.

This tutorial is specially for people, who like to justify operational decisions on solid data with the help of SSAS, Excel and Power BI.

You are going to learn in this course how to integrate data in SQL Server, how to set up your own tabular cubes in SSAS and at the end, how to retrieve the data through modern Front-end tools. Furthermore this is not an abstract high-level tutorial, but rather a self practicing course.

I will provide you with all the Files, scripts, software which you need in this course and going to show you step by step how to install SQL Server and it's components (SSAS, SSIS, SSRS). We will work with the newest SQL Server 2017 and Power BI version, that for training reasons are completely free of charge!

Don't hesitate to improve your knowledge and increase your business intelligence job chances. Learn to love SSAS and handle it like a pro.

Do the first step with this course and get insights to a whole new view inside the world of data analysis!

Note: In this course you'll also get downloadable source code.

Who this course is for:

Technical / reporting users that want to extend their knowledge and want to create your own state of the art basis for reports
This course is for those who want to start a career in data science & analytics (Students)
This course is specially designed for those working or who want to work in the role of MS BI Architect, MDX Developer, SSAS Administrator, SSAS Architect, SSAS Developer, Data Modeler, MS BI Developer, SSAS Performance Engineering Specialist and others

SQL Server SSAS (Tabular) - Analysis Services & DAX

What you'll learn

Explore related topics

Course content

Einleitung4 lectures • 36min

Technical Setup2 lectures • 20min

Starting with Visual Studio & Tabular Cubes11 lectures • 1hr 18min

Advanced Tabular Features6 lectures • 51min

Security4 lectures • 35min

Wrap Up1 lecture • 1min

Requirements

Description

Who this course is for: