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.

4.35 (651 reviews)
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)
5.5 hours
Apr 2024
last update
regular price

What you will learn

Extract data from multiple tables.

Create connections between the tables.

Develop the model using DAX functions.

Create analyses in Excel.

Why take this course?


"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".


Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Screenshot_01Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Screenshot_02Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Screenshot_03Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Screenshot_04

Our review

🌟 **Overall Course Review** 🌟 **Pros:** - **Excellent Content and Clarity**: The course is praised for its clear explanations, with instructors known for their expertise and ability to convey complex concepts in an understandable manner. (Reviewer 1, 7, 9) - **Practical Learning Experience**: The course offers numerous opportunities to practice and review, which helps reinforce learning and ensure comprehension. (Reviewer 2, 8, 10, 14, 16, 18) - **Comprehensive Coverage**: The material covers a vast number of topics, providing a thorough understanding of the tools and technologies discussed. (Reviewer 17, 21) - **Supplemental Materials**: Useful additional resources are included, which enhance the learning experience. (Reviewer 15, 19) - **Responsive Instructor**: Philip Burton is recognized for his responsiveness to student inquiries, addressing questions promptly. (Reviewer 12) - **Real-World Application**: Many reviewers have reported applying the skills learned directly into their work, demonstrating the course's practical utility. (Reviewer 4, 11, 16, 20) - **Multiple Course Synergy**: The content is consistent with other courses by the same instructor, suggesting a cohesive learning experience when taken in conjunction with related courses. (Reviewer 22) **Cons:** - **Pacing Issues**: Some students found the pace of the course, particularly in the DAX sections, to be too fast, which might be challenging for beginners. (Reviewer 5, 23) - **Transition Clarity**: The transition from Excel to Visual Studio was noted as being abrupt without clear step-by-step guidance, which could be confusing for some learners. (Reviewer 11, 21) - **Lack of Activities and Final Project**: There is a desire for more challenging exercises throughout the course and a final project to tie all the learned concepts together. (Reviewer 6, 13) - **Missing Infrastructure Setup Guidance**: Some students indicated that there was a lack of initial videos explaining how to set up the necessary infrastructure for SQL lessons. (Reviewer 20) - **Need for High-Level Explanations**: It was suggested that high-level explanations of each tool used would be beneficial, especially for those new to the subject matter. (Reviewer 24) - **Video Quality and Pacing**: Some found the clicking in videos too fast, which made it difficult to follow along at times. (Reviewer 12) - **Repeat Viewing Necessary**: The need to rewatch videos due to quick explanations and visual presentations suggests that the material could be improved for better initial comprehension. (Reviewer 25) - **Language Barrier**: A few reviewers reported challenges with translation, which impacted their understanding of certain functions. (Reviewer 26) **Additional Notes:** - **Consistency with Other Courses**: It's worth noting that this course seems to be consistent with other courses offered by the same instructor, which may be beneficial for students taking multiple courses. (Reviewer 22) - **Recommendations and Repeat Attendance**: The course was recommended by a colleague and has been completed by reviewers multiple times due to its quality and utility. (Reviewer 17, 27) In conclusion, this course is highly regarded for its clarity, practical learning opportunities, and the real-world skills it imparts. However, there are some areas where improvements could be made, particularly in slowing down the pace of certain topics, providing clearer transitions between tools, and offering a more comprehensive set of exercises. Despite these cons, the course remains a valuable resource for those looking to deepen their understanding of data analysis expressions and services.



Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Price chart


Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Ratings chart

Enrollment distribution

Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model) - Distribution chart
udemy ID
course created date
course indexed date
course submited by