Skip to content
Write a review
UdemyExcelPaid courseAll LevelsCertificate

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.

4.7
714 reviews

Created by: Phillip Burton

Last updated December 2024

icon
What you will learn

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

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.7 out of 5higher than 81% of them
  • Reviews714#203 of 356 by number of reviews
  • Length5.5 hoursshorter than 51% of them
  • Last updatedDecember 2024more recently than 60% of them

icon
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.
Read More All Levels All Levels product length iconTime: 5.5h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Phillip Burton

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.

Read More

icon
More courses by Phillip Burton

$18.99

Original price $129.9985% off

$22.99

Original price $159.9986% off

$22.99

Original price $159.9986% off

$14.99

Original price $99.9985% off

$13.99

Original price $99.9986% off

Free

All courses by Phillip Burton

icon
More Excel courses

$11.99

Original price $39.9970% off

Free

$14.99

Original price $99.9985% off

Free

$15.99

Original price $109.9985% off

$16.99

Original price $119.9986% off
All Excel courses

icon
Reviews

4.7

714 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing 12 of 45 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)
$11.99Original price $74.9984% off
Visit course on Udemy Write a review
  • Video Duration: icon 5.5h
  • Price: $11.99
  • Provider: icon Udemy
  • Updated: icon December 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com