HOME
 

Microsoft Power BI - Introduction (Online Training)

SquareOne Training
Course summary
2 days
495 - 595 GBP excl. VAT
English
Professional Training
Next available date: 03/11/2020 09:30 - Online courses
Course Dates
Online courses
595 GBP
03/11/2020

Course description

Introduction to Power BI Desktop (Online Training)

This Introduction to Power BI Desktop training course is offered as an open/scheduled 2-day training course by SquareOne Training or a closed course at your offices.

There are three parts to creating a Power BI Desktop report, all of which are covered by this two-day course.  Firstly, you'll learn how to get data from all manner of different sources, usingQuery Editorto manipulate the results; secondly, you'll learn how to create, format and usevisualisations(tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns and measures using basic DAX language.  You'll also learn how to use Power BI Web, and get an overview of Power BI Mobile. 

Training Course Content

Basic reports

  • Getting data
  • Basic visualisations
  • Shapes, text boxes and images

Data sources

  • SQL Server / databases
  • Excel / text files
  • Websites and web services

Query editor

  • Filtering rows
  • Manipulating columns
  • Working with data types

Advanced query editor

  • Grouping and pivoting
  • Creating new columns
  • Basic M formula language

Multiple tables

  • Relationships
  • Filter directions 

Parameters

  • Creating parameters
  • Filtering by parameter

Filtering data

  • Slicers
  • Visualisation level filters

Drill-down

  • Interactions
  • "See records" feature
  • Hierarchies

Formatting visualisations

  • The formatting panes
  • Conditional formatting

Charts

  • Working with charts
  • Specific chart type issues
  • Grouping and binning

Other types of visualisations

  • Working with matrices
  • Working with cards

Dashboard visualisations

  • Gauges
  • Single-number visualisations
  • KPIs

Maps

  • Categorising data
  • Issues with maps

Calculated columns

  • Adding columns
  • IF and SWITCH
  • The RELATED function

Measures/DAX

  • How measures work/tuples
  • Adding measures
  • Basic DAX

Calendars

  • Creating calendars
  • Using multiple calendars
  • Working days

Date Functions

  • Period to date
  • Previous periods
  • Other date functions
  • Semi-additive measures

Advanced measures 

  • AggregateX functions
  • The CALCULATE function
  • The FILTER function
  • DAX variables

Roles and security

  • Creating roles
  • DAX restrictions

Publishing reports

  • Power BI accounts
  • Power BI files (PBIX)

Power BI Service Overview

  • Differences from PBI Desktop
  • Workspaces
  • Favorites

Using Power BI Service

  • Reports and dashboards
  • Using tiles
  • Pinning to dashboards

Overview of Excel tools

  • Power BI Publisher for Excel
  • Analyze for Excel

Overview of other tools - If time

  • Power BI Mobile overview
  • Power BI Pro overview

Why choose SquareOne Training

25 years' experience of delivering quality IT Training Services

All trainers Certified Microsoft Office Trainer (MOS) or higher

Public and in-house training throughout the UK

Expenses

This course is delivered online live through Microsoft Teams or WebEx. To access the training, you will require a PC/Laptop with Internet connection and audio.

About provider

SquareOne Training - In-house IT & Computer Training

SquareOne Training

SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Power BI - Introduction (Online Training).

  Contact the provider

  Get more information

  Register your interest

Contact info

SquareOne Training

2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com


Request information

Find out more about this Microsoft Power BI - Introduction (Online Training) course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Case Study
Excel Templates For Mexichem
SquareOne Training

At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.

Read more
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
Find more courses here