This repository contains the analysis and visualizations conducted as part of the Minnesota Department of Transportation Traffic Volume Analysis Project, which is a component of my Google Business Intelligence Certificate.
In this project, I was tasked with developing a dashboard for the Minnesota Department of Transportation to help monitor traffic patterns and support infrastructure decisions. The department's goals included analyzing traffic volume throughout the year, under different weather conditions, and during holidays.
- Traffic volume data used for analysis.
- A comprehensive summary of the project's findings and insights.
- Screenshot of the Power BI dashboard.
- Leveraging Tableau and Power BI, the dashboard offers interactive visualizations that provide insights into traffic volume data across various time scales, weather conditions, and holidays.
- The development process involved collaboration with stakeholders via email to understand requirements, gather feedback, and iterate on the dashboard design. This ensured alignment with the department's objectives and user needs.
- The dashboard underwent meticulous data processing and customization to ensure accuracy and usability. Custom columns and filters were created to extract relevant metrics, enhancing the dashboard's functionality.
- Key insights and recommendations derived from the dashboard analysis were presented to stakeholders through a PowerPoint presentation. This facilitated informed decision-making by providing actionable insights for infrastructure planning and construction projects.
- Download the repository to your local machine.
- Open the link to explore traffic volume trends and insights.
- Review the accompanying presentation for detailed analysis and recommendations.