Power BI

Use Power BI to create rich, interactive data visualisations from multiple data sources and share important business insights that drive success.

Power BI- Course Objectives

This two day Power BI course is designed to familiarise the inexperienced user with the concepts of Power BI and its business uses. Power BI is a business analytics solution that lets you visualize your data and share insights across your organization.  You can embed these data visualisations in your app or website.

 

Power BI – Course Contents

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 company specific course running from 9:30 am – 4:00 pm. Courses run in Swansea, on-site and online. Please email for further information.

Prerequisites

Attendees will gain the maximum benefit if they have attended our Excel Intermediate course or are familiar with creating basic spreadsheets and using simple functions.

Qualification

Computeraid certificate of achievement.

 

The more you learn, the more you earn

© 2024 Computeraid
Website by NETBOP