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

4.4

Learners: 4,015

Instructor: Phillip BurtonI Do Data Limited

Duration:

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. ▼▲

Course Feature Course Overview Course Provider Discussion and Reviews

Go to class

Course Feature

Cost:

Paid

Provider:

Udemy

Certificate:

Paid Certification

Language:

English

Start Date:

2023-05-23

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.