“Power BI is a suite of business analytics tools to analyze data and share insights.

 From Data to Awesome Dashboards!”

(Course duration – 2 days)

Introduction

Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 7 years. They give Excel users the power to draw information out of multiple sources, link it together and perform calculations on it that can then be sliced & diced any way you want.

This hands-on course is focused on real-world techniques utilising the amazing capabilities of
Power BI. The course covers the core elements needed to get an understanding of what Power BI
can do. You will use Power Query to extract and shape data and then load and build a complex
Power Pivot Model from scratch, write DAX formulas and set up interactive reports.

Get more insights from your data, whether it’s stored on your computer or the cloud. Learn how to connect to and merge data with Power BI Desktop, the powerful data analysis and visualization software. In this course, you’ll learn how to connect various data sources, including Excel, Access, and web data sources, and search and transform the data with simple queries.

What you will learn in Power BI Desktop Course

Connect, import, shape, and transform data for business intelligence (BI)

Visualize data and automate refresh of your reports

Create dashboards based on reports in Power BI desktop and Excel

Use natural language queries

Topics Include

Power BI Overview

Differences between Excel Power BI / Power BI Desktop

Installing and launching Power BI Desktop

Connecting to Excel and CSV files

Connecting to a database or web data

Introduction to Power Query

Connecting & Querying data

Combining data from multiple sources

Shaping Data in Power Query

Introduction to Power Pivot

Creating relationship between tables

DAX functions

Creating & Customising Visualisations

Charts, Treemaps, Maps, Tables & Card Visualisations

Create Reports and Dashboards

Publishing to the Power BI cloud service

Power BI Q&A Natural Language

Pre-requisites

Participants must have intermediate to advance knowledge in Excel. Having hands on experience
with Pivot tables, functions such as SUMIF, VLOOKUP & IF and Excel’s commands such as Filtering, Text to Columns and sub totals.

Previous client that we have conducted training with