Microsoft 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.
Microsoft Power BI Introduction
Microsoft Power BI Introduction
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.
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
- About Relationships and Data Modelling
- Viewing Relationships
- Removing, Creating & Managing Relationships
- Hiding Tables
- Working with DAX
- Creating Calculations
- About Visualisations
- Using the Visualisations Pane
- Adding Report Pages
- Creating Tables
- Creating Cards
- Building Charts
- Working with Maps
- Custom Visualisations
- Highlighting & Filtering Visualisations
- Defining Visual Interactions
- Using Spotlight & Focus Modes
- Setting Filter Levels
- Top N Filters
- About Publishing
- Publishing a Report
- Using Power BI Service
- Sharing Reports
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 FAQ's
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.
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.
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.
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.
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.
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.
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.
Learn Today Face to Face Online with Keystroke Learning
Learn with Keystroke Learning
Our training approach is professional yet friendly, motivating participants to learn quickly and easily.
When you complete our training course, you will be ready to apply your new skills right away.