Power BI Ottawa Open Data Dashboard

This course uses the Ottawa Open Data project to create a 311 Service Dashboard. In this course you will work with real data. You’ll learn about best practices including the Kimbal method and dimensional modelling.

In this course you’ll learn to answer interesting questions like which neighborhoods have the most noise? Where are the most potholes reported?

Send prefered dates and group size to hello@generalBI.com.

Prerequisites

Any Power BI Desktop Introduction or Power BI Introduction.

Course Content

Binding reports to Web pages and folders.
Cleaning data, identifying data inconsistencies and creating Power Query steps to correct them.
Implementing a relative path for data sources.
Append and Merge Data
Surrogate Keys
Kimbal Methodology, Star Schema, Dimensional Modeling.
Data Normalization
Time Intelligence, Date Tables, Calculated Columns.
Measures, Calculated Columns, DAX (Data Analysis Expressions).

Send prefered dates and group size to hello@generalBI.com.

Course Setup Checklist

Power BI Desktop:
- Work computers: Install via your software center or contact your help desk.
- Personal computers: A free download link will be provided upon registration.
Computer with at least two monitors and a mouse.
The course files (download link provided when you register).

The course is incredibly valuable, and it’s clear that Darcy is an expert in Power BI with a talent for sharing his knowledge. He addressed all our questions during the training sessions and provided excellent supporting materials. I highly recommend this course to anyone starting in the Power BI world, as well as those with some prior experience. I previously took a course offered by Microsoft, but as someone without an IT background, I found some topics difficult to grasp. However, through this training session, I was able to connect many of the concepts I learned in the Microsoft course. I would rate it a 10/10. — Natalia

The course was an amazing introduction to PowerBI. All the credit to Darcy, who was engaging, patient (open to all questions and genuinely wanted to make sure everyone was keeping up), all while ensuring a practical pace for all participants. One of my co-workers was also attending and sent me a chat with "this teacher is the best" and I agree. Content and pace were perfect and the detailed step by step ppt slides will serve as a great reference in case I forget any steps. — Kana (Justice Canada)

Excellent course. Darcy was able to clearly explain how to use Power BI. I feel I am well informed to begin to create reports. — Kim G (Justice Canada)

One of the best training and trainers i've ever attended. As a very beginner to power BI, I found that his teaching style, his enthusiasm, humor, patience and kindness made everyone comfortable and at ease. He was very knowledgeable and had the ability to keep his audience engaged and interested. He was also very communicative and took the time to answer questions by email as well as during the class. The materials he provides included step by step instructions, with an understanding that some people need visuals and demonstration. I have taken other power bi courses in the past and this was the only one that made sense to me. Highly recommended! — Jade (Justice Canada)

Darcy provided us with many tools and explained many of Power BI's features in detail. He answered all our questions and repeated steps when necessary. It was entertaining and interactive, and he made sure everyone followed along and understood the concepts. I will definitely recommend this course! — Yessica (Justice Canada)

This was fantastic. Darcy did such a great job of explaining and provided a really perfect walk-through of the basic fundamentals. Thank you! — Katelyn Negin

I took Excel Level 1 yesterday with you. Very informative. You know your product and you seem very passionate about teaching as well. The overall was very interesting. I did enjoy you’re class. — Maryse Paré

Super engaging for a basics course. Loved learning pivot tables! — Brittany

I found this extremely helpful and engaging. The 2 hours flew by. — Monica

Thank you so much. I really enjoyed learning about power pivot and data query today! Your Excel enthusiasm is contagious. — Janine

Darcy is a great instructor. He’s extremely knowledgeable, engaging, and he also has a great sense of humour. I learned a lot of very useful information. Thanks! — Laurendeau

The course is incredibly valuable, and it’s clear that Darcy is an expert in Power BI with a talent for sharing his knowledge. He addressed all our questions during the training sessions and provided excellent supporting materials. I highly recommend this course to anyone starting in the Power BI world, as well as those with some prior experience. I previously took a course offered by Microsoft, but as someone without an IT background, I found some topics difficult to grasp. However, through this training session, I was able to connect many of the concepts I learned in the Microsoft course. I would rate it a 10/10. — Natalia

The course was an amazing introduction to PowerBI. All the credit to Darcy, who was engaging, patient (open to all questions and genuinely wanted to make sure everyone was keeping up), all while ensuring a practical pace for all participants. One of my co-workers was also attending and sent me a chat with "this teacher is the best" and I agree. Content and pace were perfect and the detailed step by step ppt slides will serve as a great reference in case I forget any steps. — Kana (Justice Canada)

Excellent course. Darcy was able to clearly explain how to use Power BI. I feel I am well informed to begin to create reports. — Kim G (Justice Canada)

One of the best training and trainers i've ever attended. As a very beginner to power BI, I found that his teaching style, his enthusiasm, humor, patience and kindness made everyone comfortable and at ease. He was very knowledgeable and had the ability to keep his audience engaged and interested. He was also very communicative and took the time to answer questions by email as well as during the class. The materials he provides included step by step instructions, with an understanding that some people need visuals and demonstration. I have taken other power bi courses in the past and this was the only one that made sense to me. Highly recommended! — Jade (Justice Canada)

Darcy provided us with many tools and explained many of Power BI's features in detail. He answered all our questions and repeated steps when necessary. It was entertaining and interactive, and he made sure everyone followed along and understood the concepts. I will definitely recommend this course! — Yessica (Justice Canada)

This was fantastic. Darcy did such a great job of explaining and provided a really perfect walk-through of the basic fundamentals. Thank you! — Katelyn Negin

I took Excel Level 1 yesterday with you. Very informative. You know your product and you seem very passionate about teaching as well. The overall was very interesting. I did enjoy you’re class. — Maryse Paré

Super engaging for a basics course. Loved learning pivot tables! — Brittany

I found this extremely helpful and engaging. The 2 hours flew by. — Monica

Thank you so much. I really enjoyed learning about power pivot and data query today! Your Excel enthusiasm is contagious. — Janine

Darcy is a great instructor. He’s extremely knowledgeable, engaging, and he also has a great sense of humour. I learned a lot of very useful information. Thanks! — Laurendeau