VizIT Workflow

Owing a lot of thanks to MOOC, I took on the challenge as a full-time MOOC Data Engineer/Analyst at the Centre for Teaching, Learning and Technology at UBC. My manager, Ido Roll, embarked on the new venture and started the project.

UBC has been hosting dozens of courses on edX, with more than 150,000 registered students. We built and maintained the data pipeline that on a daily base, transformed data in its various formats, e.g. SQL dump, JSON, XML, CSV to structured data and stored them in Google BigQuery. I generated customized data reports and performed data analysis for research purpose. A major part of my work is to streamline and automate the dashboard reporting process. Our final product is VizIT, an interactive dashboard that seeks to offer an intuitive understanding of students’ learning and provide success metrics and actionable information for the course. VizIT is quite a pioneer in this area.

Feel free to check out my Github repository for some of my work.

VizIT Prototype

VizIT Pipeline


Author: Katrina Ni

Data enthusiast and life long learner.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s