Power BI: Data Analysis Professional

(PWR-BI.AD1)/ISBN:978-1-64459-260-1

This course includes
Lessons
TestPrep
Hand-on Lab
AI Tutor (Add-on)

Use Power BI: Data Analysis Professional course and lab to explore and visualize data with Power BI. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Power BI course provides knowledge and skills required to analyze data with self-service BI, connect to data sources, perform advanced data modeling and shaping, perform advanced analysis, publish and share reports and dashboards, extend access to Power BI, and more.

Lessons

12+ Lessons | 89+ Quizzes | 100+ Flashcards | 100+ Glossary of terms

TestPrep

50+ Pre Assessment Questions | 50+ Post Assessment Questions |

Hand on lab

26+ LiveLab | 26+ Video tutorials | 02:02+ Hours

Here's what you will learn

Download Course Outline

Lessons 1: Introduction

  • Course Description
  • How to Use This course
  • Course-Specific Technical Requirements

Lessons 2: Analyzing Data with Self-Service BI

  • Topic A: Data Analysis and Visualization for Business Intelligence
  • Topic B: Self-Service BI with Microsoft Power BI
  • Summary

Lessons 3: Connecting to Data Sources

  • Topic A: Create Data Connections
  • Topic B: Configure and Manage Data Relationships
  • Topic C: Save Files in Power BI
  • Summary

Lessons 4: Performing Data Cleaning, Profiling, and Shaping

  • Topic A: Clean, Transform, and Load Data with the Query Editor
  • Topic B: Profile Data with the Query Editor
  • Topic C: Shape Data with the Query Editor
  • Topic D: Combine and Manage Data Rows
  • Summary

Lessons 5: Visualizing Data with Power BI

  • Topic A: Create Visualizations in Power BI
  • Topic B: Chart Data in Power BI
  • Summary

Lessons 6: Enhancing Data Analysis

  • Topic A: Customize Visuals and Pages
  • Topic B: Incorporate Tooltips
  • Summary

Lessons 7: Modeling Data with Calculations

  • Topic A: Create Calculations with Data Analysis Expressions (DAX)
  • Topic B: Create Calculated Measures and Conditional Columns
  • Summary

Lessons 8: Creating Interactive Visualizations

  • Topic A: Create and Manage Data Hierarchies
  • Topic B: Filter and Slice Reports
  • Topic C: Create Dashboards
  • Summary

Lessons 9: Using Advanced Analysis Techniques

  • Topic A: Create Calculated Tables, Variables, and Parameters
  • Topic B: Enhance Visuals with Statistical Analysis
  • Topic C: Perform Advanced Analysis
  • Summary

Lessons 10: Enhancing Reports and Dashboards

  • Topic A: Enhance Reports
  • Topic B: Enhance Dashboards
  • Summary

Lessons 11: Publishing and Sharing Reports and Dashboards

  • Topic A: Publish Reports
  • Topic B: Create and Manage Workspaces
  • Topic C: Share Reports and Dashboards
  • Summary

Lessons 12: Extending Power BI Beyond the Desktop

  • Topic A: Use Power BI Mobile
  • Topic B: Extend Access with the Power BI API
  • Summary

Hands-on LAB Activities

Analyzing Data with Self-Service BI

  • Interacting with Visualizations in Power BI

Connecting to Data Sources

  • Creating a Data Connection
  • Configuring and Managing Data Relationships
  • Saving and Exporting Files in Power BI

Performing Data Cleaning, Profiling, and Shaping

  • Cleaning, Transforming, and Loading Connected Data
  • Profiling Data in Power BI
  • Shaping Data for Analysis
  • Using the Transpose Feature

Visualizing Data with Power BI

  • Creating Visualizations
  • Charting Data in Power BI

Enhancing Data Analysis

  • Customizing Visuals in Power BI
  • Incorporating Tooltips to Enhance Data Analysis

Modeling Data with Calculations

  • Creating Calculations with DAX
  • Creating Calculated Measures
  • Creating Conditional Columns

Creating Interactive Visualizations

  • Creating and Managing Data Hierarchies
  • Filtering and Slicing Reports

Using Advanced Analysis Techniques

  • Creating a Calculated Table
  • Enhancing Visuals with Statistical Analysis
  • Performing Advanced Analysis

Enhancing Reports and Dashboards

  • Enhancing Reports
  • Enhancing Dashboards

Publishing and Sharing Reports and Dashboards

  • Publishing Reports and Refreshing Data
  • Configuring Row-level Security

Extending Power BI Beyond the Desktop

  • Configuring the Mobile Layout
  • Reviewing Custom Visuals and Apps