Course Objectives

Learn how to harness the potential of Microsoft Power BI with this fantastic two day introduction course aimed at those who have a keen eye for data. Upon completion of this training, you will be able to use Power BI to create fully interactive and immersive dashboards and reports on all aspects of your business, helping you to gain insights and make the decisions that matter most.

For a more in depth description of this course click here.

This two day training course provides a PDF manual, certificate of attendance and lunch with refreshments.

For more information about this course please call (0151) 680 6907 or email enquiries@squareonetraining.com

Terms and Conditions.Generally, our courses run from 09:30 until 16:30 unless otherwise stated. Some courses will be more than 1 day so please read the dates at the time of booking.After booking via Eventbrite you will receive notification from them of your purchase. You will also receive joining instructions from the SquareOne team, confirming dates, times and location. We will also at that time check on any special needs or dietary requirements you may have.In the unlikely event that this course is cancelled – then SquareOne will work with you to schedule new dates.

Course Duration

2 Days Classroom Training or Online

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