Diving Into the Deep End How We Built
Diving Into the Deep End: How We Built a Digital Education Dashboard Using Cloud Technology and Agile Methodology Roland Hall and Katerina Stepanova Computing and Information Services April 28, 2020
Facts About Brown ► Founded in 1764 ► Located in Providence, RI ► 6, 834 undergraduate students ► 80+ undergraduate concentrations ► 2, 540 graduate students ► 51 doctoral programs | 33 master’s degree programs ► 597 medical school students ► 1, 293 full-time faculty ► 6: 1 student to faculty ratio
Institutional Data Services at Brown
Background ► What is digital education at Brown? ► Previous projects ► Phase 1 of the MVP began mid-June 2019; ended December 2019 ► New cross-functional team (“who ARE these people? ”) ► New CDO/CIO to the team: “Move quickly!” ► New project management approach ► New architecture ► New technologies
Project Team and Tools Infrastructure and Research Computing Integration and Identity Services Business Intelligence ER/Studio Academic Technology
Data Pipeline Architecture On-premises
Talend/Big. Query Challenges ► In Talend, metadata is useful to store reusable connections and import tables’ schema ► Connection to Big. Query is not available in Talend's metadata
Talend/Big. Query Challenges
Conceptual Models
Logical Data Model
Tableau Data Sources
Tableau Dashboards
What We Learned After Before Analyze Model Build Verify Rework
What’s Next? live events
Questions?
- Slides: 15