2
play

2 12.07.2017 University of Massachusetts Amherst Boston - PowerPoint PPT Presentation

Nov 23, 2023 •229 likes •451 views

University of Massachusetts University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Amherst Boston Dartmouth Lowell Worcester UMassOnline Welcome! 2 12.07.2017 University of Massachusetts

  1. University of Massachusetts University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Amherst Boston Dartmouth Lowell Worcester UMassOnline Welcome! 2 12.07.2017

  2. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Today’s Agenda Topic Presenter Length Start End Welcome and Agenda Shahr Panahi :10 9:30 9:40 Introduction/Keynote John Letchford :25 9:40 10:05 Summit Status and Roadmap Shahr Panahi :40 10:05 10:45 A&F Dashboard Discussion Lisa Calise :30 10:45 11:15 Break :15 11:15 11:30 BPR Update BPR Leads :25 11:30 11:55 Tableau for Summit Bill Manteiga :15 11:55 12:10 HelioCampus Introduction Lori Dembowitz :20 12:10 12:30 Lunch (Provided Downstairs) 1:00 12:30 1:30 Breakout Sessions :HR Carol Dugard, HR Attendees 1:30 1:30 3:00 Middlesex :Finance John Munroe, Finance Attendees 1:30 1:30 3:00 Essex Berkshire :Student Jeff Glatstein, Student Attendees 1:30 1:30 3:00 Report back from Breakouts All :30 3:00 3:30 Closing Remarks/Evaluation forms Shahr Panahi :10 3:30 3:40

  3. University of Massachusetts University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Amherst Boston Dartmouth Lowell Worcester UMassOnline SUMMIT Summit Roadmap DECEMBER 2017 By Anju Sherpa - Own work, CC BY-SA 3.0, https://commons.wikimedia.org/w/index.php?curid=33073777

  4. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Topics – What is Summit? – Where are we today: • Architecture • Usage – Where are we going • UMass Community of Data Practitioners • Future Architecture (Draft) • Roadmap

  5. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline What is Summit? - UMass’ Business Intelligence (BI) and Analytics program. - The main objective of Summit is to facilitate and promote data-centric decision making by: • Deploying solutions that transform raw data into actionable information; • Providing access to that information to decision makers; • Championing data governance across the university; • Supporting BI / Analytics community’s data, information, and technology needs. – UMass Enterprise Data Architecture • Enterprise Data Warehouse • Enterprise Reporting and Analysis tools (OBIEE, Tableau, etc.) • Data Integration for Analysis – Tools that transform and move data • Data Access for all analysts • Future technologies such as “data lake”, access brokers, Analytics marts

  6. University of Massachusetts University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Amherst Boston Dartmouth Lowell Worcester UMassOnline SUMMIT: Today’s Architecture External Tableau Access Layer: OBIEE Tableau Tableau Data Tableau Tableau Tableau Server Tableau Servers Campus Campus IR Census Marts Mart Marts Metadata Layer Integration 3rd Party Summit Data Marts EDW PS – SA PS – SA PS – SA Buyways, PS HCM PS Fin Sunapsis, AMHERST MEDICAL BDL Equifax, IDM, Other Sources

  7. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Where are we: Summit Usage and Statistics - Increasing amount of data being queried (800 M rows per quarter) - 17 Data Marts, 40 ++ dashboards - Thousands of unique users per month

  8. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline How do we as a university system maximize potential of data analytics in the most efficient and productive way? – People, Organization, Processes • Position UMass resources on campus and centrally for maximum efficiency and productivity • Invest in analysts on campus to answer business questions using data • Centralize where it can lead to efficiencies – Technology and Architecture • Modernize UMass enterprise data architecture • Take advantage of new technologies, cloud hosting, best practices in analytics – BI / Analytics Content • Build / buy analytics content to support UMass strategic direction both on campus and as a system • Care for campus as well as system data and analytics needs

  9. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Introducing UMass Community of Data Practitioners UMass Community of Data Practitioners UMASS COMMUNITY OF DATA PRACTITIONERS: UMass Community of Data Practitioners - Collection of BI / Analytics professionals across UMass AMH - Optimize collaboration across campuses and UITS NOW: - Share knowledge; - Collaborate online - Organize events MED BOS FUTURE: - Project and research opportunities for faculty and UMCDP students - Budgeted through grants where possible - Cooperate with higher ed. Institutions across the commonwealth and beyond - Invest in and provide access to new technologies CEN/ LOW around data UITS - Support open source innovation - Involved in data governance and strategy for the enterprise - Kaggle like analytics contests and scholarships on DAR real life UMass business questions

  10. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Future Summit Architecture Guiding Principles • Facilitate ease of access to all available data for mining and analysis • Strive to make transforming data into actionable information ,including advanced analytics simple and repeatable • Accommodate purchased analytics solutions / hosts • Support governance , standardization, and access security • Care for agility and self service in developing BI / Analytics content • Take advantage of latest technology and cloud hosting • Pay special attention to user experience , make mobile available • Ensure proper buy-in and support from UMass BI / Analytics community • Capitalize on the community and engage faculty and student practitioners • Prioritize based on utility and benefit to the entire enterprise (rather than single campus) • Maximize use of existing investments and minimize ‘redoing’ work that has already been done

  11. University of Massachusetts University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Amherst Boston Dartmouth Lowell Worcester UMassOnline Summit: Future BI/Analytics Architecture Future state enables big data, analytics, self service, mobile, and data exploration Entire Stack Hosted on Cloud? Access Layer: Other Web & Access Layer Reporting and Analytics tools Mobile Optimized and integrated for best user experience Applications Access Broker Specific Data Marts Content Vendors Analytics Engine (Collection of Cleansed Data for Specific Marts Layer (e.g. HelioCampus) Artificial Intelligence Subjects) Metadata Data Lake Enterprise Data Warehouse Repository Layer Massive Repository of Raw Data Highly Cleansed Transformed Data In All Formats Data Integration Source Layer Sources: All ERP, Cloud, On Premise, and External Data Sources

  12. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline What is a Data Lake • Able to store vast quantities of data in raw format • It stores data of different types: – Database tables – Log files (i.e. web log information) – Binary files (i.e. pictures, voice, etc.) – Other • It can be Hadoop based, RDBMS based or both • Used for Advanced analytics as well as quick access to data (don’t have to wait for data to get to EDW before using) • Best practice* is to implement alongside enterprise data warehouse * According to TDWI, Gartner, Cloudera

  13. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Architecture Roadmap 2017 2018 2019 2020 2021 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Data Lake / Access / Discovery Tool Vendor Acquisition & Deployment Auto-Discovery Advanced First Predictive SQL Server Advanced Analytics Development Model Analytics POC Helio HelioCampus Deployment (DL) More campus /Central deployments (ABWC) ?? Campus Oracle 12.2 / HW EDW Upgrade Cloud Host OBIEE OBIEE 12c / HW Upgrade Oracle Cloud? Metadata Tableau Expand Central Enterprise Server (PaaS) Integration Server (PaaS?) Milestone Planned Decision Placeholder

  14. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Content Roadmap • Some key upcoming content: – A&F Executive Dashboard – A&F Executive Dashboard: Campus Detail – System IR Data Mart – Deans’ dashboard – HelioCampus Visualizations – Student Success Appliance – Predictive models – …

  15. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Appendix

  16. University of Massachusetts Amherst Boston Dartmouth Lowell Worcester UMassOnline Basics: Optimizing Data Analysis and Delivery Majority of the time and Information effort by analysts is spent on Delivery accessing and preparing data. This reduces time Analysis available for actual analysis! Time and Effort Data Cleansing and Transformation Data Discovery and Acquisition Traditional

Recommend

More recommend