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.