20778 Analyzing Data with Power BI

sql_server_logo

20778 Analyzing Data with Power BI

The main purpose of the 3-day course is to give participants a good understanding of data analysis with Power BI. The course included creating visualizations, the Power BI Service, and the Power BI Mobile App.
Share on facebook
Share on twitter
Share on linkedin

Overview

The main purpose of the 3-day course is to give participants a good understanding of data analysis with Power BI. The course included creating visualizations, the Power BI Service, and the Power BI Mobile App.

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • 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 application – particularly Excel

Who Should Attend?

The course is highly recommended for SQL Server report creators who are interested in alternative methods of presenting data.

Course Outline

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

Lab: Exploring an Enterprise BI solution

  • Power BI
  • The Power BI service

Lab: Creating a Power BI dashboard

  • 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

Lab: Importing data into Power BI

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab: Shaping and combining data

  • Relationships
  • DAX queries
  • Calculations and measures

Lab: Modelling Data

  • Creating Power BI reports
  • Managing a Power BI solution

Lab: Creating a Power BI report

  • Cloud data
  • Connecting to analysis services

Lab: Direct Connectivity

  • The developer API
  • Custom visuals

Lab: Using the developer API

  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

Get Brochure and Pricing

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Stay-Home-Series-main-header-v2

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Get in touch with our consultant