BUS220 - Business Intelligence and Analytics
  • Home
  • Syllabus
  • Lectures
    • Week 1: Spreadsheet Fundamentals
    • Week 2: How We See Data
    • Week 3: From Pivot Tables to Tidy Data
  • Activities
    • Week 4: BI Detective
  • Practices
    • Week 1: Spreadsheet Fundamentals
    • Week 2: Charts, Formatting & Dashboards
    • Week 3: Data Wrangling & First Tableau Charts
  • Assignments
    • Assignment 1
  • Guides
    • Tableau Public Setup

BI Detective: Dashboard Investigation

Week 4 — Interactive Exercise

BI Detective: Dashboard Investigation

BI Detective

Interactive investigation exercise
You are a data analyst at Divvy, a bike-sharing service in Chicago. Your VP just messaged you about alarming numbers. Your job: explore the dashboard, answer questions at each tab, and figure out what the metrics actually mean before the meeting.
Dataset
Divvy Bikeshare — real public ridership data, Chicago
Period
November 2022 – November 2023 (14 months)
Scale
~5.7 million trips, pre-aggregated for this exercise
Rider types
Member — annual pass holders  ·  Casual — single ride or day pass
Work through the tabs left to right. Each tab has a question — correct answers unlock observations on the left panel. Once you have enough evidence, submit your analysis to the VP.
OK
Olena Koval
VP Operations, Divvy Bikeshare
Hey! November numbers look bad. Can you figure out what's going on before our meeting today?
Total Rides (Nov)
Avg Duration (Nov)
Observations
Conclusions for VP
Explore the dashboard and answer questions to build your case
Granularity:

Total Rides

Average Ride Duration (min)

Granularity:

Rides by Rider Type

Casual Share of Total Rides

Avg Duration by Group (Oct → Nov)

Avg Duration Over Time by Group

 

Kyiv School of Economics | BUS220 Business Intelligence and Analytics