Power BI with Excel

$95.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

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: 3:15:54
This class is designed to get you up to speed using tools easily accessible to Power Users and all Microsoft Office users including Microsoft 365. First you will learn how to use Power Query to shape data that can be found in various data sources. Next you will learn the basics of creating data models using Power Pivot. Finally, you will learn the best ways to present your data by building reports using Excel PivotTable and PivotCharts. 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
26:25
Module 02 - Leveraging Power Query for Data Cleansing
41:47
Module 03 - Building Data Models with Power Pivot
44:09
Module 04 - Building Analytical Calculations with DAX
40:11
Module 05A - Designing Excel Reports (PivotTables and PivotCharts)
26:22
Module 05B - Designing Excel Reports (Connecting to Power BI Datasets)
06:50
Module 06 - Migrating to Power BI
10:10
Class Survey

 

System Requirements