Use Power BI to connect to and visualize any data and seamlessly infuse visuals into the apps you use every day.

Power BI- Course Objectives

This two-day, hands-on course introduces users to Power BI, a business analytics solution that enables data visualization and insight sharing across an organization, as well as embedding reports in apps or websites. Designed for inexperienced users, the course familiarises delegates with the basic concepts of Power BI and demonstrates its practical business applications.

Power BI – Course Contents

Day 1

What is Power BI

Power BI Components, Power BI Features, Visualisations, Power BI Filters, Reports and Dashboards

Connecting to Data

Load a Spreadsheet, Remove a Data Sheet, Create Your First Visualisation

Adding Visualisations

Brand / Country Analysis

Format Visualisations

Change Colours for Data and Background.  Change Text Colours

Relationships

Rules for Relationships, Simple Relationship Diagram, Idealised Relationship Structure, Create a Table, Create a Relationship, Fixing the Pie Chart, Direct Relationships

Taking it Online

Publish the Current Report, Online Features

Report Pages

Rename a Page, Add a Page, Delete a Page, Create a Map, Create a Slicer, Adjust the Currency Formatting

Filters

Set Visualisation Level Filter, Set Page Level Filter, Report Level Filters, Drill through Filters

Adding columns

Calculated, Conditional

Adding a Measure

Calculate Average Total Cost, Using This Measure

Connecting to Data

Loading a CSV File

Using the KPI Feature

Create a KPI, KPI Options, KPI Alternative Visualisations, Market Place KPI Visualisations

Conditional Formatting

Creating a Table with Conditional Formatting

Some More DAX

Calculate

Day 2

Introducing DAX and Computations in Power BI      

Importing Data and Creating a Simple Report

Applying Conditional Formats

Computed Columns

Creating Measures

Grouping Data

Creating KPIs

Creating Conditional Columns

Modelling Data

Relationships

Creating A Data Pivot

Create a Calculated Table

Importing Data via Database Query

Three More DAX Templates

Improving Reports and Outputs Use of Demonstration Data        

Working with Multiple Report Pages

Adding Graphics to Reports

Export to CSV

Export to Excel

Export to PowerPoint

Power BI Templates

Power BI Apps

Power BI- Course Details         

This is a two day day company specific course running from 9:30 am – 4:00 pm. Courses run in Swansea, on-site and online.

 Prerequisites          

To gain maximum benefit from this course the delegate should be familiar with using a PC and be able to use a mouse.

Qualifications

Computeraid certificate of achievement