Microsoft Power BI

Power BI Training when you need it

Microsoft Power BI is a business intelligence and analytics tool. It can easily connect to a huge range of data sources, including your existing Excel spreadsheets, SQL databases, and much more. Once connected, it allows transformation and cleaning of data to create visually immersive and interactive dashboards to provide real time analytics.

Power BI makes data available to end users and provides self-service functionality that is both powerful and flexible. Reports and dashboards created using the array of tools available can be shared with other Power BI users in your organisation. The Power BI suite has desktop and cloud components as well as mobile device applications.

Discuss your needs. (03) 9999 7780

Want training on your site? We travel to you.

Training delivered right to your office on a day that works best for your team.

Get fully interactive, hands-on experience.

Professional instruction, lots of practice time, and solutions for your Power BI concerns.

We have everything you need to succeed.

Fill out our free assessment and we will determine the right course content for your team.

No Computer?
No problem, use ours.

If you’re short on computers, we will gladly supply a laptop for each person.

Custom Computer Training Course- Build Your Own Course

Build your own custom course

Any of our courses can be tailored to the unique requirements of your team. Our Off the Shelf courses are modularised with this option in mind, which means that you could mix and match from a selection of existing topics, or we can work with you to develop something specific to your organisation. Either way, we are on hand for advice on the best way to structure your customised training course.

To help you with your customised option, you can choose from our extensive list of course topics. We can then help you to assign the appropriate amount of content based on your training timeframe, and the best order of topics to ensure your training flows well. Our aim is to help every participant gain valuable knowledge and skills.

Microsoft Power BI

Standard 1 Day Microsoft Power BI Courses

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing
 from: $480 / per participant. 

Get to know Power BI by connecting, transforming and modelling your data. Build interactive visualisations to gain valuable insights and assist decision making.

Microsoft Power BI Desktop Introduction

Overview

Participants on this feature packed Microsoft Power BI Desktop Introduction 1 day course will gain an understanding of the fundamental principles of BI software. Learn how to connect to data sources, then model and transform the data. Once your data is prepared, you will then create rich interactive visualisations and reports that can be shared with colleagues.

No prior knowledge of Power BI Desktop is required.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

A friendly facilitator who made the learning process both informative and interesting, it was also a bonus of a small class enabled full participation and interaction with the facilitator.

B. Summerville

Upcoming Courses

Course Details

  • Skill Level: Beginner
  • Duration: One Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.8

Course Instructors

Course Content

Introduction to BI

  • What is Business Intelligence?
  • Components of BI Software
  • The Power BI Product Family

Power BI Desktop Orientation

  • What is Power BI Desktop?
  • Setting up Power BI Desktop
  • The Desktop Window
  • Navigating Power BI Desktop

Connecting to your Data

  • Getting Data
  • Connecting to Databases
  • Connecting to Website Data
  • Connecting to Excel Spreadsheets

Transforming your Data

  • About the Power Query Editor
  • Removing and Filling Blanks
  • Setting Column Headings
  • Removing Columns
  • Replacing Values
  • Changing Data Types
  • Trimming Text
  • Editing Applied Steps

Data Modelling

  • About Relationships and Data Modelling
  • Viewing Relationships
  • Removing, Creating & Managing Relationships
  • Hiding Tables
  • Working with DAX
  • Creating Calculations

Creating Visualisations

  • About Visualisations
  • Using the Visualisations Pane
  • Adding Report Pages
  • Creating Tables
  • Creating Cards
  • Building Charts
  • Working with Maps
  • Custom Visualisations

Using Filters

  • Highlighting & Filtering Visualisations
  • Defining Visual Interactions
  • Using Spotlight & Focus Modes
  • Setting Filter Levels
  • Top N Filters

Publishing Reports

  • About Publishing
  • Publishing a Report
  • Using Power BI Service
  • Sharing Reports

Frequently Asked Questions

Who uses Power BI?

Thanks to its user-friendly nature, Power BI can be used by a range of people within your business. How you use it will depend on your role, since it can generate reports and dashboards based on the data most relevant to you.

