Design and manage analytics solutions using Power BI (PL-300T00)

H61Q2S

Course ID

H61Q2S

Duration

3 days

Format

ILT/VILT

Overview

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI. The course shows how to access and process data from a range of data sources including both relational and non-relational data. This course also discusses how to manage and deploy reports and dashboards for sharing and content distribution.


Course ID

H61Q2S

Duration

3 days

Format

ILT/VILT

  • Audience

    This course is ideal for data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also ideal for anyone who develops reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.


  • Prerequisites

    Before attending this course, you should have:

    • Experience working with data in the cloud
    • An understanding core data concepts
    • Knowledge of working with relational data in the cloud
    • Knowledge of working with non-relational data in the cloud
    • Knowledge of data analysis and visualization concepts

    There are no prerequisites for this course, but we recommend completing Microsoft Azure Data Fundamentals (DP-900T00) before taking this course.


  • Objectives

    After completing this course, you should be able to:

    • Ingest, clean, and transform data
    • Model data for performance and scalability
    • Design and create reports for data analysis
    • Apply and perform advanced report analytics
    • Manage and share report assets

  • Certifications and related exams

    This course prepares you for Microsoft Certified: Power BI Data Analyst Associate certification exam.


  • Course outline

Module 1: Get Started with Microsoft Data Analytics


  • Discover data analysis
  • Get started building with Power BI
  • Introduction to end-to-end analytics using Microsoft Fabric
  • Get started with Copilot in Power BI

Module 2: Prepare Data for Analysis with Power BI


  • Get data in Power BI
  • Clean, transform, and load data in Power BI
  • Choose a Power BI model framework

Module 3: Model Data with Power BI


  • Configure a semantic model
  • Write DAX formulas for semantic models
  • Create DAX calculations in semantic models
  • Modify DAX filter context in semantic models
  • Use DAX time intelligence functions in semantic models
  • Create visual calculations in Power BI Desktop
  • Optimize a model for performance in Power BI

Module 4: Design Effective Reports in Power BI


  • Scope report design requirements
  • Design Power BI reports
  • Enhance Power BI report designs for the user experience
  • Perform analytics in Power BI

Module 5: Manage and Secure Power BI


  • Manage workspaces in Power BI service
  • Manage semantic models in Power BI
  • Choose a content distribution method
  • Create dashboards in Power BI
  • Secure data access in Power BI

5 reasons to choose HPE as your training partner

  1. Learn HPE and in-demand IT industry technologies from expert instructors.
  2. Build career-advancing power skills.
  3. Enjoy personalized learning journeys aligned to your company’s needs.
  4. Choose how you learn: in-person , virtually , or online —anytime, anywhere.
  5. Sharpen your skills with access to real environments in virtual labs .

Explore our simplified purchase options, including HPE Education Learning Credits .

Recommended for you