Develop Asset Dashboard in PowerBI

[dianamartin]

Reference epic #6804

[dianamartin]

• Created PowerBI dashboard called "AMD Asset Dashboard" in the network drive ATD>ATD_GIS>Business_Intelligence_BI_Dashboards>AMD Asset Dashboard
• So far configured the "Detection" page that referenced the Detection PowerBI Dashboard MMC had already created
  • got a chance to see how they built it

[dianamartin]

Met with stakeholders: Brian VDW, Lance and Allyson, Chrispin @john - They (MMC) requested publishing detector log to Socrata

• They need the detector events to create the dashboard to help Brian's maintenance reporting

They will work on getting the data from Brian C. (BBS & CCTV). Will keep Brian VDW in the loop.

They also asked about the ATD Premium workspace. I can add Lance/Allyson as contributors - Need to ask Spoorthy

Brian asked about timeline and Lance said like mid-September bc they (MMC) have UT prep to do

[dianamartin]

Added signal detection status log dataset to the OpenData portal like Allyson and Lance requested. Emailed them this morning.

[dianamartin]

@johnclary check it out

Status Update - MMC created dashboard

AMD Device Status Overview

PowerBI created by Kimley Horn

Pages

• Overview
• Signals
• Detector Status
• Detector History
• DMS
• CCTV
• BBS
• MMU
• WOs

Frequency: Daily, every hour

Sources: KITS, DataTracker via Socrata, spreadsheets (in the future have spreadsheets to DataTracker)

Signals

Detector Status

Detector History

DMS

CCTV

[johnclary]

wow—looks really good!

[dianamartin]

Synced up with Lance - 2/1

AMD Device Comm Status

• Only missing is the work order stuff.

When I had talked to Lance, he said he felt like the project was done. They'd just deal with the enhancement request once the AMD work order pick lists were refactored.