Microsoft Power BI

Key Information

Duration: 2 days

Course Learning Skills: SQL Server

Brief

Audience

Business Analysts, Financial Analysts, Data Scientists and Staff who need to use Power BI for producing reports from Excel, SQL Server and other databases.

Prerequisites

There are no prerequisites for this course.

Duration

2 days. Hands on.

Course Objectives

This Microsoft Power BI training course shows attendees how to use the latest collection of on-premise and online tools to enable them to find, clean, model, and visualize data, share discoveries, and collaborate in intuitive new ways.

Power BI is the latest set of Microsoft BI tools for data mash up, data modelling, and data visualisation. The results can be deployed on-premise or in the cloud and can be visualised in browsers, on tablets, and on mobile phones.

This course will take you through the product, demonstrating functionality, with plenty of hands on so that you can learn to use this powerful tool to help you transform your rows of data into a compelling interactive visual story.

Course Content

 

Power BI Service

  • Self-service BI
  • Organisational BI
  • Portal
  • Content Items
  • Datasets
  • Connecting to Data
  • Visualizing Data

Reports

  • Reading View
  • Editing View
  • Visualisations and Custom Visualisations
  • Dashboards

Power BI Mobile

  • Native Applications (iOS/Android/Windows)
  • Viewing Content
  • Sharing & Collaboration
  • Configuring Alerts

Power BI Desktop

  • Data Models
  • Schemas
  • Relationships
  • Connectivity
  • Design Environment
  • Navigation
  • Importing Data

Transforming Data

  • Queries & the Query Editor
  • Data Previews
  • Shaping & Cleansing Data
  • Basic Transformations
  • Loading Transformed Data
  • Combining Datasets
  • Functions
  • Date Tables

Refining the Model

  • Tables & Columns
  • Data View
  • Exploring Data
  • Managing Schema & Data Changes
  • Connections & Tables
  • Data Refresh
  • Relating Tables
  • Rules & Limitations
  • Auto-Detecting
  • Relationship View

Calculations

  • Data Analysis Expressions
  • Calculated Columns
  • Measures
  • DAX Syntax
  • DAX Functions
  • Advanced Relationships

Register your interest in a Talk-IT Course

Course Interest

Do a short survey to tell us what you think about training?

Click here to take the survey, it’ll only take a few minutes!

Scroll to Top