IT & Software

Power BI & Power Pivot: Introduction

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

What you will 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

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
- Power BI & Power Pivot: Introduction
GO to coupon
  • Udemy teacher
  • English
  • 3
  • 1425
  • 2022-03-17