Automate access to high-level Moped data points for TPWstat

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services

17 stars 2 forks source link

Automate access to high-level Moped data points for TPWstat #15506

Open amenity opened 7 months ago

amenity commented 7 months ago

[ ] Miles of bike lanes built
[ ] Projects under design by ATSD by group
[ ] Medium and Full Build Quality bikeway progress
[ ] Active Projects by group (i.e. VZ, Transit Enhancement, Speed Management, Other)

Charlie-Henry commented 7 months ago

@johnclary do you think any of these performance measures could be automatically reported on from the Moped RR?

johnclary commented 7 months ago

yes. are y'all getting these reporting needs from Moped stakeholders? with ATSD in particular, they already have a number of metrics that they either currently report on or are in discussion.

Charlie-Henry commented 7 months ago

Yeah @michael-santulli is getting their reporting manually. We're looking at making at automating as many of these TPWstat performance measures.

michael-santulli commented 7 months ago

@Charlie-Henry @johnclary yeah the current process is requesting the performance data from Laura, adding to a spreadsheet in sharepoint that is connected to PowerBI.

johnclary commented 7 months ago

Great. we will need to get with Nathan W., who almost definitely hands the data to Laura. he and I have a running list of Moped reporting todos which is quite sprawling and needs to be cleaned up + prioritized since the last batch of updates we shipped.

katelunceford commented 5 months ago

Data Science Backlog Refinement 4/24/24 notes

A PBI dataflow for Moped (#16708) could help this by making it easier to access Moped data in Power BI - maybe this would even fit OPM's needs for TPWstat?
[x] @katelunceford will schedule a meeting with Nathan W., Michael, Jewelee, Kate, Charlie, Susanne, Chia (optional) & Amenity (optional) - scheduled for 5/7/24