Power BI & Power Pivot: Introduction

Crash course on how to work effectively with Power BI and Power Pivot
Rating: 4.3 out of 5 (94 ratings)
3,250 students
Power BI & Power Pivot: Introduction
Rating: 4.3 out of 5 (94 ratings)
3,250 students
Take your reporting to the next level with Power BI in just 2 hours
Transition from normal pivot tables to Power Pivot reports in Excel
Understand how Power BI and Power Pivot function as the next step in self-service BI
Fundamental concepts like data modeling, building interactive visualisations and simple calculations
Hands-on case examples that get you up and running
Learn from a professional BI developer

Requirements

  • Microsoft Power BI Desktop (free download)
  • Microsoft Excel
  • Windows (currently not available for Mac)

Description

________

From a normal pivot table to Power Pivot

  • Working with tables

  • Combining data the old way

  • Creating relationships in Power Pivot

  • Connecting a pivot table to the data model

Building a data model in Power Pivot

  • Importing data into Power Pivot

  • Data modeling and relationships

  • Creating a pivot table connected to a data model

Creating a dashboard using Power Pivot

  • Importing data

  • Data modeling

  • Report structure

  • Report filters

Building a report in Power BI

  • Introduction to Power BI

  • Loading data into Power BI

  • Creating relationships

  • Creating a date table

  • Visualizations- Area charts

  • Visualizations- Bar charts

  • Visualizations- Maps

  • Visualizations- Cards

Who this course is for:

  • Anybody curious about Power BI and Power Pivot

Course content

3 sections • 18 lectures • 1h 51m total length
  • Working with tables
    04:53
  • Combining data the old way
    08:08
  • Creating a relationship in Power Pivot
    08:27
  • Connecting a pivot table to the data model
    04:43

Instructor

BI Developer at DataTraining.io
Bas Dohmen
  • 4.3 Instructor Rating
  • 94 Reviews
  • 3,250 Students
  • 1 Course

Data Science Professional with 10 years of experience providing training and support in the field of Business Intelligence. Consulted on 100+ projects related to Power BI and Tableau across many different sectors for small companies to multinationals. Passionate about learning and development and knowledge sharing. I have trained over 2000+ people through on site trainings plus many more through online courses.