- Advocate for the quality and integrity of College data;
- Provide relevant information and analytics to campus leaders for planning and decision making;
- Consult with campus departments to improve data collection, storage and analysis;
- Support the College in its assessment of initiatives, programs, departments and grants; and
- Curate current and historical College data for official reporting and communications to internal and external audiences.
About IR, Analytics, and Consulting
Excellence: We deliver superior quality in the work that we do.
Collaboration: We leverage the power of working together to produce better results.
Learning: We seek continuous professional growth and learning, and we advance understanding of data and analytics.
Integrity: We conduct our work ethically, honestly and professionally.
Confidentiality: We protect the privacy of Bowdoin students, faculty, staff and alumni and ensure the security of the data we collect and maintain.
Adaptability: We accept and embrace new challenges in order to improve our work and respond to a dynamic, evolving environment.
The engine behind much of the strategic analysis of the College is a dimensionally modeled data warehouse, fondly named the Data Hub. The Data Hub is built on dimensional data models, which are designed to align with how the data is used by the business, not how it is stored in the database. The model captures a business process (e.g., students declare a major). Thus, those who know the business process naturally understand the data model and can create their own reports. Dimensional modeling also allows for tracking history. Most operational systems will only report on what currently is, and not store changes, which may be important for longitudinal analysis (e.g., students change their major). Furthermore, in the Data Hub queries could be run across several dimensional models, we would be able to tie together the results of multiple business processes.
IRAC uses Tableau to create reports and dashboards sourced from the Data Hub. Tableau Server is used to disseminate interactive reports to senior leaders.
For questions related to data warehousing, please contact Peter Wiley.
Location: 216 Maine Street
Address: 5900 College Station, Bowdoin College, Brunswick, Maine 04011-8450