Mobility and energy systems generate a wealth of data. These rich datasets provide infinite opportunities to learn, leverage and build solutions. Enhancing mobility experiences or improving energy systems for society hinges on the ability to interact with this unique data. …

Written by: Zhuolan Cheng, Yiting Jiang, Erin (Li-Hsin) Lin, Tianniu Lyu, Hajra Shahab, Emma Yeager — Carnegie Mellon University Heinz College Capstone Project Introduction: A Case for Sustainable Transportation An often-cited definition of sustainability refers to it as the capacity to “meet the needs of the present without compromising the ability of future generations to meet their own needs.”[1] The sustainability of a system may be evaluated by how well it meets needs belonging to three subcategories: people, planet…

Project Overview Each year in Columbus, there are 29,654 traffic crashes that result in an average of 594 serious injuries and another 101 deaths (Ohio State Highway Patrol, 2016–2021). A fair portion of these accidents are caused by driving under the influence, speeding, and driving while distracted — all completely…

Written by: Tommy Tran Introduction Hi, I’m Tommy, and I had the pleasure of returning to 99P Labs for a second internship. In this term, I was tasked with performing data engineering to explore the 99P Labs IE Telematics Dataset and provide enrichments to improve the user experience by interacting with…

Custom Analytics Course Offering for 99P Labs Associates Authored by: Nick Woo Objective The 99P labs team approached AlignAI (an analytics solutions firm) with a few goals - 1) Make it less difficult for 99P Labs Associates to access & work with strategic datasets to 99P Labs (mobility/telematics) on their…

Authored by: Rajeev Chhajer I had the opportunity to represent Honda in a panel discussion at the recently concluded SAE WCX 2022 conference in Detroit. This was my first in-person conference since the pandemic and also my first time attending this prestigious automotive conference. …

Written by: Bhavya Sachdeva, Emma Wang, Kunaal Khilnani, Tushar Prakash - Carnegie Mellon University MSPM Capstone Project Introduction: Over the last four months, we had the opportunity to collaborate with 99P Labs for our graduate program’s (Master of Science in Product Management) semester-long capstone project. We were delighted to work…

Written By: Nithin Santhanam Introduction “Backfilling” data is a term that refers to the process of retroactively processing historical data in a data pipeline. It is an important component to any actively growing data pipeline. In these types of pipelines, data is ingested every day and the pipeline is applies ETL…

Author: Ben Davis When we ingest a source of data, it can go though multiple stages of transformation before it is ready to use. Typically, each stage passes data to the next by writing it out to storage and signaling the next stage that new data is available. Recently we…