Why learn Power Pivot and DAX?

To make more informed and effective business decisions, we need more powerful and sophisticated analysis. Its easy to create a workbook and import some data to create simple analysis and reports. But when you need to create insights from several dynamic and independent data sources, Power Pivot is an amazing tool that will help you to deep dive into data by using Data Analysis Expression [DAX] functions.

This course includes :

  • Four hours of on-demand videos

  • Twelve months full access

  • Eight downloadable resources

  • Certificate of Completion

What you 'll learn

  • How to import large data sets from almost any source.

  • Create data relationships to get rid of LOOKUPs and MATCH and INDEX.

  • Create calculated columns and measures.

  • Use Time Intelligence functions to create complex analysis in minutes.

  • Build fully interactive and bespoke report and dashboards.

  • Who should attend

    Anybody who want to learn advanced features of MS Excel.

  • Prerequisites

    Basic knowledge of Microsoft Excel.

  • Requirements

    Microsoft Excel 2016 or later. Microsoft Office 365 is preferred.

Course curriculum

  • 1

    Introduction

    • Modern Challenges for Everyone

    • What is PowerPivot?

    • Loading data to PowerPivot Data Model
  • 2

    Calculated Columns vs DAX Measures

    • How to add Calculated Columns in PowerPivot?

    • What is DAX - Data Analysis Expression?

    • How to add a DAX Measure?
  • 3

    Time Intelligence in PowerPivot

    • Standard Calendar vs Custom Calendar

    • Table Relationships

    • Increase drilldown limit of PowerPivot

    • Practice DAX measures

    • CALCULATE() - Your new friend.

    • How to use Disconnected Tables.

    • Time Intelligence functions

    • More Time Intelligence Functions
  • 4

    Conditional Measures

    • SWITCH(), IF() and BLANK() functions
  • 5

    Iterator Functions

    • SUMX(), MAXX(), RANKX() and TOPN() functions
  • 6

    Multiple Data Tables

    • Multiple data tables - Data Granularity and Data Relationships

Buy now

One year subscription