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

Focused View

Phillip Burton,I Do Data Limited

5:16:35

148 View

01 - Welcome

001 Welcome.mp4

02:08

002 Welcome to Udemy.html

003 Introduction to Udemy.mp4

02:00

004 Do you want auto-translated subtitles in more languages.html

005 What will we learn.mp4

03:09

006 Software Requirements - PowerPivot.mp4

06:38

007 AdventureWorksDW2012.csv

007 AdventureWorksDW2012.xlsx

007 AdventureWorksDW2012Exercise.xlsx

007 Source data.mp4

02:14

008 Activating PowerPivot on Excel 2013 and 2016.mp4

02:43

009 Installing PowerPivot on Excel 2010.mp4

04:05

02 - Creating our first model using PowerPivot (Excel)

001 Creating our first model in PowerPivot.mp4

03:38

002 Using our first model in Excel.mp4

03:42

003 Creating and deploying our first model in Excel 2010.mp4

04:41

004 Adding a second table - Importing Data from SQL Server.mp4

08:19

005 Importing Data from SQL Server.mp4

06:02

006 AdventureWorksDW2012.csv

006 Practice Activity Number 1.html

007 Practice Activity Number 1 - Solution.mp4

02:57

03 - Installing SQL Server 2019 Developer and Visual Studio 2019

001 Installing SQL Server 2019 Developer and Visual Studio 2019.html

002 Downloading SQL Server Developer 2019.mp4

05:48

003 Installing SQL Server Developer 2019.mp4

07:59

004 Installing SQL Server Management Studio (SSMS).mp4

04:25

005 Installing Visual Studio 2022.mp4

06:12

006 Installing SSAS in Visual Studio 2022.mp4

03:19

007 Is your Visual Studio a trial version No!.mp4

01:37

04 - Using the Tabular Model (SSAS in SQL Server)

001 Introduction.mp4

02:01

002 AdventureWorksDW2014.zip

002 Downloading AdventureWorksDW.mp4

02:00

003 Attaching AdventureWorksDW.mp4

04:29

004 Creating and deploying our first model in SSAS.mp4

04:57

005 Adding additional tables.mp4

02:28

006 Introduction to Practice Activity.mp4

01:46

007 AdventureWorksDW2012.csv

007 Practice Activity Number 2.html

008 Practice Activity Number 2 - Solution.mp4

03:43

009 Importing Data from Excel.mp4

03:10

010 Having problems importing from Excel.mp4

07:34

05 - Developing the Data Model

001 AdventureWorksDW2012Exercise.xlsx

001 Practice Activity Number 3.html

002 Filtering, sorting and formatting fields.mp4

07:11

002 SSRS-Number-And-Date-Formats-150812.xlsx

003 Hiding columns from Client Tools, and other column tools.mp4

05:26

004 Refreshing (or processing) data.mp4

04:08

005 Creating quick measures.mp4

05:09

006 Perspectives.mp4

06:57

007 Hierarchies.mp4

07:04

008 Practice Activity Number 4.html

009 Do you want more practice setting your data model.html

06 - Pivot Tables functionality

001 PivotTable structure, and non-Visual Totals.mp4

06:05

002 Show no data in rows and columns.mp4

02:58

003 Create running totals.mp4

02:23

004 Slicers and Timelines.mp4

03:15

005 Using formulas to query Data Model (Advanced).mp4

03:46

07 - An introduction to DAX functions, including Logical functions

001 DAX functions - An Introduction.mp4

02:54

001 daxfunctions170320.zip

002 Calculated columns - an introduction.mp4

02:42

003 Basic operators.mp4

04:29

004 IF.mp4

02:53

005 BLANK and ISBLANK.mp4

05:00

006 AND, OR and NOT.mp4

03:46

007 SWITCH.mp4

04:09

008 Other functions.mp4

02:48

08 - Statistical functions

001 Measures - an introduction.mp4

03:58

002 Aggregation of columns.mp4

04:23

003 Aggregation of calculations.mp4

04:40

004 DISTINCTCOUNT.mp4

03:33

005 RANKG.EQ.mp4

01:09

006 Other functions.mp4

03:04

09 - Mathematical functions

001 Rounding functions.mp4

05:50

002 Division functions - MOD and QUOTIENT.mp4

01:31

003 SIGN (and use with SWITCH) and ABS.mp4

03:55

004 Exponential functions.mp4

01:48

005 Other functions.mp4

03:46

10 - Text functions

001 Text searching.mp4

05:44

002 Text extraction and substitution.mp4

05:13

003 Text conversion.mp4

06:02

004 Other functions.mp4

01:22

11 - Information Functions

001 ISERROR and LOOKUPVALUE.mp4

03:22

002 Other functions.mp4

01:49

12 - Filter and Value Functions

001 RELATED.mp4

03:58

002 RELATEDTABLE and COUNTROWS.mp4

03:18

003 Context.mp4

03:44

004 FILTER.mp4

02:21

005 ALL.mp4

04:06

006 CALCULATE.mp4

02:51

007 ALLEXCEPT.mp4

01:09

008 ALLSELECTED.mp4

06:14

009 Other functions.mp4

02:36

13 - Time Intelligence Functions

001 Date and Time Functions.mp4

02:41

002 FIRSTDATE, LASTDATE.mp4

02:15

003 Start of... and End of.mp4

02:03

004 Previous... and Next.mp4

05:11

005 DATESINPERIOD.mp4

02:38

006 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD.mp4

02:48

007 Opening Balance and Closing Balance.mp4

01:16

008 SAMEPERIODLASTYEAR and PARALLELPERIOD.mp4

03:00

009 Other Functions.mp4

02:27

14 - Conclusion

001 Thank you for watching.mp4

01:08

002 Bonus Lecture.mp4

02:55

Description

Visualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool.

What You'll Learn?

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

Who is this for?

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.

More details

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".
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 500,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

I Do Data Limited

Instructor's Courses

I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies. That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job. I Do Data courses are dedicated to enabling you to succeed.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.