CityRide
0% complete
Start here · 45 min

Get ready

Create your account, open the project, and learn where things are.

V
Your focusBronze, quality gates & release
Free Edition signupCreate an account
Repository URLhttps://github.com/MoNakouzi/cityride-analytics
WorkspaceOpen Databricks
Source datasamples.nyctaxi.trips
Prepared namespacescityride.dev · cityride.prod
Start here · 5 minute orientation

How to use this field guide

You do not need to memorize Databricks. Use one card at a time, follow its bullets in order, and stop whenever the result does not make sense.

▶

Learn

Read a short idea or watch a simple video. Then explain it in your own words.

1·2

Follow along

Use the steps and code exactly as shown. Stop after each result and look at it.

★

Challenge

Try a small task together. The goal is to think, not to get it perfect on the first try.

Already prepared for you

Your project files are ready

After cloning, verify this structure before starting. Work in the existing files—do not rename, move, or recreate them. The test file is optional until you reach the stretch work.

README.mdProject notes and results
notebooks/00_explore_source.pyPython warm-up and source exploration
notebooks/01_bronze.pyBronze copy
notebooks/02_silver.pySilver cleaning
notebooks/03_gold.pyGold metrics
notebooks/04_quality_checks.pySimple checks
sql/business_queries.sqlDashboard queries
tests/test_transformations.pyOptional tests
docs/data_dictionary.mdRules and metric meanings
docs/release_notes.mdWhat changed
Viri's to-do list

One small win at a time.

0 of 3 done
LearnTogether

What you are building

CityRide turns taxi trips into clean tables, useful numbers, and a dashboard.

  1. Watch the short beginner tour.
  2. Open Databricks in another tab.
  3. Find Workspace, Catalog, SQL Editor, and Jobs & Pipelines.
  4. Come back when those four areas feel familiar.
Video · Databricks IntroFree Edition guide
Viri

Viri: open your accounts

Use your own Databricks and GitHub accounts.

  1. Create a Free Edition account if needed.
  2. Accept the workspace invitation.
  3. Accept the CityRide GitHub invitation.
  4. Open both links once.
Create Free Edition accountCityRide repository
Viri

Viri: make your Git folder

Each person needs a separate copy of the repository.

  1. Open Settings → Linked accounts and connect GitHub.
  2. Open your personal Workspace folder.
  3. Choose Create → Git folder.
  4. Paste https://github.com/MoNakouzi/cityride-analytics.
  5. Check that README.md, notebooks, sql, tests, and docs appear.
Git folders guide
Before you move on

Quick checkpoint

  • Both accounts work
  • Each person has a separate Git folder
  • You can find the four main Databricks areas
🌱

You're doing fine. Finish the tasks above at your own pace. Progress is saved on this device.