Excel - Power BI Summary Part 10/10

Over our last 9 blogs we have given you an overview of Power Bi

Power Bi Desktop puts visual analytics at your fingertips with intuitive report authoring. Drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly discover patterns as you explore a single unified view of linked, interactive visualisations

Course Duration: 1 Day

Course Types: Group Bookings, Public Scheduled Courses, 1-2-1 Sessions, Bespoke Tailored Courses.

Course Costs:

Public Courses : £250 +VAT      Next Scheduled Course Please call for details
Group Rate 1-8: £ 695 + VAT
Group Rate 1-12 :£ 695 + VAT
1-2-1 Rate £ 450 + VAT

View Scheduled Public Courses

Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Course Location: This Microsoft Power Bi is delivered at our training centres in London Venues; training can also be delivered at your offices. 

Course Outline:

Module 1: Getting Started with Power BI Desktop

Power BI Concepts and Overview

Introduction to Main Features

Imports

Visualizations

Filters and Queries

Reports 

Module 2: Connecting to Data Sources with Power BI Desktop

Data Sources Power BI Desktop will connect to

Data Types and Properties in Power BI Desktop

Import and Enter Data

Get Data and Query Editor 

Introducing the Query Editor

Using the Query Editor to Connect to Data 

Combining Data Sources as a Mash Up 

Working with Relationships in Data 

Module 3: Data Visualizations

Overview of Data Visualizations 

Tables and Matrix Views 

Applying Conditional Formats

Charts 

Interactive Data and Date Slicers 

Drill Visualizations to see underlying data

Create Reusable Field Hierarchies

Record Grouping and Binning in Visualizations 

Drill Visualizations with using Dates 

Clustering 

Analytics and Forecast Lines in Visualizations 

Creating Role Based Views 

Data Categories, Geo-Data and Maps

Module 4: Querying and Shaping the Data

Common Activities using Query Editor 

Filters 

Transforms 

Pivot and Group By 

Creating Custom Calculated Columns

Adding Conditional Columns

Introduction to DAX Expressions 

Histograms

Module 5: Reports and Dashboards

Reports and Output Options 

Report Elements and Options 

Working with Pages 

Adding Graphics 

Visual and Filter Settings 

Export Power BI Data to CSV

Create a Power BI Template

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London