Gem Logic AI

🔬 Bike Sharing Diagnostics

SQL Anomaly Detection Time Series Daily + Hourly

Overview

Public dataset from Capital Bikeshare, Washington D.C. (2011–2012): 731 daily and 17,379 hourly records of registered vs. casual riders.

Data Structure

LevelRecordsFeatures
Daily731Total/registered/casual riders, weather, temperature, humidity, holiday
Hourly17,379Same features at hourly granularity: rush-hour patterns visible

Causal Reasoning Model

The diagnostic engine performs cross-level drill-down: starting from a daily anomaly, it zooms into hourly rush-hour patterns to pinpoint when during the day demand was unusually low or high.

Key factors in the causal model:

Sample Questions

Try It

Ask Gem Logic: Why was bike demand low on 2012-10-29?

Start Session →