Project: Dash v1.0

[amenity]

This website is a central starting point to find TPW's authoritative dashboards, reports, maps, and datasets all in one place.

Background

There's not currently a site, tool, or platform where you can find the latest, most important dashboards, reports, maps, and datasets across TPW all in one place. You'd have to go on a scavenger hunt, involve many people, many meetings, and use several different tools to eventually (maybe) find your answer. Even if you have the process down like the OPM (Office of Performance Management) team does every month for TPWstat, it takes considerable time and effort each instance. Multiply that time by everyone at TPW who needs to find and/or share dashboards, reports, maps, and/or datasets, and you can see the widespread impact this problem cultivates.

By creating a central, trusted starting point for executives, leaders, and staff to find and browse authoritative dashboards, reports, maps, and datasets, we hope to help alleviate a string of common pain points related to data and reporting for many at TPW:

• How can I quickly get my team and/or leadership the data they need?
• Where can I find various data, charts, graphs, and maps at the time I need them?
• Is the data up to date?
• How can we increase transparency into data and reporting across the department?
• What are other work groups up to?
• How can I let others know about the work my group is doing?

Scope & Deliverables

In scope, we will:

• Extend the DTS Portal Knack application to track TPW dashboards, reports, maps, and datasets
• Configure a tagging or other organizational/filtering system
• Design and build a website UI using the Data and Performance Hub as the starting point
• Feature a handful of dashboards, reports, maps, and datasets to start
• Identify and incorporate comprehensive, authoritative data and reporting across TPW and its individual work groups

In scope, we will deliver:

• A trusted data and reporting space where anyone at TPW can easily browse and filter dashboards, reports, maps, and datasets by and for TPW

Desired Outcomes

Desired outcomes include:

• One trusted place that shows real-time data of TPW's performance with an easy-to-understand design
• Executives, leaders, and staff use it

Concepts & References

---

This Github issue represents a project of Austin Transportation's Data & Technology Services team. Project status is documented regularly in the comments below.

[amenity]

In January, while @katelunceford finishes APWA Certification, Erin W. (Finance) will be looking at financial measures and give feedback on the MVP dashboard.

[amenity]

@katelunceford has been talking to Paige W, who has been managing PW Stat from OPM about this project. As a dynamic department dashboard would be a uture product "TPW Stat" would

@Charlie-Henry pointed out that beyond offering a dynamic dashboard, we should consider Dash a data warehouse that users can utilize for their own queries.