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.

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.

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

By the end of this course, students will be familiar with:

• Importing, questioning. combining and cleaning data
• The Power BI interface
• Filtering, mapping and visualising your data
• Introductory DAX
• Relationships between data tables
• Mining your data for insight

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