Course Information

Overview

This course is designed for anyone working with a large amount of data who is wishing to analyse it and create eye catching visualisations. Participants will get hands-on experience learning key skills and concepts using example data based on real world scenarios.

Prerequisites

The student should be familiar with Excel and the concepts of datasets and basic reporting. Please note that this course is not suitable for inexperienced Excel or database users.

Outline

  • Power BI Concepts and Overview
  • Introduction to Main Features
  • Imports
  • Visualizations
  • Filters and Queries
  • Reports
  • 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
  • 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
  • Binning in Visualizations to create Histograms
  • Drill Visualizations using Dates
  • Clustering
  • Analytics and Forecast Lines in Visualizations
  • Creating Role Based Views
  • Data Categories
  • Geo-Data and Map
  • Common Activities using Query Editor
  • Filters
  • Transforms
  • Pivot and Group By
  • Creating Custom Calculated Column
  • Adding Conditional Columns
  • Using Conditional Columns Visualizations to create a Histogram
  • Introduction to DAX Expressions
  • Report Elements and Options
  • Working with Pages
  • Adding Graphics
  • Visual and Filter Settings
  • Export Power BI Data to CSV
  • Import Custom Visuals
  • What is a Dashboard?
  • Some Key Points when creating a dashboard
  • Overview of Basic Dashboard Design Principles
  • Questions to Ask Before Distributing Your Dashboard
Dates and Prices
Choose a location...

If you would like onsite training for this course, request a quote.

image
2 Days
Public Dates

Upcoming Dates

LondonMon 17th Feb 2020£745
Mon 24th Feb 2020£745
LondonMon 20th Apr 2020£745
Mon 20th Apr 2020£745
Mon 27th Jul 2020£745
More Dates

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle