The Ask

The COO needs to know how the launch went and what can be done to improve the business going forward.

Building a business case:

→ Issue Tree Framework

→ Executive Summary

→ Data Analysis

→ Hypothesis & Recommendation

The Approach ↓

Details

Role: Strategy & Business Operations (BizOps)

Timeframe: Capstone Project (3-4 Weeks)

Tools & Skills: SQL, Redash, Google BigQuery, Microsoft Excel, GSuite, Tableau

A → Defining the Problem

Breaking down the problem into specific segments that can be addressed Strategically.

01 - Overview

B → Market Sizing Summary Data Points

A → Diving into SQL Data Structures

Using delivery data from the New York launch to assess its market expansion.

Leveraging data analysis and visualization tools like SQL and Tableau, uncovering key insights and focus areas within our operations

02 - Deep Dive

C → Telling the story through data

B → Sample SQL Queries to Extract Insights from Dataset

*Cohort analysis example query for Project Juniper

A → Recommendation

Two key recommendations are introduced to decrease overall idle time, make drivers more productive, and increase overall revenue.

Reducing idle time for deliveries with both no-code and code based solutions.

03 - End Scope

Key Takeaways

• Use a hypothesis-driven approach to solve an ambiguous problem. When provided with large datasets, it can be tempting to go down a rabbit hole without drawing any meaningful conclusions

• Issue trees created at the inception of the project ensured that the right questions were addressed, subsequently focusing efforts on the most relevant areas

• For operationally-intensive businesses such as Juniper, data collected from daily operations is used to guide every decision - from daily prioritization to cross-functional strategic initiatives