End-To-End Data Analysis Assignment: Capstone Project On Dashboard Visualization

Capstone Assignment

Objective:

This assignment is designed to test your ability to apply data science skills from start to finish. You will select a dataset, clean it using Microsoft Excel, analyse it using Python (Google Colab) or MySQL Workbench, and create an insightful dashboard in Power BI or Tableau. All your work must be compiled into a well-structured report with screenshots and explanations.

Assignment Instructions

Follow the steps below exactly as described. Your report must contain all sections listed.

Report Structure:

Your report must be submitted in PDF format, with the following structure:

Page 1 – Cover Page

Include the following:

• Full Name
• Program Title: Certified Data Science (CDS)
• Assignment Title: End-to-End Data Analysis & Visualization Project
• Submission Date

Page 2 – 1.0 Dataset Selection

Choose a dataset from any open data source such as:

• Kaggle
  
• UCI Machine Learning Repository
• Data.gov.my
• Google Dataset Search
• The dataset must be in Excel (.xlsx), CSV (.csv), or Google Sheets format.
• Justify your dataset choice:
• Why did you choose this dataset?
• What do you plan to analyze?

Include:

• Dataset URL (link to source)
• Screenshot of the raw dataset preview
• Stuck In This Assignment? Deadlines Are Near?

Page 3 – 2.0 Data Cleaning In Excel/SQL

• Open the dataset in Microsoft Excel/SQL Workbench and clean it.
• Cleaning tasks must include at least:
• Removing unnecessary rows/columns
• Handling missing values (if any)
• Formatting column names
• Removing duplicates (if any)
• Filtering and sorting (if relevant)

Page 4 – 3.0 Data Analysis (Using Python Or SQL)

• Choose only one of the following tools:
• Python (Google Colab or Jupyter Notebook)
• MySQL Workbench
• Import your cleaned dataset and perform basic analysis, such as:
• Summary statistics
• Filtering, grouping, or sorting
• Identifying trends, averages, counts, or relationships

Provide:

Include

• Dataset URL (link to source)
• Screenshot of the raw dataset preview

6. Page 5 – 4.0 Dashboard In Power BI Or Tableau

Import your cleaned dataset into either:

• Power BI
• Tableau Public or Desktop
• Create a dashboard that includes:
• Minimum 2 types of charts (e.g., bar chart, line chart, pie chart)
• Use filters, slicers, or KPIs if possible
• Ensure your visualizations are clearly labelled

Provide:

• Screenshot of your final dashboard
• A summary of the insights you found from the visualization

7. Page 6 – 5.0 Conclusion

Summarize your work:

• What tools did you use?
• What were the steps you followed?
• What were your key findings?
• What challenges did you face and how did you overcome them?
• What did you learn from this assignment?

8. Final Submission Checklist:

Make sure your final report includes:

• Cover PDF
• Dataset Justification, URL, and Screenshot
• Excel Cleaning (with screenshots)
• Python or SQL Analysis (with screenshots)
• Dashboard Screenshot and Insight
• Conclusion

9. Submission Deadline:

All reports must be submitted by: 14/06/2025

Late submissions will not be accepted unless pre-approved.

Capstone Assignment – Marking Scheme (100 Marks Total)