EXCEPTIONAL TRAINING FOR DATA PROFESSIONALS

Power BI Training Course

Produce visually compelling, intuitive Dashboards & Presentations

NEXT COURSE
5 Sep London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Power BI training course (code: MicrosoftPowerBI)

TRAINING COURSE OVERVIEW

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

We will show you how to build Dashboards for visualising financial data gathered from corporate data sources such as Excel.

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 (Android, Apple, and Windows).

This training course will walk you through the basics of Power BI, demonstrating functionality and letting you get hands on and learn to use this powerful tool to help you transform your rows of data into a compelling interactive visual story..

JBI run public Power BI  courses in London and custom onsite Power BI training at your UK or worldwide offices.

We can make our custom Power BI training even more engaging and relevant by encouraging delegates to use their own corporate data .

Power BI training courses are available for beginner, intermediate and advanced levels.

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.
 

Learn to build Dashboards like this - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...


CONTENT

DETAILHIGHLIGHTS

Power BI INtroduction

Power BI - what is it and why use it?
Desktop vs Services
Power BI vs other BI tools (Gartner Magic Quadrant)

Power BI Desktop

Data Models - How to structure your data
Schemas - Data structure definition
Relationships - How data in one table relates to another
Connectivity - Connection options, e.g. real-time or stored/refreshed
Design Environment - Learning how to build reports.
Navigation - Moving quickly between Power BI Desktop’s views and windows.
Importing Data - How to get data into a data model.

Covering

  • Dashboards in Desktop
  • Get data from different sources
  • Custom Colours
  • PowerBi template
  • Desktop Three views
  • Data View: Column Sort, formatting, hiding columns
  • Relation ship view: create and manage relationships
  • Relationship Cardinality: 1-to-1, 1to-many, many-to-many
  • Create and format visuals
  • Slicers
  • Highlight and filter
  • Control Filter interaction
  • Hierarchies
  • Drill Down
  • Show data and show records in Drilldown
  • Publish reports/Dashboards
  • Monthly Updates

Power BI Service

Self-service BI - Visualising your own data.
Organisational BI - Creating a single, reliable version of the truth.
Portal - Easy access from anywhere.
Content Items - The essential elements of a report.
Datasets - The data behind a report.
Connecting to Data - Accessing data for use in Power BI.
Visualizing Data - Building attractive, meaningful displays.

Covering

  • Licence schema
  • Load data in PowerBi services
  • Create Reports in PowerBi services
  • Pin visuals to dashboard
  • Dashboard Flow and Navigation
  • Power BI for Mobile
  • Dashboard Tiles
  • Dashboard customization
  • Natural Language Queries
  • Quick Insights
  • Inbuilt Demo Samples
  • Web publication
  • Power BI to PowerPoint export

IMPORTING & Transforming Data

Queries & the Query Editor - Controlling the data import process
Data Previews - Checking progress at each step.
Shaping & Cleansing Data - Making real-world data usable.
Basic Transformations - e.g. Find & replace, Fill empty, Extract characters, and much more.
Combining Datasets - Appending, merging data from different sources.
Functions - The M library of powerful data manipulation capability.
Date Tables - Building customised time intelligence.
Loading Transformed Data - Populating the Power BI data model.

Covering

  • Query Editor in brief
  • Query Design explained
  • Query editors tabs and menus
  • Best Practice for Queries
  • Applied Steps
  • Advanced Query Editor
  • Data Transformations
  • Data cleaning
  • Dataset merges
  • Unpivoting
  • Accessing data from a Folder
  • Appending techniques
  • Columns
  • Dynamic Fiscal Calendar Tables

DATA ModelLING

Tables & Columns - Understanding basic data structure.
Data View - Seeing your underlying data values
Exploring Data - Easy data profiling
Managing Schema & Data Changes - Dealing with issues of change control
Connections & Tables - Data lineage.
Data Refresh - Optimising new data acquisition.
Relating Tables - Telling Power BI how your data relates internally.
Rules & Limitations - Filter flow options and consequences.
Auto-Detecting - Pros and cons of saving design time
Relationship View - Working on your data model structure.

