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?