This project analyzes the year-over-year business performance of Toman Bike Shop, focusing on key metrics such as the number of riders, total revenue, total profit, and average price per rider. The analysis is performed using SQL queries to extract, transform, and load (ETL) data from multiple tables. Additionally, a Power BI dashboard is created to visualize the insights derived from the data, providing a comprehensive view of the company's growth dynamics and financial performance.
Common Table Expression (CTE): Combines data from two tables into a single dataset using a UNION ALL operation.
with cte as (
select * from bike_share_yr_0
union all
select * from bike_share_yr_1)
select dteday, season, a.yr, weekday, hr, rider_type, riders, price, COGS,
Calculates revenue as riders * 'price'
Calculates profit as 'revenue-COGS * riders'.
Performs a LEFT JOIN operation to combine the CTE with 'cost_table' on the year ('yr') to incorporate cost information.
