Courses

Power BI Essential Skills

= Scheduled class    = Guaranteed to run    = Fully booked

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

Our aim is to provide the foundation for immediate use and future development. We will show you what Power BI can do and introduce many timesaving tricks and tips. Power BI is a tool for generating reports from large and varied data sources. This makes tasks like analyzing and viewing data easy and efficient.

Prerequisites

It is recommended that attendees are familiar working with data and simple reports. It is also helpful to have some experience working with datasets involving more than one table, and a basic understanding of how they are related.

It is necessary to have a basic understanding of:

• Formulas in Excel
• Basic Excel functions (including SUM, SUMIF, IF)
• Charts and graphs
• Tables and their properties (fields/columns and records/rows)

It is helpful, but not necessary, to have a basic understanding of:

• Lookup and reference functions in Excel (VLOOKUP, INDEX & MATCH)
• Pivot tables or charts

Course Outline

In this course we cover the basic features such as:

• Importing data from a variety of sources
• Detecting relationships between tables within our data
• Cleaning up our source data.
• Creating basic formulas and calculations.
• Filtering our data to focus on exactly what we want.
• Choosing the right visualizations to display data in an effective way.
• Sorting data to display correctly in your report
• Mapping data.
• Customising reports to display meaningful titles and colours.
• Creating dashboards to view our data from any device.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.

 Print this page