| Company | Cyclistic International |
|---|---|
| Description | International company that offer rentals for electric and classic bike |
| Type | Bike Station Dashboard |
| Tool | Tableau |
| Dashboard | https://public.tableau.com/views/CyclisticBikeStationDashboard/BikeStationDashboard?:language=en-US&publish=yes&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link |
| Dataset | https://citibikenyc.com/system-data |
| Certificate | http://tiny.cc/CourseraFoundationBI |
| Field | Description |
|---|---|
| Ride ID | A unique identifier for each individual bike trip in the system, one per ride. |
| Rideable type | The type of vehicle used on the trip, such as a classic bike or an e-bike. |
| Started at | The date and time when the trip began, when the bike was first unlocked. |
| Ended at | The date and time when the trip ended, when the bike was returned or marked as finished. |
| Start station name | The name of the station where the ride started. |
| Start station ID | The unique ID of the station where the ride started. |
| End station name | The name of the station where the ride ended. |
| End station ID | The unique ID of the station where the ride ended. |
| Start latitude | The latitude coordinate of the station where the ride began. |
| Start longitude | The longitude coordinate of the station where the ride began. |
| End latitude | The latitude coordinate of the station where the ride ended. |
| End longitude | The longitude coordinate of the station where the ride ended. |
| Member or casual ride | Indicates whether the trip was taken by a member (subscriber) or a casual (non-subscriber) rider. |
| Chart Name | Total Trip |
|---|---|
| Main Purpose | Show total number of rides during September 2025 |
| Required Fields | [Ride Id], [Started At] |
| Visual Details | Add subtext for “Highest Trip” and “Lowest Trip” using table calculation on daily trips |
| Chart Name | Electric Bike Trip |
|---|---|
| Main Purpose | Show total rides using electric bikes |
| Required Fields | [Ride Id], [Rideable Type], [Started At] |
| Visual Details | Include highest & lowest day labels using daily breakdown |
| Chart Name | Classic Bike Trip |
|---|---|
| Main Purpose | Show total rides using classic bikes |
| Required Fields | [Ride Id], [Rideable Type], [Started At] |
| Visual Details | Include highest & lowest day labels using daily breakdown |
| Chart Name | Bike Type by Percentage |
|---|---|
| Main Purpose | Compare proportion of electric vs classic bikes |
| Required Fields | [Rideable Type] |
| Visual Details | Display as percentage of total |
| Chart Name | Trip Hours by Stations |
|---|---|
| Main Purpose | Show stations with the highest to lowest total trip hours |
| Required Fields | [Start Station Name], [Started At], [Ended At] |
| Visual Details | Sort descending; show station rank and value labels |
