Citi Bike's bike transportation costs are likely significant due to the need to move bikes between stations, which can be costly depending on demand and availability. By analyzing Citi Bike's data using SQL and GIS tools in CARTO, insights have been gained into the efficiency of the system, such as identifying areas where riders can take over more moving tasks while trucks minimize their bike transports. Visualizations have also shown commuter flows, bike usage patterns, and pickup/dropoff times, revealing surprising trends like a major hub generating bike flow in opposite directions. These findings suggest opportunities for optimization, such as placing stations strategically to minimize management effort and exploring solutions for the mysterious cluster around Grand Central Station. By leveraging CARTO's powerful data manipulation and GIS tools, users can turn their own data into insightful visualizations, making it easier to understand complex systems like bike-sharing services.