End-to-End Data Analysis Assignment: Capstone Project on Dashboard Visualization Using Python, Excel & Power BI

Capstone Assignment

1. 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.

2. Assignment Instructions

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

3. Report Structure:

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

   1. Page 1 – Cover Page
      Include the following:
      1. Full Name
      2. Program Title: Certified Data Science (CDS)
      3. Assignment Title: End-to-End Data Analysis & Visualization Project
      4. Submission Date
   2. Page 2 – 1.0 Dataset Selection
      Choose a dataset from any open data source such as:
      1. Kaggle
      2. UCI Machine Learning Repository
      3. Data.gov.my
      4. Google Dataset Search
   3. The dataset must be in Excel (.xlsx), CSV (.csv), or Google Sheets format.
   4. Justify your dataset choice:
      1. Why did you choose this dataset?
      2. What do you plan to analyze?
   5. Include:
      1. Dataset URL (link to source)
      2. Screenshot of the raw dataset preview
         

         Stuck in This Assignment? Deadlines Are Near?

         Hire Assignment Helper Now!

4. Page 3 – 2.0 Data Cleaning in Excel/SQL

   1. Open the dataset in Microsoft Excel/SQL Workbench and clean it.
   2. Cleaning tasks must include at least:
      1. Removing unnecessary rows/columns
      2. Handling missing values (if any)
      3. Formatting column names
      4. Removing duplicates (if any)
      5. Filtering and sorting (if relevant)
   3. Provide:
      1. Before and after screenshots of your Excel cleaning process
      2. Short explanation of what you did and why

5. Page 4 – 3.0 Data Analysis (Using Python or SQL)

   1. Choose only one of the following tools:
      1. Python (Google Colab or Jupyter Notebook)
      2. MySQL Workbench
   2. Import your cleaned dataset and perform basic analysis, such as:
      1. Summary statistics
      2. Filtering, grouping, or sorting
      3. Identifying trends, averages, counts, or relationships
   3. Provide:
   4. Include:
      1. Dataset URL (link to source)
      2. Screenshot of the raw dataset preview

1. 6. Page 5 – 4.0 Dashboard in Power BI or Tableau

1. Import your cleaned dataset into either:
   1. Power BI
   2. Tableau Public or Desktop
2. Create a dashboard that includes:
   1. Minimum 2 types of charts (e.g., bar chart, line chart, pie chart)
   2. Use filters, slicers, or KPIs if possible
   3. Ensure your visualizations are clearly labelled
3. Provide:
   1. Screenshot of your final dashboard
   2. A summary of the insights you found from the visualization

7. Page 6 – 5.0 Conclusion

1. Summarize your work:
   1. What tools did you use?
   2. What were the steps you followed?
   3. What were your key findings?
   4. What challenges did you face and how did you overcome them?
   5. What did you learn from this assignment?

8. Final Submission Checklist:

1. Make sure your final report includes:
   1. Cover PDF
   2. Dataset Justification, URL, and Screenshot
   3. Excel Cleaning (with screenshots)
   4. Python or SQL Analysis (with screenshots)
   5. Dashboard Screenshot and Insight
   6. Conclusion

9. Submission Deadline:

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

Late submissions will not be accepted unless pre-approved.

Answer

Request Answer of this Assignment