Courses

Power BI Essential Skills

Length: 1 Day    Cost: $525 + GST    Version: Power BI

Centre	Jan	Feb	Mar	Apr
Auckland	--	--	05 24	24
Hamilton	--	--	03	--
Christchurch	29	16	22	27
Wellington	27	22	30	13
Virtual Class	--	--	--	--

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

This course will introduce you to Microsoft’s Power BI tool for analysing and visualising data, bringing business intelligence capabilities into your hands. In this hands-on workshop, you will explore the capabilities of Power BI and discover how it can help your company get real insights and valuable information from your data.

Audience

Analysts, managers, data scientists and anyone who is interested in visualizing data to get actionable insights quickly and easily. This course covers the essential skills of Power BI at all stages, so is suitable for those who have never used Power BI as well as beginners who are just starting out in their Power BI journey.

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

Power BI Introduction

• Import data from a variety of sources
• Detect relationships between tables within our data
• Ask questions about your data – and get an answer instantly

Power BI Data Model

• Discover, combine and shape data from multiple data sources
• Clean up source data
• Create 1 to many relationships between data tables

Data analytics

• Perform basic calculations to gather additional insight from your data
• Introduction to DAX

Data visualisation for Easy Snapshots

• See your data in new ways with bold interactive visualisations with Power BI
• Filter your data to focus on exactly what you want
• Map data to analyse relationships

Real-time analytics

• View and share your data from any device
• Create dashboards in Power BI Service
• Drill-down into the information that matters to you
• Refresh your data to ensure the latest information is displayed

 Print this page