25,000+ Courses Nationwide
0345 4506120

Microsoft 365 - An Introduction to PowerBI

This course is intended for business users and knowledge workers in a variety of roles and fields that wish to produce visually compelling and informative dashboards of their business's performance data.

Audience

This is an introductory course on this topic and  is designed for users who work predominantly with business data and want to go beyond the capabilities of Excel

Select specific date to see price, venue and full details.

Learning Objectives

By actively participating in this course, you will learn about the following:

  • Understand PowerBI concepts and main features.
  • Use data sources that are compatible with PowerBI Desktop.
  • Connect to data.
  • Explore data visualisations.
  • Apply common query tasks to shape data in PowerBI Desktop.
  • Create and publish reports.

Pre-Requisites

Prior knowledge of basic Excel functionalities would be beneficial.

Course Content

Lesson 1 - Getting Started with Power BI

  • Concepts and Overview
  • Introduction to Main Features
    • Imports
    • Visualisations
    • Filters and Queries
    • Reports

Lesson 2 - Connect to Data Source

  • Data Sources Power BI will connect to
  • Data Types - Data Behaviours
  • Importing and Entering Data - Creating Tables
  • Get Data and Query using Editor
  • Combining Data Sources as a mash up
    • Merge Queries
    • Append Queries

Lesson 3 - Working with Relationship View

  • Understanding Relationships
  • AutoDetect
  • Create using AutoDetect
  • Create Relationships Manually
  • Edit
  • Cross Filter
  • Join Types

Lesson 4 - Visualisations

  • What's Available
  • Create a quick Visualisation
  • Table and Matrix Visualisation
  • Conditional Formatting
  • Charts
    • Types
    • Create a Chart Visualisation
    • Analytics
    • Forecast
    • Create a KPI Visualisation
  • Slicers
  • Drill Visualisation
  • Clustering
  • Creating Role Based Views
  • Geo-data, Categorisation and Maps

Lesson 5 - Querying & Shaping Data

  • Filter
  • Pivot
  • Add Calculations

Lesson 6 - Reports and Outputs

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best