Meeting: AMD PowerBI Dashboard Assist - Kick Off

[dianamartin]

Meeting scheduled 7/19

Objective

• See what AMD is trying to build in PowerBI, determine if Annie has bandwidth to tackle project otherwise Diana can help.
• Reference #6513

Participants

Lance, Allyson, Annie, Diana

Agenda

Add agenda here or create agenda from this template and add link.

---

• [x] Schedule meeting
• [ ] Optional: Schedule debrief
• [x] Meet and take notes
• [ ] Optional: Debrief with DTS team members
• [ ] Create resulting issues

[dianamartin]

Diana's Notes

• Using data and tracking with lot of information
• traffic volumes
• query and analysis tool
• internal reporting -operations side of the house -visualizing those thing

TOP 10 KITS Signal Event Locations Dashboard

• Event log, SQL database (KITS?)

TOP 10 SR Locations

• querying Open Data logs
• Can find the issues for locations

Arterial Coordinator Database

• Excel Detection
• Detection Open Data Portal
• KITS database
• Open Data portal queries
• Similar to this report

NEW DASHBOARD: Device Status report

• Detection (Data Tracker) - Detector Status
  • Number of Intersections that have fully working detection v. one or more detectors broken
• DMS (KITS Query)
• Spreadsheets Battery Backup Systems - if online or not (static), later integrated in KITS
• CCTVs (Traffic Cameras, open data portal)
• Work Orders - work orders with activities to repair things (Traffic Signal Work Orders, Open Data portal)
  • "keyword: repair"
• ATD>Arterial Management>TMC>Dashboards
  • Queries in file (yellow icons)

[dianamartin]

Created follow-up issues for to do AMD Dashboard discovery on what AMD has already configured. Task is to connected using OData link to Open Data dataset and PowerBI before meeting.

[dianamartin]

Lance to email us details of what their dashboard needs are:

Below is a summary of the report we wish to create with links to examples.

AMD Device Status Report – Power BI

• Detection
  • Source: Data Tracker
  • Example: [here](g:\\ATD\Arterial Management\TMC\Dashboards\) - Detection
  • Goals:
  • Display detector data by location
  • Measure percent of overall detector status
  • Measure percent of intersections with all detectors working
  • Track newly broken or repaired detectors (would require new data published from Detector Activities/History)
• Dynamic Message Signs (DMS)
  • Source: KITS SQL
  • Example: (query KITS SQL similar to this [example](g:\\ATD\Arterial Management\TMC\Dashboards\MMC Weekly\) - MMC Weekly Dashboard , but different table)
  • Goals:
  • Display DMS status by location
  • Measure overall DMS status
• Battery Backup Systems (BBS)
  • Source: Excel
  • Example: forthcoming (need to coordinate with Brian Craig)
  • Goals:
  • Display DMS status by location
  • Measure overall DMS status
• Traffic Cameras (CCTVs)
  • Source: Excel
  • Example: forthcoming (need to coordinate with Brian Craig)
  • Goals:
  • Display DMS status by location
  • Measure overall DMS status
• Work Orders (WOs)
  • Need further coordination with Diana & BVDW

Use this [report ](g:\\ATD\Arterial Management\TMC\Dashboards\) - Top N as an overall template for style.

[dianamartin]

Closing, created follow-up meeting #6695 with Annie to discovery AMD's dashboards