Back to all courses
Power Pivot & DAX
Beginner
From369 SEK / month

Analyse data on a whole new level with Power Pivot and Data Analysis Expressions (DAX)

With Power Pivot and DAX, you can model data, visualize big data, and easily and efficiently create analyses to gain important insights. Data Analysis Expressions (DAX) is a collection of formulas used in Power Pivot, Power BI, and Azure Analysis Services, among others. If you work with data management and analytics, you will surely greatly benefit from this Excel add-in.

  • Go through the course at your own pace
  • Practical exercises and quizzes
  • Personal diploma
  • Save lessons as favorites

Are you a group of people wanting to take the course?

We’ll help you put together a course package for everyone at a lower cost.

Contact us

What you will learn

Power Pivot Basics

Gain a basic knowledge base in Power Pivot by first downloading and creating a shortcut to Power Pivot as an add-in for Excel. Retrieving data from external sources correctly is the most important step for the program, and in this course you will learn to do just that.

Relationships and columns

Relationships are an essential building block of working in Power Pivot, where many different kinds of relationships are created between separate databases. You can connect columns from one database to another to create completely new information as well as new ways of looking at the data you’re working with.

Measures

Measures are calculations that are applied to large amounts of data for data analysis. This course gives you an introduction to the concept and how to use it to provide new insight into your data.

Data Analysis Expression (DAX) formulas

DAX formulas are special measures that can take in multiple columns as arguments and can process big data in a way that Excel cannot. Learn the most common and useful DAX formulas as well as how  these measures work.

See the full course contents
  1. Course Content

    Expand All
    Chapter Content
    0% Complete 0/4 Steps
    Introduction
    Get Power Pivot
    Get Data
    Power Pivot – Parts of the Window
    Chapter Content
    0% Complete 0/8 Steps
    Measures (SUM & SUMX)
    FILTER
    Date Functions
    SWITCH
    Logical Functions
    RANKX
    CALCULATE
    Other DAX Functions
    Chapter Content
    0% Complete 0/1 Steps
    KPI

More about the course

  • Approximately 15 lessons divided into 4 chapters.
  • Total video time: 37 minutes.
  • Estimated time to take the course including quizzes: 2.5 hours.
  • Average duration per lesson: 3 minutes.
  • Personal shareable certificate after completing the course.

Power Pivot is a powerful add on for Excel and DAX (Data Analysis Expressions) includes additional functions to use when you work with relational data and dynamic aggregation. With Power Pivot & DAX you can create data models, data analysis and import data from different various sources.

Current Status
Not Enrolled
Price Incl. VAT
369 SEK Per month
Get Started
or