Site Loader
  • February 27, 2019
    1:00 pm - 4:00 pm

** Normally Power BI labs are the 3rd Wednesday every month but for February 2019 this lab is on the LAST Wednesday**

The Power BI lab will run monthly every 3rd Wednesday. We will run through a number of different topics and challenges but we would also like for COG Power BI practitioners to come in and showcase their innovative solutions to different problems.

In this session Canadian Coast Guard is going to showcase a full stack approach (a pilot project – Database > ETL > Data Warehouse > PowerBI > Publish to Intranet) to Business Intelligence reporting.

We are going to look at strategies to automatically calculate GOC fiscal year dates from regular dates without having to go to the trouble of building large, convoluted lookup tables as well as some other fiendish problems that I will set as challenges. If you have a laptop with Power BI desktop installed please bring it along. A sample dataset will be made available to registrants before the session.

We also encourage you to bring along your problems so that we can group brainstorm solutions together.

Power BI Logo




Venue Phone: (613) 680-3506

Venue Website:

123 Slater Street, 6th Floor, Ottawa, Ontario, Canada

Post Author: Stephen Davies

Stephen is the CEO of DAVHILL Group, a Business Intelligence and Data Analytics company based in Ottawa, Ontario.

He has more than 25 years of experience working in both public and private sectors. Early in his career in operations management he started to do data analysis and never quite escaped.

With an academic background in Physics and Engineering he has worked in semiconductor and OEM manufacturing as an engineer and supply chain director. As a Business Intelligence and Process Transformation consultant he seems to spend most of his time either playing with aircraft in the aviation industry or with the Federal Canadian Government.

As the CEO of the DAVHILL Group, Stephen's main focus is to make data real and useable for everybody. DAVHILL specializes in Business Intelligence, Artificial Intelligence and Machine Learning systems implementation and is delighted to provide training courses to the Data Action Lab.