Microsoft Power Pivot Excel and SSAS Tabular DAX model

Visualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool.
Microsoft Power Pivot Excel and SSAS Tabular DAX model
File Size :
4.02 GB
Total length :
5h 28m

Instructor

Phillip Burton

Language

Last update

11/2023

Ratings

4.5/5

Microsoft Power Pivot Excel and SSAS Tabular DAX model

What you’ll learn

Extract data from multiple tables.
Create connections between the tables.
Develop the model using DAX functions.
Create analyses in Excel.

Microsoft Power Pivot Excel and SSAS Tabular DAX model

Requirements

You need to be able to use Microsoft Excel, at least at a basic level – but the more, the better.
If you are going to use SSAS, then you need to know how to install programs.

Description

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 Smith”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 Mazana——————This course covers one of the most useful add-ins in Microsoft Excel, PowerPivot, and the Tabular model in SQL Server Analytical Services.We’ll activate PowerPivot if you have the right version of Excel, and if not, then we’ll install SQL Server on your computer, which can do the same job. We’ll install the Developer edition, which used to cost $100, for free.After PowerPivot is activated, or SQL Server is installed, we’ll create our first analysis in Excel or SQL Server in just a matter of minutes.After only these first few minutes, you will be streets ahead of anyone who doesn’t know anything about Power Pivot.After this introduction, we’ll go into some detail into PowerPivot or SSAS – the initial data, and the various options that are available to you. We will go into advanced options that most people don’t even know about, but which are very useful.Then we’ll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too.By the end, you will be an Expert user of both PowerPivot and SSAS, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able to help others with their data analysis.It will assist with the Model Data section of Microsoft exam 70-779 “Analysing and Visualizing Data with Microsoft Excel”.It will also assist with the “Design a tabular BI semantic model” and “Develop queries using Data Analysis Expressions (DAX)” section of Microsoft exam 70-768 “Developing SQL Data Models”.

Overview

Section 1: Welcome

Lecture 1 Welcome

Lecture 2 Welcome to Udemy

Lecture 3 Introduction to Udemy

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 What will we learn?

Lecture 6 Software Requirements – PowerPivot

Lecture 7 Source data

Lecture 8 Activating PowerPivot on Excel 2013 and 2016

Lecture 9 Installing PowerPivot on Excel 2010

Section 2: Creating our first model using PowerPivot (Excel)

Lecture 10 Creating our first model in PowerPivot

Lecture 11 Using our first model in Excel

Lecture 12 Creating and deploying our first model in Excel 2010

Lecture 13 Adding a second table – Importing Data from SQL Server

Lecture 14 Importing Data from SQL Server

Lecture 15 Practice Activity Number 1

Lecture 16 Practice Activity Number 1 – Solution

Section 3: Installing SQL Server 2019 Developer and Visual Studio 2019

Lecture 17 Installing SQL Server 2022 Developer and Visual Studio 2022

Lecture 18 Downloading SQL Server Developer 2022

Lecture 19 Installing SQL Server Developer 2022

Lecture 20 Installing SQL Server Management Studio (SSMS)

Lecture 21 Installing Visual Studio 2022

Lecture 22 Installing SSAS in Visual Studio 2022

Lecture 23 Is your Visual Studio a trial version? No!

Section 4: Using the Tabular Model (SSAS in SQL Server)

Lecture 24 Downloading AdventureWorksDW

Lecture 25 Attaching AdventureWorksDW

Lecture 26 Visual Studio 2022

Lecture 27 Creating and deploying our first model in SSAS

Lecture 28 Adding additional tables

Lecture 29 Introduction to Practice Activity

Lecture 30 Practice Activity Number 2

Lecture 31 Practice Activity Number 2 – Solution

Lecture 32 Importing Data from Excel

Lecture 33 Having problems importing from Excel?

Section 5: Developing the Data Model

Lecture 34 Practice Activity Number 3

Lecture 35 Filtering, sorting and formatting fields

Lecture 36 Hiding columns from Client Tools, and other column tools

Lecture 37 Refreshing (or processing) data

Lecture 38 Creating quick measures

Lecture 39 Perspectives

Lecture 40 Hierarchies

Lecture 41 Practice Activity Number 4

Lecture 42 Do you want more practice setting your data model?

Section 6: Pivot Tables functionality

Lecture 43 PivotTable structure, and non-Visual Totals

Lecture 44 Show no data in rows and columns

Lecture 45 Create running totals

Lecture 46 Slicers and Timelines

Lecture 47 Using formulas to query Data Model (Advanced)

Section 7: An introduction to DAX functions, including Logical functions

Lecture 48 DAX functions – An Introduction

Lecture 49 Calculated columns – an introduction

Lecture 50 Basic operators

Lecture 51 IF

Lecture 52 BLANK and ISBLANK

Lecture 53 AND, OR and NOT

Lecture 54 SWITCH

Lecture 55 Other functions

Section 8: Statistical functions

Lecture 56 Measures – an introduction

Lecture 57 Aggregation of columns

Lecture 58 Aggregation of calculations

Lecture 59 DISTINCTCOUNT

Lecture 60 RANKG.EQ

Lecture 61 Other functions

Section 9: Mathematical functions

Lecture 62 Rounding functions

Lecture 63 Division functions – MOD and QUOTIENT

Lecture 64 SIGN (and use with SWITCH) and ABS

Lecture 65 Exponential functions

Lecture 66 Other functions

Section 10: Text functions

Lecture 67 Text searching

Lecture 68 Text extraction and substitution

Lecture 69 Text conversion

Lecture 70 Other functions

Section 11: Information Functions

Lecture 71 ISERROR and LOOKUPVALUE

Lecture 72 Other functions

Section 12: Filter and Value Functions

Lecture 73 RELATED

Lecture 74 RELATEDTABLE and COUNTROWS

Lecture 75 Context

Lecture 76 FILTER

Lecture 77 ALL

Lecture 78 CALCULATE

Lecture 79 ALLEXCEPT

Lecture 80 ALLSELECTED

Lecture 81 Other functions

Section 13: Time Intelligence Functions

Lecture 82 Date and Time Functions

Lecture 83 FIRSTDATE, LASTDATE

Lecture 84 Start of… and End of…

Lecture 85 Previous… and Next…

Lecture 86 DATESINPERIOD

Lecture 87 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD

Lecture 88 Opening Balance and Closing Balance

Lecture 89 SAMEPERIODLASTYEAR and PARALLELPERIOD

Lecture 90 Other Functions

Section 14: Conclusion

Lecture 91 Thank you for watching.

Lecture 92 Bonus Lecture

This course is for people who want to create analyses.,You either want to do this in Excel, or you want to learn about SQL Server Analytical Services (Tabular edition).,This course isn’t for you if you want to learn SSAS (MDX version) – there are other courses for this.

Course Information:

Udemy | English | 5h 28m | 4.02 GB
Created by: Phillip Burton

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

New Courses

Scroll to Top