Language selection

Search


Sign in

Sign in

HPS Tableau Dashboard – ESDC

GC Data Demos05-11-2021

Employment and Social Development Canada creates an interactive visual analytic dashboard on the Homelessness Partnering Strategy to increase accessibility of program data to reduce the workload.

Contributor

Michelle Deslauriers
Senior Policy Analyst
ESDC

Transcript

The following short video will present ESDC's Homelessness Partnering Strategy Tableau Dashboard.

The purpose of this project was to create interactive visual analytics in the form of dashboards and to increase accessibility of program data to reduce the workload on our team.

Before the dashboard, each request for data was answered as we receive them, answers for frequently requested information and repetitive questions were also generated each time they came in. It was time consuming and required a lot of work for analysts to prepare these answers.

After, a dashboard in Excel format was developed and incorporated repetitive and frequently requested information and key performance indicators. This reduced the workload of analysts since an updated PDF dashboard was disseminated monthly across and outside the branch for users to retrieve data.

This led to the development of a new dashboard in Tableau. After developing the Tableau dashboard, the amount of requests we received significantly decreased.

The data is internal to ESDC, so access is granted to those who need it. Program information was easily accessed by users across and outside the directorate. Senior management was and is able to access program information directly from the dashboard using their laptops and BlackBerry anywhere at any given time.

This interactive dashboard allows users to access data in a way that is tailored to their needs, improve the use of digital digital visualizations and piloting automated processes. Overall, the dashboard is interactive and user friendly, but allows users to filter information by province and territory, community, service provider, funding stream, and breakdown by eligible activity areas and supported populations.

The dashboard is updated once a month and can be accessed via a web link that can be opened with Internet Explorer, Firefox, Google Chrome, within the ESDC networks.

How has it helped us, and our work, team and department? The dashboard was produced at the beginning of every month and is meant to support policy, contribute to program performance measurement, and engagement activities across the directorate. It includes results for the most frequently asked questions regarding funding allocation to projects, eligible activities, target populations, and it covers key performance indicators related to federal project outcomes. Overall, the time saved as a result of the Tableau dashboard allowed analysts to redirect their efforts to other projects.

Resources/ Courses

What is Data?
We’ve got the data, now what? How to leverage our data for better decision making & make inroads on business problems using data analysis.

Discover Series: Discover Data

The Role of Data in Digital Government (I511)

Making Data-driven Decisions (I514)

GC Data Community | GC Communauté des données

GC Data Community | GC Communauté des données

Created to connect, engage and support the growing community of data practitioners government | à mobiliser et à soutenir les spécialistes en matière de données au gouvernement

Recommended for you

Topic: Discover Series

Learning Path: Discover Cyber Security

Employ cyber security best practices to protect Government of Canada (GC) data, information, systems, and reputations.

a year ago3 min read

Topic: Discover Series

Learning Path: Discover Cloud

Get familiar with the opportunities, applications and limitations of cloud computing.

2 years ago2 min read

Topic: Discover Series

Learning Path: Discover Human-Centred Design

Get familiar with human-centered design principles and as a result, speak confidently to your colleagues about it and become curious to learn more.

2 years ago2 min read