Intro To Power BI

$95.00

What Will You Learn?

  • To build your own dashboards
  • To understand the Power BI ecosystem
  • To extract and model data

Description

This class is designed to get you up to speed on the latest with Power BI. First you will learn how to query and pull in data. Then organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data through a variety of charts, graphs, maps and gauges that are provided. This class exclusively uses the Power BI Desktop application to create solutions that are deployed to the Power BI Service and are then visible from any devices.

Instructor

MANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

 

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, relationships, etc.


Duration: 15:14:01
This class is designed to get you up to speed on the latest with Power BI. First, you will learn how to query and pull in data. Then, organize the results into a data model with relationships and calculations. Finally, you will learn the best way to visualize your data through a variety of charts, graphs, maps and gauges that are provided. This class exclusively uses the Power BI Desktop application to create solutions that are deployed to the Power BI Service and are then visible from any devices.
Introduction to Power BI - What you need to get started
Module 00 - Getting Started
06:07
Module 01A - Class Introduction (BI Basics)
33:53
Module 01B - Class Introduction (Power BI Desktop Overview)
19:32
Module 02 - Data Discovery with Power BI Desktop
29:40
Module 03A - Transforming Data (Basic Transforms)
23:05
Module 03B - Transforming Data (Add Column From Example)
12:26
Module 03C - Transforming Data (Appending Queries)
15:27
Module 03D - Transforming Data (Merging Queries)
31:55
Module 03E - Transforming Data (Combine Files)
15:16
Module 03F – Transforming Data (Reading and Understanding M)
13:23
Module 03G – Transforming Data (Writing Basic M)
13:27
Module 03H – Transforming Data (Parameters and Templates)
28:41
Module 03I – Transforming Data (Writing Parameters in M)
13:22
Module 03J – Transforming Data (Other Query Features)
15:13
Module 04 - Introduction to Modeling Data
15:44
Module 05A - Creating the Data Model (Modeling Basics)
53:34
Module 05B - Creating the Data Model (Model Enhancements)
26:22
Module 05C - Creating the Data Model (What If Parameters)
13:14
Module 06A - Creating Calculated Columns and Tables (DAX Basics)
26:48
Module 06B - Creating Calculated Columns and Tables (Navigation Function)
21:21
Module 06C - Creating Calculated Columns and Tables (Calculated Tables)
08:32
Module 07A - Creating Calculated Measures (Measure Basics)
34:41
Module 07B - Creating Calculated Measures (Time Intelligence Functions)
15:08
Module 08 - Introduction to Visualizing Data
19:14
Module 09 - Creating Basic Reports with the Power BI Desktop
25:38
Module 10A - Creating Interactive Reports (Adding Slicers for Filters)
12:31
Module 10B - Creating Interactive Reports (Visualizing Tabular Data)
29:07
Module 10C - Creating Interactive Reports (Visualizing Categorical Data)
28:22
Module 10D - Creating Interactive Reports (Visualizing Data Trends)
17:30
Module 10E - Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
17:12
Module 10F - Creating Interactive Reports (Visualizing Geographical Data with Maps)
34:53
Module 10G - Creating Interactive Reports (Visualizing Goal Tracking)
13:56
Module 10H - Creating Interactive Reports (Using Custom Visuals)
13:23
Module 10I - Creating Interactive Reports (Digital Storytelling)
38:10
Module 10J - Creating Interactive Reports (Other Features)
21:25
Module 11A - Using the Power BI Service (Deploying to the Power BI Service)
25:05
Module 11B – Using the Power BI Service (Setting up Workspaces)
14:23
Module 11C – Using the Power BI Service (Creating Dashboards)
16:53
Module 11D – Using the Power BI Service (Using Q&A)
11:15
Module 11E - Using the Power BI Service (Publishing an App)
12:52
Module 11F - Using the Power BI Service (Subscriptions and Alerts)
09:29
Module 11G - Using the Power BI Service (Excel Integration)
09:40
Module 11H - Using the Power BI Service (Export and Embed Options)
12:50
Module 12A – Refreshing the Data (Refreshing Data and the Data Gateway)
13:16
Module 12B – Refreshing the Data (Scheduling a Data Refresh)
08:39
Module 13A - Mobile BI (Power BI Mobile Overview)
02:59
Module 13B - Mobile BI (Designing Reports and Dashboards for Mobile)
06:38
Module 13C - Mobile BI (Interacting with the Power BI Mobile App)
11:50
Class Survey

 

System Requirements

  • Windows 10, Windows 7, Windows 8 or Windows 8.1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2
  • Microsoft Power BI Desktop requires Internet Explorer 10 or greater
  • Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
  • Power BI Desktop (http://tinyurl.com/powerbidesktop)