Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Power BI & Power Pivot: Introduction

via Udemy

Overview

Crash course on how to work effectively with Power BI and Power Pivot

What you'll learn:
  • 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

________

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

Taught by

Bas Dohmen

Reviews

Start your review of Power BI & Power Pivot: Introduction

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.