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

Course Feature

Cost

Paid
Provider

Udemy
Certificate

Paid Certification
Language

English
Start Date

2023-05-23
Learners

No Information
Duration

No Information
Instructor

Phillip BurtonI Do Data Limited

Add to Favorites

4.4

4,015 Ratings

This course is perfect for anyone looking to become an expert in Microsoft Power Pivot and SSAS (Tabular DAX model). It covers the activation of PowerPivot, installation of SQLServer, and creating an analysis in Excel or SQLServer in just a few minutes. It also goes into detail on the initial data, various options, and advanced options that most people don't know about. Finally, it covers the development of DAX formulas to extend the model. By the end, you will be an expert user of both PowerPivot and SSAS, able to create reliable analyses and help others with their data analysis. It will also assist with the Microsoft exams 70-779 and 70-768.

Show All

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

Go to class

Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [August 18th, 2023]

Skills and Knowledge:
By taking this course, you will acquire the skills and knowledge to be able to activate PowerPivot or install SQLServer, create analyses in Excel or SQLServer, develop DAX formulas, and become an expert user of both PowerPivot and SSAS. You will also be able to help others with their data analysis, and be prepared for the Model Data and Design a tabular BI semantic model and Develop queries using Data Analysis Expressions (DAX) sections of Microsoft exam 70-779 and 70-768 respectively.
Professional Growth:
This course contributes to professional growth by providing a comprehensive overview of Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model). It covers the activation of PowerPivot, the installation of SQLServer, and the development of DAX formulas. By the end of the course, participants will have a thorough understanding of both PowerPivot and SSAS, and will be able to create reliable analyses which can be drilled-down quickly. Additionally, the course will assist with the Model Data section of Microsoft exam 70-779 "Analysing and Visualizing Data with Microsoft Excel" and 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".
Further Education:
This course is suitable for preparing further education, as it covers one of the most useful add-ins in Microsoft Excel, PowerPivot, and the Tabular model in SQLServer Analytical Services. It will assist with the Model Data section of Microsoft exam 70-779 "Analysing and Visualizing Data with Microsoft Excel" and 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". The course also provides exercises to test understanding and advanced options that most people don't even know about. By the end, users will be an Expert user of both PowerPivot and SSAS, able to create reliable analyses which are able to be drilled-down quickly.

Course Syllabus

Welcome

Creating our first model using PowerPivot (Excel)

Installing SQL Server 2019 Developer and Visual Studio 2019

Using the Tabular Model (SSAS in SQL Server)

Developing the Data Model

Pivot Tables functionality

An introduction to DAX functions, including Logical functions

Statistical functions

Mathematical functions

Text functions

Information Functions

Filter and Value Functions

Time Intelligence Functions

Conclusion

Show All

Recommended Courses

Excel 2013 PowerPivot & Advanced Business Intelligence Tools

4.2

Udemy 1,662 learners

Learn More

This course is the perfect way to take your Excel skills to the next level. With 47 short video tutorials, you'll learn the PowerPivot add-in, originally introduced with Excel 2010 and now included in Excel 2013. You'll be able to develop data models and calculations, and learn a skill set that is in high demand and in short supply. With the downloadable companion exercise files, you can follow along with the instructor and perform the same actions he is showing you on the videos. With lifetime online access, a Q&A forum, and a 30-day money-back guarantee, this course is the perfect way to become an indispensable resource at your work place and simplify your work and personal life. Take action now and click the TAKE THIS COURSE button to take yourself to the next level of professional development.

Microsoft Excel Power Pivot: Power Pivot DAX & Pivot Table

3.2

Udemy 3,797 learners

Learn More

This course is perfect for anyone looking to take their Excel, Pivot Table and Power Pivot skills to the next level. With this course, you will be able to increase your knowledge and productivity within hours, saving you hours each day and eliminating stress at work. You will also be able to use Power Pivot with confidence, leading to greater opportunities like a higher salary and promotions. Plus, you can download the entire course for offline viewing on the Udemy mobile app (Android & iOS). Enroll now and join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

Power Pivot Excel 365 - From Zero to Hero

4.5

Udemy 2,292 learners

Learn More

This course is designed to take novice PowerPivot users to a level of comfort and confidence in working with PowerPivot models, using Pivot tables and charts, DAX calculations and DAX time intelligence functions. With PowerPivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. This course consists of 5 modules, each with learning activities, videos and articles to reinforce what is covered. Learn how to link tables, create relationships, insert pivot tables and charts, work with DAX and use time intelligence functions. Get the most out of this course and become a PowerPivot hero!

DAX Power Pivot - 10 Easy Steps for Beginners

4.5

Udemy 4,800 learners

Learn More

This course is perfect for beginners who want to learn how to use DAX Power Pivot in Excel 2016. In just 10 easy steps, you will learn how to import data from Microsoft Access and Excel, build relationships between data tables, create hierarchies, shape the data model with calculated columns and measures, and build custom DAX expressions. Plus, you'll get a step-by-step user guide with practice exercises and solutions. Don't miss out on this opportunity to master DAX Power Pivot!