The Knowledge Academy Logo
The Knowledge Academy Logo
01344 203999 - Available 24/7
Empty

Send us your message.

X

Microsoft Power BI Training

Key points about this course


Duration: 1 Days*

Dates & Prices Enquire
  • Includes course materials, completion certificate, & refreshments
  • Microsoft Power BI training from the world’s largest training provider
  • Attendance and participation confirms certification
  •  

Available delivery methods for this course

Classroom Icon

Classroom

Onsite Icon

Onsite

Online Icon

Online

Virtual Icon

Live Virtual

Course Information

Learn how to turn data into powerful insights that direct and drive informed business decisions - giving your business the edge over competitors. By taking our Microsoft Power BI training course, anyone can become a competent data analyst. 

The user-friendly Power BI reporting application has been designed to help users, of all experiential levels, produce insightful data analysis - hence our interactive and highly engaging BI training course helps candidates across departments, communicate performance-related data in a visually understandable manner. 

The Microsoft Power BI tool allows you to extract, analyse and comprehend large quantities of data - helping to ensure that you can present data in a logical manner and make informed business decisions. The Microsoft Power BI is the most user-friendly report-based analytical tools, that is transforming the way that businesses read their performance data.

Driving ad-hoc analysis and promoting the creation of personalised data dashboards, learning how to utilise the Power BI enhances an individual’s and business’s potential. During this extensive and interactive one-day Power BI course, candidates will learn how to publish reports directly onto the Power BI Report Server - enabling colleagues and stakeholders to appreciate the insightful data analysis from their phones, tablets, and laptops. Additionally, the flexibility of the Power BI Suite is demonstrated by the ability to unify your organisation's data by uploading and sharing information on Cloud-based platforms - our engaging trainers will show you how to share your data analysis with stakeholders on the Cloud too.

 

Microsoft Power BI Course Outline

Introduction to Power BI

  • What is Power BI?
  • The Power BI service
  • Power BI Report Server
  • Power BI Desktop
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Natural Language Queries​

​​Data Sources

  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • The Power BI Data Model
  • Managing Data Relationships
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Configuring Data for Q&A
  • Creating Content Packs
  • Creating a Group

Shaping and Combining Data

  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data

Modelling Data

  • What are Relationships?
  • Viewing Relationships
  • Creating Relationships
  • Cardinality
  • Cross Filter Direction
  • What is DAX?
  • Syntax
  • Functions
  • Context
  • Calculated Columns
  • Calculated Tables
  • Measures

Interactive Data Visualisations

  • Power BI Reports: Page Layout and Formatting
  • Multiple Visualisations
  • Creating Charts
  • Using Geographic Data
  • Histograms
  • Power BI Admin Portal
  • Service Settings
  • Desktop Settings
  • Dashboard and Report Settings

Prerequisites

There are no prerequisites for this Power BI Course - it is open and accessible to all individuals that wish to enhance their knowledge of Power BI. 

Audience

The course is designed for users that have a desire to work effectively with data to create visually appealing reports or dashboards.

Microsoft Power BI is a user-friendly reporting tool that allows professionals to create visual representations of complex data - ensuring that they can communicate their performance statistics with stakeholders, over a variety of platforms, to make informed business decisions
We are able to provide support via phone & email prior to attending, during and after the course.
A Delegate pack consisting of course notes and exercises, and tuition from an Experienced Instructor
This course is 1 day in duration
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
Please arrive at the venue at 8:45am.

What’s Included

  • The Knowledge Academy’s Microsoft Power BI Manual
  • Experienced Instructor
  • Certificate on Completion
  • Refreshments

 

Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 1 Days*


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

Trustpilot