HOME
 

Microsoft Power BI: Introduction

SquareOne Training
Course summary
Professional Training
2 days
495 - 795 GBP excl. VAT
Full time
Professional Training
Course Dates
Birkenhead
795 GBP
30/05/2022

Birkenhead
795 GBP
20/06/2022

Birkenhead
795 GBP
21/07/2022

Birkenhead
795 GBP
30/08/2022

Course description

powerbi

Microsoft Power BI: Introduction

    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.

    Delegates will also receive a full certificate of attendance and extensive manual, benefitting them long into the future. To find out more about our training options, please speak to our team today.

    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

    About provider

    SquareOne Training

    SquareOne believe that no two people are the same, therefore all our courses are unique just like you. SquareOne will work with you and your company to tailor a course that is suitable for your business needs, development and future...


    Read more and show all courses with this provider

    Request info

    Fill out your details to find out more about Microsoft Power BI: Introduction.

      Contact the provider

      Get more information

      Register your interest

    Country *

    Contact info

    SquareOne Training

    2 Tower Road
    CH41 1FN Birkenhead

     Show phone number
    www.squareonetraining.com


    Reviews

    Average rating 4.7

    Based on 31 reviews.

    Request information

    Find out more about this Microsoft Power BI: Introduction 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