Welcome to our training catalog. All courses are provided in-house and the courses listed below can be mixed to meet your needs.

Please contact us to discuss what courses would best match your requirements and if you have any questions on specific courses or course categories.

 

1
Yes
List
List
Thumbnail
1
1000000
Search...
/training-catalog/
List
Filter
Clear All

Categories:

Tags:

Product Code:

Course Duration (hours):

Microsoft Power BI
Courses to teach the use and application of Microsoft Power BI.
An overview of Microsoft Power BI
An overview of Microsoft Power BI Image

This module is designed for the absolute Power BI beginner. We walk the participants through the Power BI basics including:

  • How Power BI fits into a larger software framework
  • Where, and where not to use Power BI
  • Excel vs Power BI – pros and cons
  • A Power BI walkthrough
  • Power Query (with a brief overview of M)
  • Data Modeling view
  • Data layout view
  • Data visualization view
  • What is DAX and how it is used
  • How to publish with Power BI

At the end of this session participants should be comfortable with what Power BI should be used for and have the ability to open a simple data set and create some simple visualizations

Product Code: PBI-1
Course Duration (hours): 4
Power BI - Building Basic Visualizations
Power BI - Building Basic Visualizations Image

This module is aimed at taking participants through the initial stages of inputting data and creating their first interactive charts, reports and visualizations. This module will help you to:

  • Understand the importance of clean data
  • How to import data from single and multiple data sources
  • Manipulating the data as it is imported into Power BI
  • Creating our first calculations
  • Creating our first custom columns
  • Creating our first charts
  • Basic interactive filtering
  • Creating basic hierarchies of data
  • How to layout a report and dashboard
  • How to publish reports and dashboards to end users
Product Code: PBI-2
Course Duration (hours): 8
Power BI - Beyond the Basics
Power BI - Beyond the Basics Image

This module is aimed at taking participants past their first chart creation in Power BI and to shortcut the user to some relatively sophisticated visualizations that are not technically difficult to create. The module will help you to:

  • Get a head start on Data Modeling
  • Get up to speed in DAX – effective and easy top tips
  • Get up to speed in M – effective and easy top tips
  • How to overcome common data analysis issues
  • Useful intermediate Power BI “hacks”
  • Introduction to non-standard charts
Product Code: PBI-3
Course Duration (hours): 8
Power BI - A Deeper Dive into Data Modeling
Power BI - A Deeper Dive into Data Modeling Image

This module is designed to look in more depth in data modeling in Power BI. Excel users are very used to data presented as a flat file (a tab or table) but to extract the greatest value from Power BI we need to look at our data from a dynamic, relational perspective. In this course we will:

  • Learn in detail what makes a good data model
  • Understand how to optimize data models for data visualization
  • Where to use cross reference tables
  • How to create dynamic cross reference tables that adjust to changing input data
  • How to optimize data models for large data sets
Product Code: PBI-4
Course Duration (hours): 4
Power BI - Integrating R and Python
Power BI - Integrating R and Python Image

In this module we will work with participants to integrate both R and Python script into Power BI. A high-level understanding of either R or Python is required but the course presenter will walk participants through some basic R script and/or Python. If this course is purchased as an in-house module we can concentrate specifically on R or Python or both at the discretion of the client. In this course participants will learn how to:

  • Embed R script to import data in Power BI
  • Embed Python to import data in Power BI
  • Combining imported data into existing Power BI data model
  • Using R script and/or Python to create interactive visuals in Power BI
Product Code: PB-5
Course Duration (hours): 4
Power BI - Supervised Self Learning
Power BI - Supervised Self Learning Image

There are many online resources to learn Power BI (for example the Microsoft / EDX course). Unfortunately, GOC employees are not always able to access these courses at their desk or at home.

To address this issues Data Action Lab hosts interactive learning environment where participants can work through the on-line learning in a supervised environment. The learning is self paced and a technical expert is on hand to help the learner through any issues. This module can be delivered in house but there is a minimum commitment of three months once per week

Product Code: PBI-6
Course Duration (hours): 32
Power BI - Monthly Laboratory
Power BI - Monthly Laboratory Image

The Data Actional Lab holds a series of Data Labs on various topics. The Data Lab on the third week of each month is dedicated to GOC Power BI users. Each month is different but typically participants bring along problems for the group to solve. To attend the ongoing Data Labs a monthly attendance fee is required. The payment of this fee allows the organization to send up to five participants to any of the labs through the month. For more details please see the Data Action Lab website

Product Code: PBI-7
Course Duration (hours): 48
Microsoft Power BI
Courses to teach the use and application of Microsoft Power BI.
An overview of Microsoft Power BI Image
An overview of Microsoft Power BI
This module is designed for the absolute Power BI beginner. We walk the participants through the Power BI basics including: How Power BI fits into a larger software framework Where, and where not to use Power BI... Read More
Product Code: PBI-1
Course Duration (hours): 4
Power BI - Building Basic Visualizations Image
Power BI - Building Basic Visualizations
This module is aimed at taking participants through the initial stages of inputting data and creating their first interactive charts, reports and visualizations. This module will help you to: Understand the importance of cle... Read More
Product Code: PBI-2
Course Duration (hours): 8
Power BI - Beyond the Basics Image
Power BI - Beyond the Basics
This module is aimed at taking participants past their first chart creation in Power BI and to shortcut the user to some relatively sophisticated visualizations that are not technically difficult to create. The module will help you to:... Read More
Product Code: PBI-3
Course Duration (hours): 8
Power BI - A Deeper Dive into Data Modeling Image
Power BI - A Deeper Dive into Data Modeling
This module is designed to look in more depth in data modeling in Power BI. Excel users are very used to data presented as a flat file (a tab or table) but to extract the greatest value from Power BI we need to look at our data from a dy... Read More
Product Code: PBI-4
Course Duration (hours): 4
Power BI - Integrating R and Python Image
Power BI - Integrating R and Python
In this module we will work with participants to integrate both R and Python script into Power BI. A high-level understanding of either R or Python is required but the course presenter will walk participants through some basic R script a... Read More
Product Code: PB-5
Course Duration (hours): 4
Power BI - Supervised Self Learning Image
Power BI - Supervised Self Learning
There are many online resources to learn Power BI (for example the Microsoft / EDX course). Unfortunately, GOC employees are not always able to access these courses at their desk or at home. To address this issues Data Action Lab ... Read More
Product Code: PBI-6
Course Duration (hours): 32
Power BI - Monthly Laboratory Image
Power BI - Monthly Laboratory
The Data Actional Lab holds a series of Data Labs on various topics. The Data Lab on the third week of each month is dedicated to GOC Power BI users. Each month is different but typically participants bring along problems for the group t... Read More
Product Code: PBI-7
Course Duration (hours): 48