iSchool Capstone

Developing Automated Workflows for Microsoft Mixed Reality

Project tags:

business & systems analysis

data science & visualization

database administration & development

To help Microsoft’s Mixed Reality (MR) team manage their Governance, Risk, and Compliance (GRC) processes more effectively in a dynamic, centralized environment, we built a data wrangling pipeline to import Secure Controls Framework data into ServiceNow. We achieved the following key results: 1) data properly structured and imported into relevant ServiceNow target tables, 2) imported data automatically updated with regulatory changes, and 3) a ServiceNow dashboard to visualize and track compliance and control information. Through automated data management and transparent analytics, our work helps the MR team assess organizations’ regulatory compliance in a more efficient and cost-saving manner.

Project participants:

Anh Huynh

MSIM

Shubha Tripathi

MSIM

Amruta Jadhav

MSIM

Santosh Roy

MSIM