1300 888 724 8.30am to 5:30pm AEST (Mon-Fri) info@dynamicwebtraining.com.au

Power BI for Excel 2016

(4.83 out of 5) 130 Student Reviews

About the Course

This Power BI course is suitable participants who have already have advanced knowledge of the Microsoft Excel 2016 and wish to implement Business Intelligence components into their workbooks and use visualisation tools.

The course will cover QUERY from the Get and Transform in Excel 2016 along with connecting data through SQL Server Connections. Students will learn how to obtain data from Access, Text Files, the Web and Excel files and tables and then transform the tables by renaming, removing, splitting and merging table columns. We will also cover various filtering techniques as well as aggregating values, calculating columns, unpivoting rows and merging queries.

This course will also introduce participants to Data Analysis Expression (DAX) language and bring together Text Based Visualisation with Pivot Tables using Cards and the Matrix views to see the results of DAX functions.

Who should do this course?

This Power BI course is suitable for participants who want to extend their advanced Excel skills and be able to implement Business Intelligence within their Excel workbooks.

Prerequisites

Participants should have already completed up to our Advanced Excel 2016 Course or have equivalent skills.

Course Details

  • $385 incl GST
  • Duration: 1 Days
  • Max. Class Size: 10
  • Avg. Class Size: 5
  • Study Mode: In Class Live Online
  • Level: Specialist
  • Times: 9.00am to 5.00pm approx
  • Download Course PDF
  • Enquire Book Now
    Pay later

Online Live - Course Dates

  • Online Live Class Dates

    Book Now
    19 Oct 20 Mon
    18 Nov 20 Wed
    11 Dec 20 Fri
    14 Jan 21 Thu
    08 Feb 21 Mon
    09 Mar 21 Tue

  • To inquire about Live Online Classes, please

    Call 1300 888 724

In-Class - Course Dates

  • Sydney Class Dates

    Book Now

    Level 11, 32 Walker Street, North Sydney , NSW 2060

    22 Oct 20 Thu
    01 Dec 20 Tue
    04 Jan 21 Mon
    04 Feb 21 Thu
    01 Mar 21 Mon

  • Melbourne Class Dates

    Book Now

    Level 12, 379 Collins Street, Melbourne , VIC 3000

    09 Dec 20 Wed
    08 Jan 21 Fri
    03 Feb 21 Wed
    04 Mar 21 Thu
    30 Mar 21 Tue
    28 Apr 21 Wed
    24 May 21 Mon
    24 Jun 21 Thu

  • Brisbane Class Dates

    Book Now

    Level 6, 371 Queen Street, Brisbane , QLD 4000

    06 Oct 20 Tue
    29 Oct 20 Thu
    30 Nov 20 Mon
    05 Jan 21 Tue
    15 Feb 21 Mon

  • Canberra Class Dates

    Book Now

    Level 4, 54 Marcus Clarke Street, Canberra , ACT 2601

    13 Jan 21 Wed
    24 Feb 21 Wed
    14 Apr 21 Wed
    26 May 21 Wed

  • Adelaide Class Dates

    19 Young Street, Adelaide , SA 5000

    Classes scheduled on demand in Adelaide

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Perth Class Dates

    Level 1, 140 St Georges Terrace, Perth , WA 6000

    Classes scheduled on demand in Perth

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

Course Units

Expand full topic list

Unit 1: Get and Transform Introduction

  • Link external data to Query
  • Understand the Query Editor
  • Use the Query Settings
  • Apply Query Options
  • Import Data into the Data Model
  • Edit an Existing Query

See more

Unit 2: Accessing Data Types from Query

  • Create a SQL Server connection
  • Understand the Database Query Editor
  • Review data download from the Database
  • Import data from Text Files
  • Import data from a Folder
  • Import data from Excel files
  • Work with data from the current Workbook
  • Import data from an Access Database
  • Import data from the Web

See more

