Author
Helen Wall
Released
10/9/2019- Describe the steps in connecting to folders.
- Explain the process of using list and record objects in data analysis.
- Identify errors when creating code with M.
- Define how to reference a list in a table as a column.
Skill Level Intermediate
Duration
Views
- [Helen] My name is Helen Wall. In this course, I'll teach you how to handle your data more efficiently using Power BI. I'll show you the ins and outs of Power BI using the ETL or extract, transform, load framework. By the end of this course, you'll feel comfortable importing and transforming data from many different kinds of data sources. Then, you can blend and join this data together for further analysis, so what are you waiting for? Let's get started transforming and automating your data processes with Power BI.
-
Introduction
-
What is Power BI?2m 5s
-
Focus on Power Query2m 17s
-
Course considerations1m 35s
-
1. Extracting Data: Files
-
Manually entering data1m 25s
-
Connecting to a PDF file2m 57s
-
Connecting to folders5m 32s
-
2. Extracting Data: Databases
-
Connecting to databases5m 34s
-
-
3. Extracting Data: Web and Other Options
-
Connecting to web tables6m 15s
-
Querying API data2m 33s
-
Configuring OData feeds1m 54s
-
Installing Python2m 25s
-
Running Python scripts2m 2s
-
-
4. Transforming Data: Cleaning
-
Leveraging metadata1m 28s
-
Leveraging data types2m 49s
-
Splitting fields3m 5s
-
Merging fields1m 56s
-
Cleaning text fields2m 7s
-
Removing or replacing values2m 36s
-
-
5. Transforming Data: Integration
-
Working with binary objects3m 35s
-
Grouping data1m 50s
-
Pivoting data6m 36s
-
Transposing data2m 10s
-
Unpivoting data1m 44s
-
6. Transforming Data: Enrichment
-
Leveraging text formulas8m 11s
-
Conditional formulas2m 52s
-
Filling up or down columns1m 43s
-
Leveraging date formulas5m 42s
-
-
7. Leveraging M Language: Logic and Syntax
-
Breaking down syntax1m 53s
-
Renaming steps in M4m 20s
-
Consolidating M steps2m 16s
-
8. Leveraging M Language: Objects
-
Utilizing parameters3m 6s
-
Creating list objects4m 2s
-
Leveraging record objects1m 49s
-
Leveraging list functions1m 57s
-
Creating date tables3m 3s
-
Looping with lists6m 34s
-
Combining list objects5m 36s
-
-
9. Leveraging M language: Custom Functions
-
Setting up custom functions6m 23s
-
Configuring custom filtering5m 23s
-
-
10. Loading Data
-
Fixing errors3m 24s
-
Refreshing data6m 29s
-
Joining sets of data7m 11s
-
Composite models2m 19s
-
Conclusion
-
Next steps27s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: The Power BI ecosystem