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.
Online Live - Course Dates
-
Online Live Class Dates
Book Now08 Feb 21 Mon Online Live 09 Mar 21 Tue Online Live 06 Apr 21 Tue Online Live 03 May 21 Mon Online Live 04 Jun 21 Fri Online Live -
To inquire about Online Live Classes, please
Call 1300 888 724
In-Class - Course Dates
-
Sydney Class Dates
Book NowLevel 11, 32 Walker Street, North Sydney , NSW 2060
08 Feb 21 Mon Online Live 25 Feb 21 Thu Classroom 09 Mar 21 Tue Online Live 26 Mar 21 Fri Classroom 06 Apr 21 Tue Online Live 20 Apr 21 Tue Classroom 03 May 21 Mon Online Live 18 May 21 Tue Classroom 04 Jun 21 Fri Online Live 18 Jun 21 Fri Classroom -
Melbourne Class Dates
Book NowLevel 12, 379 Collins Street, Melbourne , VIC 3000
03 Feb 21 Wed Classroom 08 Feb 21 Mon Online Live 25 Feb 21 Thu Classroom 09 Mar 21 Tue Online Live 31 Mar 21 Wed Classroom 06 Apr 21 Tue Online Live 28 Apr 21 Wed Classroom 03 May 21 Mon Online Live 24 May 21 Mon Classroom 04 Jun 21 Fri Online Live 24 Jun 21 Thu Classroom -
Brisbane Class Dates
Book NowLevel 6, 371 Queen Street, Brisbane , QLD 4000
08 Feb 21 Mon Online Live 15 Feb 21 Mon Classroom 09 Mar 21 Tue Online Live 01 Apr 21 Thu Classroom 06 Apr 21 Tue Online Live 03 May 21 Mon Online Live 04 May 21 Tue Classroom 04 Jun 21 Fri Online Live 07 Jun 21 Mon Classroom 21 Jul 21 Wed Classroom 30 Aug 21 Mon Classroom
-
Canberra Class Dates
Book NowLevel 4, 54 Marcus Clarke Street, Canberra , ACT 2601
08 Feb 21 Mon Online Live 09 Mar 21 Tue Online Live 06 Apr 21 Tue Online Live 14 Apr 21 Wed Classroom 03 May 21 Mon Online Live 26 May 21 Wed Classroom 04 Jun 21 Fri Online Live -
Adelaide Class Dates
Book Now19 Young Street, Adelaide , SA 5000
08 Feb 21 Mon Online Live 09 Mar 21 Tue Online Live 06 Apr 21 Tue Online Live 03 May 21 Mon Online Live 04 Jun 21 Fri Online Live -
Perth Class Dates
Book NowLevel 1, 140 St Georges Terrace, Perth , WA 6000
08 Feb 21 Mon Online Live 09 Mar 21 Tue Online Live 06 Apr 21 Tue Online Live 03 May 21 Mon Online Live 04 Jun 21 Fri Online Live
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
Related Courses
Course Reviews
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.