UW Data Map (aligns business and data perspectives)

1. DAC’ing and SMAT’ing UW Data:A Primer on the intersection of data governance and data security at University of WashingtonAnja Canfield-BuddeSenior Manager, Decision Support Services

2. UW Data Map(aligns business and data perspectives)

3. UW Data Map(defines data custodians and trustees)

4. Roles and Access Matrix(defines roles and access privileges)

5. RolesMatrix Thousandsof users Onedata security model. Period. DAC SecuredViews SMAT Hundredsof tables DAC consumes from Roles tool, SMAT & EDW to create secured views Custodians use Roles Matrix to assign people to roles EDW Custodians use SMATto map data to roles Security Metadata Administration Tool Data Access Control System v1.0Patent Pending Dynamically serve only the data allowed Stores data from subject areas across the University Enterprise DataWarehouse User C Row restrictions User A No restrictions User B Column restrictions

6. Security Metadata Administration Tool(SMAT) Lets Data Custodians manage access to EDW data in accordance with Roles and Access Matrix

7. Data Security results in rapid growth for BI 2008-2009 Data access control governance and system enabled consistent, scalable, and broad access to all EDW data 2010New online presence and user forums increase awareness and data usage 2011-2013 New analytics and visualization tools provide easier access to data and promote understanding of activities and trends

8. Tools for Custodians and Users Financial Resources (blue) Human Resources (purple) Academics (yellow) Research (red)

9. Tools for Custodians and Users Multiple Ways to search data - by Name, Subject, Support Group, Table & Database

10. Learn More UW Data Governance: http://www.washington.edu/uwit/im/dmc/ UW Data Warehouse and BI: http://decisionsupport.washington.edu Contact me directly: Anja Canfield-Budde acbud@uw.edu 206-221-6998

11. Appendix

12. UW Data Warehouse Holdings