90
LESSONS
ALL
SKILL LEVEL
6:41 hr
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
OVERVIEW
This course covers the Tabular model in SQL Server Analytical Services.
On completion, you will be able to:
- Extract data from multiple tables.
- Create connections between the tables.
- Develop the model using DAX functions.
- Create analyses in Excel.
.
WHO IS THE COURSE FOR?
This course is for those who want to create analyses. This course is NOT for those who want to learn SSAS (MDX version), which is this course.
No prior knowledge of SSAS is required but a basic understanding of Excel is assumed.
.
LEARNING PATH
INSTALLING SOFTWARE
- Install SQL Server Developer 2022.
- Install Visual Studio 2022.
- Installing SSAS in Visual Studio 2022.
CREATE YOUR FIRST MODEL
- Creating our first model in SSAS.
- Using our first model in Excel.
- Creating and deploying our first model in Excel.
- Adding a second table
- Importing Data from SQL Server.
DEVELOPING THE DATA MODEL
- Filtering, sorting and formatting fields.
- Hiding columns from Client Tools, and other column tools.
- Refreshing (or processing) data.
- Creating quick measures.
- Perspectives.
- Hierarchies.
PIVOT TABLES FUNCTIONALITY
- PivotTable structure, and non-Visual Totals.
- Show no data in rows and columns.
- Create running totals.
- Slicers and Timelines.
- Using formulas to query Data Model (Advanced).
DAX FUNCTIONS INTRODUCTION
- Calculated columns.
- Basic operators.
- IF.
- BLANK and ISBLANK.
- AND, OR and NOT.
- SWITCH.
OTHER DAX FUNCTIONS
- Statistical.
- Mathematical.
- Text.
- Information.
- Filter and Value.
- Time Intelligence.
REVIEWS FROM THE PREVIOUS COURSE
“In just the first few lessons, I have already been able to apply what I have learned at my job. Thank you for this course!” Cynthia
“The Instructor is easy to understand and he gives exercises to test your understanding which is what I prefer rather than just listening to lectures. I will definitely take more of Mr Burton’s classes as I like his teaching style.” Tamuka
.
