Let's explore sales data for the fictional bike sharing
company, CyclePath.
(Skills used: SQL and Power BI)
Primary Goals
As detailed in the case study email below, this project's objective is to create a visually appealing dashboard to display insights into the company's hourly revenue, profit and revenue trends, seasonal revenue, and customer demographics. The aim is to enable stakeholders to make data-driven decisions by providing clear, actionable insights and identifying key performance indicators.
Case Study
The case study document outlines the requirements of a dashboard for CyclePath, a bike share company. It should focus on key performance metrics such as hourly revenue analysis, profit and revenue trends, seasonal revenue, and rider demographics. The project requires the use of company colors, an easy-to-navigate design, and access to or creation of the necessary databases. Additionally, a recommendation for pricing strategies for the next year are requested as well.
Data Formatting and Analysis
In this stage, a SQL query was utilized to combine two separate tables into a single, comprehensive table using the UNION operator. We then joined this new table with a different table that contained pricing data which we then used to calculate and create new columns that presented both revenue and profit. This process ensured that all relevant data was organized and prepared for subsequent analysis and visualization.
Dashboard
During this stage, a comprehensive dashboard was created to visualize the data. It includes a matrix for the hourly revenue analysis, a line and clustered column chart for profit and revenue trends, a bar chart detailing the seasonal revenue, and a donut chart presenting the rider demographics. A slicer was also incorporated to allow users to filter the data by year, providing a dynamic and interactive user experience.
Takeaways
Based on my analysis, I calculated the price elasticity was to be approximately 2.2, indicating that demand actually increased as prices rose. This counterintuitive result suggests that CyclePath is a rapidly growing company, and its customer base isn’t responding negatively to past price increases. Therefore, I would recommend that the company should continue to raise prices to capitalize on this growth trend.