Log On/Register  

855.838.5028

Analyzing Data with PowerBI (20778)

Duration: 3 Days
Course Price: $2,650

This course provides students with the knowledge and skills analyze data with Power BI.

You Will Learn How To

  • Describe key features of a self-service BI solution
  • Describe Power BI and its data sources
  • Model, shape, and combine data
  • Describe Power BI data visualizations

This course provides students with the knowledge and skills analyze data with Power BI.

You Will Learn How To

  • Describe key features of a self-service BI solution
  • Describe Power BI and its data sources
  • Model, shape, and combine data
  • Describe Power BI data visualizations

Requirements:

The MOC On-Demand courses are available for 90 days and students need to use Office 365 to complete the lab work. Students can utilize the trial for Office 365 which lasts for 30 days from when the trial is activated. It is recommended that students using the trial of Office 365 plan their lab work accordingly. The labs provide instructions on how to register for this account.

  • This course requires that you meet the following prerequisites:
    • Basic knowledge of the Microsoft Windows operating system and its core functionality
    • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
    • Some exposure to basic programming concepts (such as looping and branching)
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
    • Familiarity with Microsoft Office applications – particularly Excel

Redeem Your Microsoft SATVs:

  • This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.

Module 1: Introduction to Self-Service BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Lab

Module 2: Introducing Power BI

  • Power BI
  • The Power BI service
  • Power BI mobile apps
  • Lab

Module 3: Power BI Data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Lab

Module 4: Shaping and Combining Data

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab: Shaping and combining data

Module 5: Modelling Data

  • Relationships
  • DAX queries
  • Calculations and measures
  • Lab

Module 6: Interactive Data Visualizations

  • Creating Power BI reports
  • Managing a Power BI solution
  • Lab
Learn More
Please type the letters below so we know you are not a robot (upper or lower case):