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.