uCertify

Power BI: Data Analysis Professional

Learn to manipulate data with Power BI, turning numbers into easy-to-read visuals and insights.

(PWR-BI.AD2) / ISBN : 978-1-64459-704-0
Lessons
Lab
TestPrep
AI Tutor (Add-on)

About This Course

In this Power BI Data Analytics course, you’ll learn how to transform raw data into clear, actionable insights through dynamic reports and visualizations. From connecting to various data sources and clearing data to creating interactive dashboards, you’ll leverage the full range of Power BI’s features. By the end of this course, you’ll have strong grip on data modeling using DAX for advanced calculations, build custom visuals, and learn how to share your reports with others.

Skills You’ll Get

  • Connect to various data sources and manage data relationships in Power BI
  • Clearn, shape, and transform data using Power BI’s Query Editor 
  • Analyze and profile data to ensure accuracy and quality 
  • Create compelling charts, graphs, and visuals to present data effectively. 
  • Use Data Analysis Expressions (DAX) for complex calculations and creating calculated columns/measures
  • Create and personalize dynamic, interactive dashboards and reports
  • Conduct in-depth statistical analysis and use calculated tables and parameters 
  • Publish reports, oversee workspaces, and share dashboards among teams or organizations 
  • Extend Power BI capabilities to mobile devices and customize layouts for on-the-go access
  • Collaborate with on reports, configure row-level security, and control access with Power BI API
Download Course Outline

1

Introduction

  • Course Description
  • How to Use This course
  • Course-Specific Technical Requirements
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
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
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
5

Visualizing Data with Power BI

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

Enhancing Data Analysis

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

Modeling Data with Calculations

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

Creating Interactive Visualizations

  • Topic A: Create and Manage Data Hierarchies
  • Topic B: Filter and Slice Reports
  • Topic C: Create Dashboards
  • Summary
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
10

Enhancing Reports and Dashboards

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

Publishing and Sharing Reports and Dashboards

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

Extending Power BI Beyond the Desktop

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

1

Analyzing Data with Self-Service BI

  • Interacting with Visualizations in Power BI
2

Connecting to Data Sources

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

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
4

Visualizing Data with Power BI

  • Creating Visualizations
  • Charting Data in Power BI
5

Enhancing Data Analysis

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

Modeling Data with Calculations

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

Creating Interactive Visualizations

  • Creating and Managing Data Hierarchies
  • Filtering and Slicing Reports
8

Using Advanced Analysis Techniques

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

Enhancing Reports and Dashboards

  • Enhancing Reports
  • Enhancing Dashboards
10

Publishing and Sharing Reports and Dashboards

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

Extending Power BI Beyond the Desktop

  • Configuring the Mobile Layout
  • Reviewing Custom Visuals and Apps

Any questions?
Check out the FAQs

Have questions about our data analysis with Power BI training? Get quick answers here.

Contact Us Now

This course is ideal for data analysts, business intelligence professionals, or anyone looking to enhance their data visualization and analysis skills using Power BI.

No prior Power BI experience is needed. This course addresses topics ranging from fundamental concepts to advanced techniques, making it ideal for newcomers.

Power BI skills are in high demand across industries, helping you stand out as a data-driven professional. These skills will enable you to transform data into valuable insights, improving decision-making and opening doors to roles in data analysis, business intelligence, and reporting.

Absolutely! Power BI integrates seamlessly with other Microsoft tools like Excel, Azure, and Sharepoint, improving your workflow and data analysis capabilities.

Related Courses

All Courses