PL-300: Microsoft Power BI, Part 3 of 6: Visualization and Power BI and Python
with expert Nikolai Schuler
Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 3/25/2021 | |
| Level | Intermediate | |
| Runtime | 4h 7m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
Data Science is a growing field, this course in the Power BI series digs into visualizing data as well as using Python in Power BI.
Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. The PL-300 Exam validates this expertise.
Prerequisites
Experience with Microsoft Excel, pivot tables and power pivot modelling is helpful.
Meet the expert
Nikolai is a mathematician and works as a data scientist in a large German company. He is focused mainly on gaining insights from data and creating a positive impact with this knowledge.
Course outline
Visualizing Data Module 1
Our First Visual (30:03)
- Introduction (00:13)
- Our first visual (07:57)
- The format tab (11:52)
- Tables (09:53)
- Summary (00:08)
Conditional Formatting (27:08)
- Introduction (00:08)
- Conditional Formatting (08:48)
- The Pie Chart (05:32)
- All about the Filter visual (12:32)
- Summary (00:08)
Filter Pane for Developers (27:20)
- Introduction (00:08)
- Filter pane for developers (08:52)
- Cross filtering & Edit interactions (03:56)
- Exercise 4 - Instructions (01:00)
- Exercise 4 - Solution (06:10)
- Syncing Slicers Across Pages (07:06)
- Summary (00:08)
Visualizing Data Module 2
Drill Down (28:09)
- Introduction (00:13)
- Drill Down (08:29)
- Drill Through (06:50)
- Tree Map Visual (07:06)
- Decomposition Tree (05:23)
- Summary (00:08)
Matrix Visualization (31:47)
- Introduction (00:08)
- Matrix visual (05:17)
- Edit pages (07:15)
- Buttons & Actions (09:28)
- Bookmarks to customize your report (09:31)
- Summary (00:08)
Analytics and Forecast with Line Charts (26:11)
- Introduction (00:08)
- Analytics and Forecast with Line Charts (10:12)
- Working with Custom Visuals (07:17)
- Get data using R & R Script Visual (08:26)
- Summary (00:08)
Asking Questions (22:47)
- Introduction (00:08)
- Asking Questions (03:45)
- Wrap up Data Visualization (08:09)
- Exercise 5 - solution (10:37)
- Summary (00:08)
Python and Power BI
Python Intro (25:40)
- Introduction (00:13)
- Plan of Attack (02:57)
- Setting up Python (03:03)
- Transforming data using Python scripts (11:24)
- Python visual (07:55)
- Summary (00:08)
Python Visual Plot Types (28:43)
- Introduction (00:08)
- Plots and correlation analysis plots (15:07)
- Text Analysis (09:53)
- Performance and Troubleshooting (03:27)
- Summary (00:08)