Power BI with Excel

£195.00

What Will You Learn?

  • The best ways to present your data by building reports using Excel, Power View and Power Map
  • By learning how to make the self-service BI solutions, you create scalability across your entire enterprise environment

Category:

DESCRIPTION

The Power BI with Excel course is designed to get you up to speed using tools easily accessible to power users and all Microsoft Office users including Office 365 (Please note: Office 365 is not mandatory for this class). First, you’ll learn the basics of creating models using Power Pivot. Then, using Power Query, you’ll shape additional data that can be found in external data sources.

INSTRUCTOR

DEVIN KNIGHT

Director of Training
Devin Knight is our Training Lead overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books: “Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services”, “Knight’s Microsoft Business Intelligence 24-Hour Trainer” and “SharePoint 2010 Business Intelligence 24-Hour Trainer”. He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server User Group in Jacksonville, Florida (JSSUG).

WHAT TO KNOW BEFORE THE CLASS

Because this class is focused on self-service end user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have a basic understanding of database terminology, such as tables, views, columns, rows, etc.


Duration: 8:27:55
This class is designed to get you up to speed using tools easily accessible to Power Users and all Microsoft Office users including Office 365 (Office 365 is not mandatory for this class). First, you will learn the basics of creating models using Power Pivot. Then using Power Query, you will shape additional data that can be found in external data sources. Finally, you will learn the best ways to present your data by building reports using Excel, Power View and Power Map. You will also learn how to make the self-service BI solutions you create scalable across your entire enterprise environment.
Power BI with Excel - What you need to get started
Module 01 - Class Introduction
27:37
Module 02 - Introduction to Power Pivot
08:31
Module 03 - Importing Data into Power Pivot
20:54
Module 04 - Creating the Data Model
33:37
Module 05 - Creating Calculated Columns with DAX
36:45
Module 06 - Creating Calculated Measures with DAX
01:07:54
Module 07 - Building Power Pivot Reports
26:19
Module 08 - Introduction to Power Query
06:26
Module 09 - Importing Data into Power Query
24:32
Module 10 - Using Power Query to Transform Data
01:22:59
Module 11 - Introduction to Power View
08:46
Module 12 - Creating a Basic Power View Report
22:02
Module 13 - Optimizing Power Pivot for Power View
22:51
Module 14 - Creating Interactive Reports with Power View
52:47
Module 15 - Touring Data with Power Map
33:54
Module 16 - Making Self-Service BI Scalable
32:01
Class Survey

SYSTEM REQUIREMENTS