Tutorialspoint

Power Pivot - Big Data Analysis Made Easy

Providing insights using DAX formulas!

Course Description

If you find yourself stuck with hundreds of millions of rows of data to analyze, or find it a hassle to build a pivot table based on multiple data sources, then this course is for you.

Join me in the course:

- to learn about advanced DAX formulas, also known as Data Analytic Expressions,

- to learn how to connect data from different sources before feeding them into 1 single pivot table,

- to learn Relationship mapping, Power Pivot’s way of doing VLOOKUP()

- to learn about the best practices in Power Pivot modeling and

- to be well positioned for building the ultimate dashboard in Power BI that utilizes DAX formulas

PS: Excel 2010 and newer is needed for this course.

Goals

  • This course will help you
  • to learn about using DAX formulas, also known as Data Analysis Expressions
  • to learn how to connect data from different sources before feeding them into 1 single pivot table
  • to learn Relationship mapping, Power Pivot’s way of doing VLOOKUP()
  • to learn about the best practices in Power Pivot modeling and
  • to be well positioned for building the ultimate dashboard in Power BI that utilizes DAX formulas!

Prerequisites

  • Intermediate Excel knowledge
  • Example: be able to build a pivot table from scratch
Show More

Curriculum

Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Power Pivot - Big Data Analysis Made Easy
This Course Includes
  • 1 hours
  • 20 Lectures
  • 1 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate