Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) (Udemy.com)

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

( 45 Reviews )

Created by: Phillip Burton

Produced in 2021

What you will learn

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course 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 SQLServer Analytical Services.

We'll activate PowerPivot if you have the right version of Excel, and if not, then we'll install SQLServer on your computer, which can dothe same job. We'll installthe Developer edition, which used to cost $100, for free.

After PowerPivot is activated, or SQLServer is installed, we'll create our first analysis in Excelin just a matter of minutes.

After only thesefirst 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 DAXformulas, 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 Expertuser of both PowerPivot andSSAS, able to create reliable analyses which are able to be drilled-down quickly,and you'll beable to help others with their data analysis.

It will assist withthe Model Data sectionof Microsoftexam 70-779 "Analysing and Visualizing Data with Microsoft Excel".

It will alsoassist withthe "Design a tabular BIsemantic model" and "Develop queries using Data Analysis Expressions (DAX)"sectionof Microsoftexam 70-768"Developing SQLData 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.

Time: 5.5h

Instructor Details

Phillip Burton

4.4 Rating
45 Reviews

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)

- Provider: Udemy
- Time: 29.5h

$11.99

SQL Server Integration Services (SSIS) - An Introduction

SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

70-462: SQL Server Database Administration (DBA)

70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)

- Provider: Udemy
- Time: 9.5h

$11.99

Microsoft SQL Server Reporting Services (SSRS)

Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)

- Provider: Udemy
- Time: 6h

$11.99

70-778, DA-100: Analyzing and Visualizing Data with Power BI

70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)

- Provider: Udemy
- Time: 24h

$11.99

SQL Server SSAS (Multidimensional MDX) - an Introduction

SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)

- Provider: Udemy
- Time: 8h

$11.99

All courses by Phillip Burton

More excel courses

Excel Skills for Business: Essentials (2017)
5.0 (432 Reviews)

- Provider: Coursera
- Time: 4h

Free

Excel Skills for Business: Intermediate I
4.9 (463 Reviews)

- Provider: Coursera
- Time: 22h

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)

- Provider: Udemy
- Time: 7h

$11.99

Excel with Top Microsoft Excel Hacks (2016)
4.9 (95 Reviews)

- Provider: Udemy
- Time: 2h

$11.99

Microsoft Excel Complete Excel Guide (Excel 2007 2021)

Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)

- Provider: Udemy
- Time: 21h

$11.99

All excel courses

Reviews

4.4

45 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Veerababu Mannem on 10/11/2020

This is good for beginners.

By Andreo J Mangawang on 10/5/2020

It is very helpful

By Bhaskara Chary T on 9/15/2020

Good!

By Justin Gentle on 7/21/2020

Useful Refresher on Power Pivot

By Aniruddha Mukherjee on 7/5/2020

Really great so far.

By eyda Tunca on 5/15/2020

I took many courses from Philip because i like his style, i can understand easily his examples.Practice activities are useful during learning period ,actually this course is amazing,i am happy for join,
join and learn :)

By Jasmina Markovic on 5/1/2020

Phillip is absolutely the best coach for MS products.

By Michael Vincent Lamendola on 4/27/2020

well done. good instructions. i learned much

By L, F. on 4/26/2020

It went from Excel to a Visual Studio project without any steps in between. Looking for my crystal ball to figure that huge leap out. Very poor. This really needs to be fixed.

By Mercedes de Bajeneta on 4/19/2020

Excelente el material del curso y la claridad de los conceptos

By Ron Reinhart on 4/11/2020

Was a very good basic, beginner course. I was mostly interested in SSAS Tabular, and I now have a need at work to apply what I have learned. I look forward to putting this to good use.

By Nick Zurlo on 4/6/2020

Enjoyed the course and learned a lot about setting up SSAS, SSMS, and PowerPivot. The exercises were not too challenging though and would have benefited from an difficulty boost to ensure one understands the content. Additionally the lack of knowledge checks and activities past Section 6 when going into the DAX language was a let down for me.
I'm not sure why the course stopped involving activities and didn't have a 'final project' to connect all of what was learned together but it would have been a 5 star class, to me, if that was the done.
Shout out to Phil as I did have a question during the course and he got back to be within a day and I appreciate all that he is doing as a content creator.