Transcript Slide 1
Ken Brown Director of Information Systems Whitworth University 1 Copyright © Whitworth University 7/18/2015 Copyright © Whitworth University 7/18/2015 2 Christian Liberal Arts University 2300 Full Time Day Students 600 Graduate and Continuing Studies Students Main Residential Campus in Spokane, WA Downtown U-District Campus Costa Rica Campus Colleague with Informer reporting MS SQL Server based Data Warehouse Copyright © Whitworth University 7/18/2015 3 Evolution of Whitworth University’s Reporting and Analytics Architecture and Strategy ◦ Datatel (Unidata multi-value database) started with QueryBuilder and custom report applications, programs and web tools ◦ Locally developed MSSQL Server based Data Warehouse (instead of ODS), Data Marts and Cubes, MS Reporting Services, Excel and PowerPivot, MS SharePoint report team sites ◦ Informer for Unidata based reporting (replacing QB) ◦ Tableau Software for data visualization/dashboards Copyright © Whitworth University 7/18/2015 4 Aggregation and disaggregation of wide range of university data for operational support and long-term strategic planning Ever increasing need for new reports New operational Dashboards and tools needed for IR, IA, Admissions, Student Life, Facilities Services, Finance, Accounting, etc. New Strategic Dashboards needed for Board, Leadership, and in support of the university Strategic Plan and process improvement initiatives Copyright © Whitworth University 7/18/2015 5 Need to maintain a historical view of certain operational data not maintained by live operational systems Need to provide aggregated and disaggregated views of data Need to bring data from multiple sources into a common standard data structure and ensure data integrity rules are enforced and invalid data is cleaned and corrected Need to correlate data from multiple disparate systems into a common discoverable and reportable structure Copyright © Whitworth University 7/18/2015 6 Provide broad, easily digested view of key operational and strategic measurements Provide timely operational and analytical view into key processes (e.g. Admissions, Advancement) Provide ability to discover/uncover trends, patterns, problems, opportunities hidden in the data to allow for strategic, tactical and daily operational changes to plans, tasks and activities Provide ability to aggregate and disaggregate data, drill down into details, track operational data against targets and goals and provide multiple comparative representations and views of key data Copyright © Whitworth University 7/18/2015 7 Multiple Database Connection Support ◦ Handles lots of flavors of SQL, Excel, Access out of the box and extensible with ODBC ◦ Allows joining of disparate database tables ◦ Connections can remain live and/or data can be imported for offline use Easy Drag and Drop visualization (viz) creation with multiple layout types Can create drill-down navigable vizs allowing traversal from summary to detail data Allows for quick hit statistical views and on-the-fly calculations Quick way to aggregate views and create operational and strategic Dashboards Can package output for use with free Reader, print to PDF/Image files, export to Excel or Upload to Server version for wide-scale distribution Can embed server-based vizs and dashboards into other applications (e.g. web pages, SharePoint) Copyright © Whitworth University 7/18/2015 8 Whitworth 2021 Strategic Plan and KPI Dashboards (via Portal and Tableau Server) Executive/Management Mobile Dashboard Admissions Operational Dashboards Operational Data Exploration ◦ Door Access and Key Card usage tracking ◦ Work Request monitoring ◦ Survey Results Analysis Institutional Advancement ◦ Donor mapping Copyright © Whitworth University 7/18/2015 9 Copyright © Whitworth University 7/18/2015 10 Copyright © Whitworth University 7/18/2015 11 Copyright © Whitworth University 7/18/2015 12 Copyright © Whitworth University 7/18/2015 13 Copyright © Whitworth University 7/18/2015 14 Copyright © Whitworth University 7/18/2015 15 Copyright © Whitworth University 7/18/2015 16 Copyright © Whitworth University 7/18/2015 17 Copyright © Whitworth University 7/18/2015 18 Copyright © Whitworth University 7/18/2015 19 Copyright © Whitworth University 7/18/2015 20 Copyright © Whitworth University 7/18/2015 21 Books ◦ Edward Tufte ◦ Stephen Few Copyright © Whitworth University 7/18/2015 22 Ken Brown ◦ Director, Information Systems ◦ [email protected] (509)777-4486 Tableau Software ◦ www.tableausoftware.com Copyright © Whitworth University 7/18/2015 23