Power BI & Power Pivot: Introduction

Power BI & Power Pivot: Introduction

________

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

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

Url: View Details

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

Rating: 4.3

Level: Beginner Level

Duration: 2 hours

Instructor: Bas Dohmen