This course uses the Ottawa Open Data project to creat a 311 Service Dasshboard. In this course you will work with real data.
Prerequisite: Power BI Introduction
Highlights of course concepts:
- Binding reports to Web pages and folders.
- Cleaning data, identifying data inconsistencies and creating Power Query steps to correct them.
- Append and Merge Data
- Surrogate Keys
- Kimbal Methodology, Star Schema, Dimensional Modeling.
- Time Intelligence, Date Tables, Calculated Columns
- Measures
To register/inquire contact hello@generalBI.com.
Facilitator: Darcy Whyte is a globally recognized software developer and Power BI practitioner. He has certifications for Power BI and decades of experience with data. He has taught hundreds of courses and consistently receives high acclaim from students and companies.
What you need to attend this course:
- Power BI Desktop. For work computers refer to your software service center or your help desk. For personal computers, you will receive a link when you register to download the software for FREE.
- A computer with two monitors or more and a mouse.
- The course files (download link provided when you register).