City of Vancouver Demo

Purpose of Demo:

The purpose of this demo is to show some of the simple functionality of Power BI and what it can do. You will see how a data set can be imported and easily transformed into clear and intelligible visualizations.


311 is the direct number for the City of Vancouver (CoV). It’s used by residents of Vancouver when they have municipality-related questions, concerns or complaints.

When calls are received by CoV, information about each call is logged, tracked and stored in a data set. We have imported this data into Power BI so it can be processed and accessed in a convenient, intelligible and practical way. 

This data is publicly available through the City of Vancouver.


Click through the different pages using the arrows at the bottom of the dashboard.

Each page shows you a different dashboard:

    1. Vancouver 311 Calls
    2. Vancouver Business Licenses
    3. Vancouver Road Closures and Construction

Page 1 is an overview. It shows a list of incident types, the department that is responsible, and when the call was made. The charts are interactive and allow you to drill down.

Page 2 shows the number of business licenses in the CoV and when they were granted. The size of the box correlates to the number of business license types. This is further broken down by location in the lower right.

Page 3 illustrates when road closures, construction and upcoming projects have occurred in the CoV. This is further broken down by location on a map.