Business intelligence professionals use Power BI to create data models and reports to be shared within their organisation, however, your business may not have the scale or the need to support a full-time data guru. In this case, Power BI can be used as a self-service tool for different teams within your business.

Power BI works with just about any data you have, so you can report on almost anything, from databases and spreadsheets, to website analytics. As you might imagine, Power BI is popular with finance, operations, sales and marketing departments alike.

Should I buy a Power BI for Dummies book or attend a training course?

Good question. The Dummies book series is incredibly popular and very useful. One reason is that because they are focused on a single topic, or application, they can help eliminate some of the trial and error experienced by going down the Google search rabbit hole! Let’s face it, half of trial and error is, error!

Finding yourself a Power BI for Dummies book can help you to solve some of those tricky problems, and it’s a step in the right direction. We use reference manuals ourselves as a part of our commitment to professional development and keeping up to date. The issue is that it can still take time to find the information you need.

Our Power BI courses are designed to target the key features and concepts you need so you can get to work and apply them right away.

Why should I attend a Power BI course?

A training course with Keystroke Learning can set you up to take full advantage of your software. We love to pass on the best of our knowledge and experience to help you save time in your day to day work.

Our experienced trainers will walk you through the features and functions of the software, and you you’ll work right along with us to gain confidence, with tips and guidance to get the best out of the features. We also encourage participants to ask lots of question to make sure you get the most out of your learning experience.

What’s the difference between Power BI Desktop, Power BI Service and Power BI Pro?

Power BI is a collection of software services, apps, and connectors. They work together to turn your data into visually immersive, interactive insights.

The key components of Power BI are:

Power BI Desktop – this is the free desktop application that is used to connect to your data, transform (clean up), and create interactive visualisations. It also gives users the ability to publish to the Power BI service

Power BI Service – this is the online service (Software as a Service, or SAAS) used to display dashboards. These are used to display tiles, which can be selected to open more detailed reports. Power BI Service is also free provided you have an Office 365 licence.

Power BI Pro – this is a paid subscription service, costing (at time of writing) $9.99 per month. It includes data collaboration, data governance, creating dashboards and the ability to publish reports anywhere. Users can try it a free trial for 60 days before purchasing a subscription.

Important note: to share your content privately (e.g. within your organisation) you need a Power BI Pro license. The publish to the web option is not recommended for confidential data.

Generally, you will use Power BI desktop to connect to your data models and apply transformations, then share that data using the Power BI service.

Do I need to be an Excel expert to use Power BI?

Power BI is built on an Excel backbone, so it helps to know your way around Excel, however you don’t need to be an Excel guru. If you know how to sort and filter, lookup data, and maybe how to work with Pivot Tables and basic charts, you will probably find Power BI concepts somewhat familiar and you’ll be good to go.

Do I need to know how to code or write macros to use Power BI?

Not at all! In fact, Power BI is designed to be self-service so that you don’t need to know how to code. It’s visual, and quite intuitive once you get the hang of it. This doesn’t mean you can’t code in Power BI, (there’s a lot of stuff you can do in there if you like to tinker), but you really don’t need to know any coding at all.

Where to from here?

Your learning doesn’t stop once you’ve finished your course. We sincerely hope you will continue your experience by taking some time to practice what you have learned and apply it to your own situation and environment.

If we’ve done our job well, you may be inspired to learn even more by attending another course. If you’re looking for something other than Microsoft Power BI, we have a comprehensive range of courses to choose from.

We’re here to help, so please get in touch if you need any further advice.

Keystroke Learning

Learn Today with Keystroke Learning

As you can see, we have a wide array of top computer courses. Out training approach is professional yet friendly, motivating participants to learn quickly and easily. When you complete our training, you will be ready to apply your new skills right away. Course prices are listed on the Upcoming Courses page alongside the relevant course.

If you have a customised training solution in mind, please call us for a quote.

To schedule our popular computer courses, call (03) 9999 7780 or email us @ [email protected]