BLOGCATALOG
Menu
Portrait of young and cheerful male businessman in a wheelchair holding his smartphone and smiling while sitting at his workplace in modern office. Handicapped worker. Trading online. Stock market - leadership strategies for wellness
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
Professional African-American woman training instructor smiling with overlay text.
Meet our PTR trainers, experts in engaging, impactful learning.
Accurate dart in center of a red and white target with bold text about hitting training goals.
Sharpen your team’s skills for high-impact, goal-precision results.

Microsoft Power BI: Data Analysis Professional

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

This course is designed for professionals responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. The Data Analysis Professional course picks up where Data Analysis Practitioner leaves off and dives deeper into features often used by data scientists, such as advanced analysis techniques, enhanced reporting and publishing, and extending Power BI beyond the desktop.

Course Prerequisite: Microsoft Power BI: Data Analysis Practitioner

Learning Objectives »

  • Analyze data with self-service BI.
  • Perform data cleaning, profiling, and shaping.
  • Enhance data analysis with visual elements.
  • Model data with calculations.
  • Create interactive visualizations.
  • Use advanced analysis techniques.
  • Enhance reports and dashboards.
  • Extend Power BI beyond the desktop.

Course Agenda

Analyzing Data with Self-Service BI

  1. Data Analysis and Visualization for BI
  2. Self-Service BI with Microsoft Power BI

Connecting to Data Sources

  1. Create Data Connections
  2. Configure and Manage Data Relationships
  3. Save Files in Power BI

Data, Cleaning, Profiling, and Shaping

  1. Clean, Transform, and Load Data
  2. Profile Data with the Query Editor
  3. Shape Data with the Query Editor
  4. Combine and Manage Rows

Visualizing Data with Power BI

  1. Create Visualizations in Power BI
  2. Chart Data in Power BI

Enhancing Data Analysis

  1. Customize Visuals and Pages
  2. Incorporate Tooltips

Modeling Data with Calculations

  1. Use Data Analysis Expressions (DAX)
  2. Calculated Measures and Columns

Creating Interactive Visualizations

  1. Create and Manage Data Hierarchies
  2. Filter and Slice Reports
  3. Create Dashboards

Using Advanced Analysis Techniques

  1. Calculated Tables, Variables, & Parameters
  2. Enhance Visuals with Statistical Analysis
  3. Perform Advanced Analysis

Enhancing Reports and Dashboards

  1. Enhance Reports
  2. Enhance Dashboards

Publishing and Sharing

  1. Publish Reports
  2. Create and Manage Workspaces
  3. Share Reports and Dashboards

Extending Power BI

  1. Use Power BI Mobile
  2. Extend Access with the Power BI API
Portrait of young and cheerful male businessman in a wheelchair holding his smartphone and smiling while sitting at his workplace in modern office. Handicapped worker. Trading online. Stock market - leadership strategies for wellness

Microsoft Power BI: Data Analysis Professional

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

This course is designed for professionals responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. The Data Analysis Professional course picks up where Data Analysis Practitioner leaves off and dives deeper into features often used by data scientists, such as advanced analysis techniques, enhanced reporting and publishing, and extending Power BI beyond the desktop.

Course Prerequisite: Microsoft Power BI: Data Analysis Practitioner

Learning Objectives »

  • Analyze data with self-service BI.
  • Perform data cleaning, profiling, and shaping.
  • Enhance data analysis with visual elements.
  • Model data with calculations.
  • Create interactive visualizations.
  • Use advanced analysis techniques.
  • Enhance reports and dashboards.
  • Extend Power BI beyond the desktop.

Course Agenda

Analyzing Data with Self-Service BI

  1. Data Analysis and Visualization for BI
  2. Self-Service BI with Microsoft Power BI

Connecting to Data Sources

  1. Create Data Connections
  2. Configure and Manage Data Relationships
  3. Save Files in Power BI

Data, Cleaning, Profiling, and Shaping

  1. Clean, Transform, and Load Data
  2. Profile Data with the Query Editor
  3. Shape Data with the Query Editor
  4. Combine and Manage Rows

Visualizing Data with Power BI

  1. Create Visualizations in Power BI
  2. Chart Data in Power BI

Enhancing Data Analysis

  1. Customize Visuals and Pages
  2. Incorporate Tooltips

Modeling Data with Calculations

  1. Use Data Analysis Expressions (DAX)
  2. Calculated Measures and Columns

Creating Interactive Visualizations

  1. Create and Manage Data Hierarchies
  2. Filter and Slice Reports
  3. Create Dashboards

Using Advanced Analysis Techniques

  1. Calculated Tables, Variables, & Parameters
  2. Enhance Visuals with Statistical Analysis
  3. Perform Advanced Analysis

Enhancing Reports and Dashboards

  1. Enhance Reports
  2. Enhance Dashboards

Publishing and Sharing

  1. Publish Reports
  2. Create and Manage Workspaces
  3. Share Reports and Dashboards

Extending Power BI

  1. Use Power BI Mobile
  2. Extend Access with the Power BI API
COURSE CATALOG
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.