DA-100: Microsoft Power BI, Part 3 of 5: Visualization and Power BI and Python

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 DA-100 Exam validates this expertise.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

Experience with Microsoft Excel, pivot tables and power pivot modelling is helpful.

Meet the expert

Nikolai Schuler

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.

Video Runtime

244 Minutes

Time to complete

426 Minutes

Course Outline

Visualizing Data Module 1

Our first visual (29:58)

• Introduction (00:08)
• 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:04)

• Introduction (00:08)
• Drill Down (08:29)
• Drill Through (06:50)
• Tree Map Visual (07:06)
• Decomposition Tree (05:23)
• Summary (00:08)

Matrix visual (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:35)

• Introduction (00:08)
• 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 (26:03)

• Introduction (00:08)
• Plots and correlation analysis plots (15:07)
• Violin plots (07:13)
• Performance and Troubleshooting (03:27)
• Summary (00:08)