Data Visualization & Analytics: Power BI, DAX, SQL
Business Intelligence: KPI Analysis, Revenue Forecasting, Seasonal Trends
Data Processing: SQL Queries, Data Cleaning, Data Transformation
Project Overview:
This Power BI Dashboard provides insights into bike share revenue, ridership trends, profitability, and rider demographics. It enables data-driven decision-making by visualizing key metrics, peak revenue hours, seasonal demand, and rider behavior.
Key Contributions:
Developed an interactive dashboard: Designed KPIs, revenue heatmaps, seasonal trends, and demographic insights.
Analyzed profitability trends: Identified peak revenue hours and seasonal variations to optimize business strategies.
Segmented customer base: Differentiated between casual and registered riders for targeted marketing.
Results and Impact:
Provided clear insights into revenue trends and business growth between 2021 and 2022.
Helped optimize pricing and marketing strategies by identifying high-revenue time slots.
Demonstrated the effectiveness of data visualization in improving operational decision-making.
Learnings and Takeaways:
Improved proficiency in Power BI dashboard creation, KPI tracking, and DAX functions.
Developed strategies to analyze customer behavior and optimize business operations.
Explored predictive analytics to forecast future revenue and customer trends.