NEED HELP? TALK TO AN EXPERT (904) 638-5743

Power BI with Excel

WHAT YOU'LL 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
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course 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.

 

Click here for a downloadable PDF

 

Outline

 

Module 01 | Class Introduction
27m 37s total

 

Module 01A | Class Introduction
27m 37s

 

Module 02 | Introduction to Power Pivot
08m 31s total

 

Module 02A | Introduction to Power Pivot
08m 31s

 

Module 03 | Importing Data into Power Pivot
20m 54s total

 

Module 03A | Importing Data into Power Pivot
20m 54s

 

Module 04 | Creating the Data Model
33m 37s total

 

Module 04A | Creating the Data Model
33m 37s

 

Module 05 | Creating Calculated Columns with DAX
36m 45s total

 

Module 05A | Creating Calculated Columns with DAX
36m 45s

 

Module 06 | Creating Calculated Measures with DAX
67m 53s total

 

Module 06A | Creating Calculated Measures with DAX
67m 53s

 

Module 07 | Building Power Pivot Reports
26m 19s total

 

Module 07A | Building Power Pivot Reports
26m 29s

 

Module 08 | Introduction to Power Query
06m 26s total

 

Module 08A | Introduction to Power Query
06m 26s

 

Module 09 | Importing Data into Power Query
24m 32s total

 

Module 09A | Importing Data into Power Query
24m 32s

 

Module 10 | Using Power Query to Transform Data
82m 59s total

 

Module 10A | Using Power Query to Transform Data
82m 59s

 

Module 11 | Introduction to Power View
08m 46s total

 

Module 11A | Introduction to Power View
08m 46s

 

Module 12 | Creating a Basic Power View Report
22m 02s total

 

Module 12A | Creating a Basic Power View Report
22m 02s

 

Module 13 | Optimizing Power Pivot for Power View
22m 51s total

 

Module 13A | Optimizing Power Pivot for Power View
22m 51s

 

Module 14 | Creating Interactive Reports with Power View
52m 47s total

 

Module 14A | Creating Interactive Reports with Power View
52m 47s

 

Module 15 | Touring Data with Power Map
33m 54s total

 

Module 15A | Touring Data with Power Map
33m 54s

 

Module 16 | Making Self-Service BI Scalable
32m 01s total

 

Module 16A | Making Self-Service BI Scalable
32m 01s

Instructor

DEVIN KNIGHT

President
Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works Training. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, Florida Devin is a contributing member to several local user groups.

 

System Requirements

  • Power BI Desktop
  • You may have either Excel 2010 or Excel 2013 Professional Plus installed for this class, but all in-class examples will be done using Excel 2013.
  • Excel 2013 allows you to follow the entire class.
  • Excel 2010 allows you to follow Power Pivot and Power Query sections of the course. A hosted SharePoint service can be used to try Power View.
  • If you do not have this software currently installed, you can find a 60-day evaluation copy here. We strongly recommend downloading the 64-bit version of Office if possible.
  • In addition to Excel, please also download and install the following free Microsoft Excel Add-ins:
  • If you are using Excel 2010
  • If you are using Excel 2013

What to Know Before 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.

REVIEWS

Great class content!

Anonymous

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required