Figure 1: data model of the User table and editing rights. PAGEREF _Toc25909490 \h 2
Figure 2: Cartoon drawing of the elements in the Munetrix Navigation System 3
Figure 3: Table relationships of the objects in the Munetrix Navigation System 4
Figure 4: data model for the Peer Groups app. 11
Figure 5: diagram of Collaborations & Project Tracker data model 13
Figure 6: Screen shot showing data tables in the NaviCat MySQL control panel 17
Figure 7: Screen shot of the m_municiplaities table in the NaviCat MySQL control panel 17
Figure 8: screen shot showing field relationships in a data model 18
Figure 9: Screen example of the Assets table in dirty laundry. 19
Figure 10: Screen sample of editing an asset in dirty laundry. 19
Figure 11: data model for Long-term Debt app. 21
Figure 12: Screen shot of CUSIP numbers data. 22
Figure 13: data model for the Capital Improvement app. 23
Figure 14: Cartoon data modelfor the Academic Module. 24
Figure 15: Dirty Laundry v3 turning on features. 25
Figure 16: image of CNA app toggle on. 25
Figure 17: adding local units/permissions to a user 25
Figure 18: adding permissions to a user 25
Figure 19: Data model for CNA surveys. 27
Figure 20: CNA workfow template. 28
Figure 21: IRIPS Data Model 31
Figure 22: Excel tracking sheet for SGX data loading. 32
Figure 23: Dirty laundry chart for SGX data loaded. 32
Figure 24: data model for SGX SLO data. 35
Figure 25: Diagram showing analysis used by Student Count 44
Figure 26: data table for Enrollment Codes. 45
Figure 27: Michigan portal for M-STEP data. 76
Figure 28: Sample of County Census after MS Excel steps complete. 92
Figure 29: Sample Census geocode format 101
Figure 30: printing & exporting from Tableau. 107