Power BI: Data Analysis Professional

Use Power BI: Data Analysis Professional course and lab to explore and visualise data with Power BI. The Power BI course provides knowledge and skills required to analyse data with self-service BI, connect to data sources, perform advanced data modelling and shaping, perform advanced analysis, publish and share reports and dashboards and extend access to Power BI.

Lessons 1: Introduction

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

Lessons 2: Analysing Data with Self-Service BI

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

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

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

Lessons 5: Visualising Data with Power BI

  • Topic A: Create Visualisations in Power BI
  • Topic B: Chart Data in Power BI

Lessons 6: Enhancing Data Analysis

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

Lessons 7: Modelling Data with Calculations

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

Lessons 8: Creating Interactive Visualisations

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

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

Lessons 10: Enhancing Reports and Dashboards

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

Lessons 11: Publishing and Sharing Reports and Dashboards

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

Lessons 12: Extending Power BI Beyond the Desktop

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

Hands-on LAB Activities

Analysing Data with Self-Service BI

  • Interacting with Visualisations 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

Visualising Data with Power BI

  • Creating Visualisations
  • Charting Data in Power BI

Enhancing Data Analysis

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

Modelling Data with Calculations

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

Creating Interactive Visualisations

  • 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

Exam FAQs

FAQ's are not Available for this course.

Summary

Standard:

Power BI: Data Analysis

Lessons:

12+ Lessons

Delivery Method:

Online

Language:

English

Scroll to Top