Computer Technology

   >

Computer Technology 

   >

Analyzing Data With Power BI

Analyzing Data With Power BI

Duration (Days)

3

Overview

This is a 3 days course designed to give participants a good understanding of data analysis with Power BI. Participants will learn how to connect excel data, collaborate with Power BI data, data stores , mobile app and develop API

Objectives
  • Perform Power BI desktop data transformation

  • Describe Power BI desktop modelling

  • Create a Power BI desktop visualization

  • Implement the Power BI service

  • Describe how to connect to Excel data

  • Describe how to collaborate with Power BI data

  • Connect directly to data stores

  • Describe the Power BI developer API

  • Describe the Power BI mobile app

Course Outline
  • Introduction to business intelligence

  • Introduction to data analysisIntroduction to data visualization

  • Overview of self-service BI

  • Considerations for self-service BI

  • Microsoft tools for self-service BI

  • Power BI

  • The Power BI service

  • Using Excel as a data source for Power BI

  • The Power BI data model

  • Using databases as a data source for Power BI

  • The Power BI service

  • Power BI desktop queries

  • Shaping data

  • Combining data

  • Relationships

  • DAX queries

  • Calculations and measures

  • Creating Power BI reports

  • Managing a Power BI solution

  • Cloud data

  • Connecting to analysis services

  • The developer API

  • Custom visuals

  • Power BI mobile apps

  • Using the Power BI mobile app

  • Power BI embedded