TargetedconservationDatadidn’talignhistoricallyWe didn’tknowwhere thatdata livedWe’reworkingon thatLearnedthis thehard waySpreadsheetis the systemof recordReal-timedataDemandforecastingmentionedStaffingenuitysaved thedayGIS linked tometers/accountsAIDocumentationmade adifferenceCustomerportal inuseInheritedlegacysystemsScriptscompensatefor systemgapsDatacleaningtookforeverDifferentstaff gavedifferentanswersInteroperabilitySinglesourceof truthWe haveAMI… butdon’t useit yetDatagaps inhistoryDashboardspull frommultiplesystemsIncrementalprogressbeats perfectsystemsHad towritecustomqueriesManualprocessSomeonelaughs attheir ownsystemCWOLreportingdonemanuallyThis isn’tperfect —but itworksAMI + CISfinallyintegratedDatasupportswaterbudgetsAPIlimitationsVendorlimitsdiscoveredlateDefensibledataRepeatableworkflowsItdependsSiloedsystemsDatatriggerscustomermessagingWe paidto accessour owndataRFPchangedafter lessonslearnedTargetedconservationDatadidn’talignhistoricallyWe didn’tknowwhere thatdata livedWe’reworkingon thatLearnedthis thehard waySpreadsheetis the systemof recordReal-timedataDemandforecastingmentionedStaffingenuitysaved thedayGIS linked tometers/accountsAIDocumentationmade adifferenceCustomerportal inuseInheritedlegacysystemsScriptscompensatefor systemgapsDatacleaningtookforeverDifferentstaff gavedifferentanswersInteroperabilitySinglesourceof truthWe haveAMI… butdon’t useit yetDatagaps inhistoryDashboardspull frommultiplesystemsIncrementalprogressbeats perfectsystemsHad towritecustomqueriesManualprocessSomeonelaughs attheir ownsystemCWOLreportingdonemanuallyThis isn’tperfect —but itworksAMI + CISfinallyintegratedDatasupportswaterbudgetsAPIlimitationsVendorlimitsdiscoveredlateDefensibledataRepeatableworkflowsItdependsSiloedsystemsDatatriggerscustomermessagingWe paidto accessour owndataRFPchangedafter lessonslearned

Great Data Dig - Call List

(Print) Use this randomly generated list as your call list when playing the game. There is no need to say the BINGO column name. Place some kind of mark (like an X, a checkmark, a dot, tally mark, etc) on each cell as you announce it, to keep track. You can also cut out each item, place them in a bag and pull words from the bag.


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
  1. Targeted conservation
  2. Data didn’t align historically
  3. We didn’t know where that data lived
  4. We’re working on that
  5. Learned this the hard way
  6. Spreadsheet is the system of record
  7. Real-time data
  8. Demand forecasting mentioned
  9. Staff ingenuity saved the day
  10. GIS linked to meters/accounts
  11. AI
  12. Documentation made a difference
  13. Customer portal in use
  14. Inherited legacy systems
  15. Scripts compensate for system gaps
  16. Data cleaning took forever
  17. Different staff gave different answers
  18. Interoperability
  19. Single source of truth
  20. We have AMI… but don’t use it yet
  21. Data gaps in history
  22. Dashboards pull from multiple systems
  23. Incremental progress beats perfect systems
  24. Had to write custom queries
  25. Manual process
  26. Someone laughs at their own system
  27. CWOL reporting done manually
  28. This isn’t perfect — but it works
  29. AMI + CIS finally integrated
  30. Data supports water budgets
  31. API limitations
  32. Vendor limits discovered late
  33. Defensible data
  34. Repeatable workflows
  35. It depends
  36. Siloed systems
  37. Data triggers customer messaging
  38. We paid to access our own data
  39. RFP changed after lessons learned