—Course Overview
1m 28s
Introducing Power BI
- 29m 17s
—Introducing Power BI
0m 38s
—Getting Acquainted with Power BI
1m 4s
—Creating Datasets from Data Models and Data Files
1m 24s
—Demo: Getting Started with Power BI
2m 3s
—Using Quick Insights to Explore a Dataset
1m 38s
—Demo: Using Quick Insights
3m 38s
—Viewing Reports
0m 36s
—Demo: Viewing Reports in Power BI
4m 0s
—Exploring a Dashboard
0m 52s
—Demo: Exploring a Dashboard
3m 42s
—History of Power BI
2m 35s
—Choosing a Development Tool
0m 25s
—Using Excel
1m 5s
—Demo: Using Excel 2016
2m 48s
—Using Power BI Desktop
0m 47s
—Demo: Using Power BI Desktop
1m 14s
—Summary
0m 39s
—Getting Data
1m 17s
—Databases
2m 38s
—Demo: Getting Data from Databases Using Power BI Desktop
1m 53s
—Demo: Getting Data from Databases (Excel)
2m 8s
—Files
0m 29s
—Demo: Getting Data from Files Using Power BI Desktop
2m 53s
—Demo: Getting Data from Files Using Excel
1m 1s
—Web and Other Sources
0m 34s
—Demo: Getting Data from the Web
1m 35s
—Azure and Software as a Service
0m 54s
—Manual Entry
0m 19s
—Demo: Adding Data Manually Using Power BI
0m 56s
—Demo: Adding Data Manually Using Excel
0m 47s
—Summary
0m 40s
Transforming Data
- 32m 30s
—Transforming Data
0m 39s
—Renaming Queries
0m 21s
—Demo: Renaming Queries
1m 48s
—Combining Queries: Append
0m 32s
—Demo: Appending Queries Using Power BI
2m 54s
—Demo: Appending Queries Using Excel
1m 7s
—Fixing Metadata
0m 50s
—Demo: Fixing Metadata Using Power BI
3m 12s
—Demo: Fixing Metadata (Excel)
0m 43s
—Filtering Rows
0m 29s
—Demo: Filtering Rows
1m 28s
—Eliminating Columns
0m 18s
—Demo: Eliminating Columns
3m 25s
—Combining Queries: Merge
0m 59s
—Demo: Merging Queries
3m 47s
—Adding a Column
0m 31s
—Demo: Adding Columns by Splitting Text
2m 5s
—Demo: Adding Columns by Splitting XML
3m 29s
—Demo: Adding Columns for Sorting
3m 14s
—Summary
0m 30s
Modeling Data for Analysis
- 34m 0s
—Modeling Data for Analysis
0m 39s
—Creating Relationships
1m 43s
—Demo: Creating Relationships Using Power BI Desktop
5m 38s
—Demo: Creating Relationships Using Excel
2m 34s
—Defining New Columns
0m 54s
—Concatenating Columns
0m 33s
—Demo: Concatenating Columns Using Power BI Desktop
4m 45s
—Demo: Concatenating Columns Using Excel
1m 52s
—Performing a Lookup to a Related Table
0m 43s
—Demo: Using the Related Function
2m 12s
—Translating a Value
0m 45s
—Demo: Using the If Function
5m 23s
—Adding a Date Table
0m 47s
—Demo: Adding a Date Table in Power BI Desktop
3m 55s
—Demo: Adding a Date Table in Excel 2016
0m 28s
—Summary
1m 1s
Enhancing the Data Model
- 22m 18s
—Enhancing Data Models
0m 37s
—Defining Hierarchies
0m 16s
—Demo: Defining Hierarchies in Power BI Desktop
1m 26s
—Demo: Defining Hierarchies in Excel
0m 49s
—Configuring Properties
1m 27s
—Demo: Configuring Properties in Power BI Desktop
2m 19s
—Demo: Configuring Properties in Excel
0m 48s
—Demo: Configuring Properties: Data Categories
1m 4s
—Demo: Configuring Properties: Formatting & Default Summarization
1m 7s
—Defining New Measures
1m 0s
—Demo: Defining Customer Count & Pct of Total Customers
5m 50s
—Demo: Defining Total Sales & Previous Year Sales
4m 45s
—Summary
0m 43s
Visualizing Data
- 38m 26s
—Visualizing Data
0m 38s
—Adding Visuals
1m 46s
—Demo: Adding a Table, Clustered Column Chart, & Bar Chart
4m 48s
—Demo: Adding a Map, Card, and Matrix
3m 35s
—Demo: Adding a New Page, Column Chart, Filled Map, and KPI
3m 10s
—Demo: Adding Visuals Using Excel
5m 12s
—Filtering
0m 45s
—Demo: Filtering In Power BI Desktop
2m 18s
—Demo: Filtering in Excel Power View
1m 32s
—Slicer Filtering
0m 29s
—Demo: Slicer Filtering in Power BI Desktop
1m 2s
—Demo: Slicer Filtering in Excel Power View
1m 12s
—Highlighting
0m 34s
—Demo: Highlighting
1m 35s
—Setting Properties
0m 28s
—Demo: Setting Properties in Power BI Desktop
3m 9s
—Demo: Setting Properties in Excel Power View
0m 44s
—Drilling Within a Hiearchy
0m 27s
—Demo: Drilling in Power BI Desktop
2m 32s
—Demo: Drilling in Excel Power View
1m 42s
—Summary
0m 39s
Refreshing Data
- 18m 16s
—Refreshing Data
0m 40s
—Publishing Datasets
1m 11s
—Demo: Publishing Datasets
5m 29s
—Refreshing Imported Data
2m 47s
—Using Power BI Gateway - Personal
1m 35s
—Demo: Using Power BI Gateway - Personal
2m 42s
—Demo: Scheduling Data Refresh
1m 40s
—Understanding Power BI Gateway - Enterprise
0m 57s
—Summary
1m 11s