POWER BI TRAINING COURSES

POWER BI BEGINNER

Target Audience

This course is aimed at the experienced Microsoft Excel or Access user that requires more advanced tools to manipulate, visualise and share information to improve decision making.

It will show the user how to connect to and transform data from various data sources, utilise repeatable work flows and introduce Data Modelling and Data Analysis Expressions (DAX).

The course will show how to create a range of visualisations from datasets and how to use the Power BI Service to share and collaborate with other users.

Prerequisites

Good experience with Microsoft Excel or Access is a prerequisite for this course.

Duration:

1 Day

Price:

Prices start from $360.00 (including GST) per day but may vary based on location.

Course Dates - ONSITE (Your Premesis):

Dates are available for this course

Please Contact Us to schedule one that works for you

Schedule a Date


 

Course Dates - ONLINE-LIVE:

Dates are available for this course

Please Contact Us to schedule one that works for you

Schedule a Date

 

Course Files:

Download Course Files

 

COURSE OUTLINE

About Power BI

  • What is Power BI
  • Components of Power BI
  • Relational Database Basics
  • Power BI Desktop Orientation

Connecting to Data Sources

  • The importance of Updating Power BI
  • Connecting to Excel / Text files
  • Connecting to Access
  • Connecting to an SQL database
  • Viewing Inherited Relationships
  • Connecting to the Web

Cleaning Data

  • Viewing the Query Editor
  • Working with Columns and Rows
  • Applying Field Formats
  • Trimming and Cleaning Data
  • Filling Data Gaps
  • Splitting and Merging Columns
  • Removing Duplications and Errors
  • Unpivoting Matrices
  • Merging Queries
  • Appending Queries

Repeatable Work Flows

  • Viewing the Actions Panel
  • Being aware of "M" language
  • Editing Actions
  • Reordering Actions
  • Removing Actions

Data Modelling

  • Understanding Data Relationships
  • Viewing Existing data Relationships
  • Removing Relationships
  • Creating New Relationships

 

Data Analysis Expressions (DAX)

  • What is DAX?
  • Writing Basic Expressions
  • Creating Measures
  • Using the RELATED function
  • Using the SUMX function
  • Using CALCULATE
  • Using FILTER with CALCULATE
  • Using TIME related functions

Creating Visualisations

  • Adding a Card Visualisation
  • Creating Lists and Matrix Visualisations
  • Creating Column and Bar Charts
  • Creating Line Charts and Pie Charts
  • Adding a Gauge Visualisation
  • Using Visuals as Filters
  • Adding Slicers
  • Formatting Visuals
  • Applying Visual Level Filters
  • Applying Page Level Filters
  • Applying Report Level Filters
  • Applying Drillthrough Filters

Power BI Service

  • Requirements
  • Logging In
  • Publishing to the Power BI Service
  • Creating Dashboards
  • Pinning Visuals to the Dashboard
  • Quick Insights
  • Sharing Dashboards and Reports
  • Designing Views for Mobile Devices

Power BI Resources

  • Online Content
  • Downloadable Samples