Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)

92

LESSONS

ALL

SKILL LEVEL

5:30 hr

DURATION

ENGLISH

AUDIO

ENG

SUBTITLES

OVERVIEW

This course covers one of the most useful add-ins in Microsoft Excel – PowerPivot – and 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).

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.

MODEL USING POWERPIVOT

  • Creating our first model in PowerPivot.
  • Using our first model in Excel.
  • Creating and deploying our first model in Excel.
  • Adding a second table – Importing Data from SQL Server.
  • Importing Data from SQL Server.

USING THE TABULAR MODEL

  • AdventureWorksDW.
  • Creating and deploying our first model in SSAS.
  • Adding additional tables.
  • Importing Data from Excel.

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.

OTHER FUNCTIONS

  • Statistical.
  • Mathematical.
  • Text.
  • Information.
  • Filter and Value.
  • Time Intelligence.

REVIEWS

“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

.