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 course will walk you through the basics of this product, 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..
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...
Power BI - what is it and why use it?
Desktop vs Services
Power BI vs other BI tools (Gartner Magic Quadrant)
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.
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.
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.
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.
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’
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.
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’
The Data Gateway
Data Refreshe schedules
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.
08/02/2018: Power BI is an excellent visualization tool, released by Microsoft in June 2015 and updated every month since then. It’s relatively cheap compared...
24/04/2019: Power BI is extending and integrating more and more with advances in Data Analysis. In this article we will show some examples of how you can...
20/12/2018: Python or R in tomorrow’s world? Python and R are popular programming languages extensively used by data scientists today. But what about tomorrow...
18/12/2017: The Client A leading developer and manufacturer of sophisticated industrial products, abatement solutions and related value-added services. Their...
19/10/2017: A leading Financial Services organisation was keen to get several of its teams working consistently in an "Agile" way. Agile is an iterative...
13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
0800 028 6400
Why JBI ?
"great technology tips"
"Access to exclusive content"
"Short course means less time off"
"Joined via web"
"Knowledgable sales staff"