Covering

  • Tables & Columns
  • Data View
  • Exploring Data
  • Managing Schema & Data Changes
  • Connections & Tables
  • Data Refresh
  • Relating Tables
  • Rules & Limitations
  • Auto-Detecting
  • Relationship View
  • Introduction to Facts & Dimensions
  • Creating Relationships Between Tables
  • Relationship types
  • CrossFilter Relationships
  • Handling Multiple Relationships with the Fact Table
  • Custom Sorting of Columns
  • Data Types & Formatting
     

Reports/Dashboards

Reading View - Seeing what users see.
Editing View - Customising user experience.
Visualisations and Custom Visualisations - Telling a compelling story.
Dashboards - The easy-read overall summary ‘at a glance’

Covering

  • Creating & formatting Dashboards
  • Creating visuals
  • Choosing the best visual
  • Interactivity between visuals
  • Visuals in Preview
  • Custom Visuals
  • Formatting visuals
  • Types of Conditional Formatting
  • Optimizing the Matrix Layouts
  • Adding Drill-Downs
  • Viewing the Underlying Data Driving a Visualization
  • Understanding Row Level Security
  • Creating and Testing Security Roles

DAX & Calculations

Data Analysis Expressions - Powerful versatility at your command.
Calculated Columns - Extending data tables.
Measures - How your data is summarised.
DAX Syntax - Learning the basic grammar of formula writing.
DAX Functions - Building blocks for data manipulation.
Advanced Relationships - Data model design trade-offs.

Covering

  • DAX overview
  • DAX Syntax
  • Dax Operators
  • Calculated Measures & Calculated Columns
  • Implicit Vs Explicit
  • Base Measures & Metrics
  • Commonly Used DAX Functions
  • DAX Aggregate functions
  • Iterators: SUMX, MAXX, AVERAGEX
  • IF conditional statements
  • Cross Table Lookups
  • Evaluating Context in the relationship
  • CALCULATE: the magic function
  • USERELATIONSHIP function
  • Time Intelligence prerequisites
  • Time intelligence functions (MTD, QTD, YTD, Prior Year)
  • Create a time Intelligence report

PUBLISHING & SHARING DASHBOARDS & REPORTS

Sharing Dashboards - Who gets to see what?
Creating Workspace - Organising structure around people.
Publish App - Making it available online.
Security - Restricting access to the ‘need to knows’

Covering

  • Publishing Models to the Cloud Service
  • Adding Users to Security Defined Roles
  • Basic Sharing of Dashboards & Reports
  • Multiple ways of sharing reports and Dashboards
  • Creating App Workspaces
  • Collaborating on Reports
  • Publishing Organisational Apps for Distribution of Content
  • Adding Users & Editing Workspaces
  • Connecting to Apps

DATA REFRESHING

The Data Gateway
Data Refreshe schedules
On-Demand Refresh

Power BI Mobile

Native Applications (iOS/Android/Windows) - Optimising deployment on different platforms.
Viewing Content - How phone view works.
Sharing & Collaboration - Encouraging appropriate teamwork.
Configuring Alerts - How to notify users of important new data.

Covering

  • Configure reports for Mobile view
  • Configure Dashboard for Mobile view
  • Viewing Content
  • Sharing & Collaboration
  • Configuring Alerts
•        Import data from different sources (excel, database, csv file, web)
•        Create a functional model by connecting your tables so that they can easily interact in a report
•        Clean your data to prepare for reporting
•        Create various type of visuals to enhance and interpret your data
•        Filter and interact with visuals
•        Create calculation in DAX language for aggregations (sum, count etc.) and time intelligence analysis (comparison with same period last year, Year to date etc.)
•        Create multipage reports and summarise the data in dashboards
•        Implement security on the reports and dashboards
•        Share your reports and dashboards with your colleagues

UPDATES
Receive the latest version of this course into your inbox



LONDON COURSES
- INCLUDES LUNCH -

5th Sep 2019 - 2 days £1150
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


CONTACT
0800 028 6400



Why JBI ?

►"great technology tips"
► "Access to exclusive content"
► "Short course means less time off"

►"Inspiring trainers"
► "Joined via web"
► "Knowledgable sales staff"

NEWSLETTER
Get exclusive news about upcoming programs, technical insights & special offers



Error
Google Apps Script
Authorisation is required to perform that action.