iSchool Capstone

Gateway To Data: Portland Pedal Power

Project tags:

business & systems analysis

data science & visualization

database administration & development

Project poster

Portland Pedal Power (PPP), is a delivery and catering delivery service, based out of Portland that differentiates itself from the competition with the usage of bicycles. Business Intelligence is the process of equipping organizations to make better decisions with the usage of data. A data warehouse architecture coupled with reporting capabilities will allow the leadership of PPP to better understand their customers. This project warranted the capstone team to upgrade the existing data infrastructure, define and automate ETL (Extract Transform, Load) processes to combine disparate sources of data and build interactive data visualizations and report to make everyday decisions easier.

Project participants:

Abhinav Joshi

MSIM

Anuj Joshi

MSIM

Pranay Agarwal

MSIM

Shibashish Hota

MSIM