Unit 3: Transforming Data in Query

  • Name Columns
  • Remove Columns
  • Split Columns
  • Merge Columns
  • Set Column Data Types
  • Filter Rows
  • Filter Row Ranges
  • Remove Duplicate Values
  • Filter Out Rows with Errors
  • Sort Columns
  • Change Values in A Table
  • Use Text Transformations
  • Use Fill Up and Down to Replace Missing Values
  • Aggregate Values
  • Calculate Values across Custom Columns
  • Duplicate Columns
  • Unpivot Columns to Rows
  • Merge Queries

See more

Unit 4: Importing Data into PowerPivot

  • Load data from a Server Database
  • Preview and Filter a Table
  • Write queries to select data from a Database
  • Load Views from a Database
  • Load Tables from an Access Database
  • Load Data from Text Files
  • Load Data from Excel files
  • Load Data from Excel Table

See more

Unit 5: Data Model Relationships

  • Create table relationship Joins
  • Manage Relationships
  • View Relationships

See more

Unit 6: Transforming Data in PowerPivot

  • Rename Tables
  • Delete Tables
  • Move a Table
  • Freeze and Unfreeze Columns
  • Hide Columns
  • Filter Columns
  • Sort Columns
  • Sort a Column Based on Another Column
  • Hide Tables
  • Create a hierarchy
  • Alter Table Behaviour

See more

Unit 7: PowerPivot vs Query

  • Understand the difference between Power Query and PowerPivot

See more

Unit 8: DAX Measures for Columns

  • Create a Concatenated column
  • Create a Calculated column
  • Use the RELATED function
  • Complete a Task
  • Create a Hierarchy
  • Calculate Across Tables
  • Use the RELATEDTABLE and ROWCOUNT functions
  • Use the IF and ISBLANK Functions

See more

Unit 9: DAX Measures and Metrics

  • Create a count Measure
  • Create Measures with multiple tables
  • Use the SUMX function
  • Filter using the CALCULATE Function
  • Use the FILTER function

See more

Unit 10: DAX Time Intelligences Calculations

  • Create a Calendar
  • Create Calendar Values
  • Create Year to Date Sales
  • Create Month to Date Sales

See more

Unit 11: Text Based Calculations

  • Create a Pivot Table
  • Create a Table Visualisation
  • Modify and move the Table
  • Create a Card Visualisation
  • Create a Matrix Visualisation
  • Filter a Table, Card and Matrix

See more

Unit 12: Power View Chart Visualisations

  • Create a Single Field Chart
  • Sort a Chart
  • Change Data Bar Colours
  • Change Chart Title, Legend and Data Labels
  • Create Multiple Charts
  • Create Multiple Unique Charts on a View
  • Filter Using Charts
  • Creating a Bubble Chart
  • Tracking Specific Data in a Bubble Chart

See more

Unit 13: Power Maps

  • Open Power Maps
  • Add Geocode to Power Maps
  • Navigating 3D Map
  • Add Values to the 3D Ma
  • Add Categories to the 3D Map
  • Add Time Dimension to 3D Map
  • Filter 3D Maps
  • Playing a Tour

See more

Training Packages

Microsoft Training Package

Book any two 1-day Microsoft Office courses and receive a third 1-day Microsoft office course for FREE!

$ 770 incl GST

(You save $385)

Duration

3 days

Enquire Book Now
Pay later

Related Courses

Course Reviews

(4.60 out of 5) DANIEL D [ 03 August, 2020 ]
Magnificent course; i have now completed all excel courses. After doing this one, i will enroll in Power Desktop BI.
(4.90 out of 5) WILLIAM W [ 10 February, 2020 ]
A very useful class with a lot of information and the instructor has shown a lot of useful functions. They would be super helpful in my work.
(5.00 out of 5) Libby T [ 10 February, 2020 ]
This great course provided us with extended knowledge of this product plus a lot of hands on work. Grant created a wonderful learning environment where all our questions were answered and anyone who fell behind in exercises was supported in a friendly and professional way.
(5.00 out of 5) Prakesh K [ 08 January, 2020 ]
Course was very informative and well instructed. I feel I will take the free resit option in t he future to harness what I have learnt today.

Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top