All training 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.
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
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
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
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
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
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
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