Data Analytics Project
Completed as part of a school assignment.
Mark: 60/60
Completed as part of a school assignment.
Mark: 60/60
94 pages of...
1. Scenario and Project Walkthrough - A detailed overview of the project scope, objectives, and context.
2. Data Exploration and Processing - Step-by-step documentation of data handling using Excel, SQL, and Tableau, ensuring complete transparency at every stage. Inclusion of supporting visuals to enhance clarity and understanding.
3. Analytical Tools and Techniques - Application of advanced Excel tools, including a whole excel sheet of What-If Analysis and other relevant functionalities. Comprehensive documentation of the SQL schema and data dictionaries.
4. Analysis and Visualization - Thorough examination of all Excel graphs, visualizations, SQL queries, and their respective outcomes. Detailed presentation of the Tableau dashboard, showcasing insights and actionable findings.
5. Comprehensive Insights - An in-depth analysis highlighting key trends, correlations, and conclusions derived from the data.
6. Summary and Conclusions - A concise Executive Summary outlining the primary insights, recommendations, and implications of the analysis. This structured and comprehensive approach ensures clarity, precision, and a deep understanding of the project's data-driven insights.
Very brief summary of my analysis with supporting visualisations and key findings. Additionally, six recommendations based on my analysis.
The dashboard provides a comprehensive overview of Opal travel data, focusing on trip counts and fares by travel mode and time period. The visualizations are clear and well-organized, making it easy to understand the key trends and insights. Interacting with this dashboard allows you to explore Opal travel trends in detail. By filtering data by travel mode, card type, or time period, you can identify patterns and insights. For example, you might discover that certain travel modes are more popular during peak hours, or that card type preferences vary by region. This information can help inform transportation planning and policy decisions.
View Here: Tableau Dashboard
WHAT-IF-ANALYSIS
OPAL CARD FARES
OPAL TRIP COUNTS
DISTANCE TABLES