Capstone Projects 2020 - 2021

Capstone 1: CO2 Emissions Report in Excel Dashboards

[download excel dashboard]
[Screenshot]

Our cohort's first capstone was an exciting and interesting project since prior to this I was unaware that Excel could do so much more than the usual spreadsheet functionalities that I was used to doing.

In the module, I learned that Excel is capable of Data Preparation, Data Transformation and Dashboards to visualise stories for presentations. I have heard a lot about Big Data, and until this programme my knowledge of the term was minimal. I think that Excel Dashboard was a good introduction to Big Data and how to handle them, which is also an important precursor for our subsequent modules.

For my Capstone, I had initially chosen several topics and datasets that I sourced out from popular websites such as Kaggle and Data.world before eventually deciding to take on the CO2 Emissions by Developed and Developing countries datasets. I used the datasets available at the World Bank's and BP's websites and combined the columns I would need for my report.

Technologies and Applications used: MS Excel 2010, Power Query
Data source: World Bank, BP

---

Capstone 2: Relational Database and MS Excel Dashboard (MS SQL Server)

[Capstone Preview]

For our second Capstone project, we were tasked to use MS SQL Server for the relational database side of the project, and MS Excel for the Data Preparation and Data wrangling portion of the capstone.

Technologies and Applications used: MS Excel 2010, Power Query, MS SQL Server, MS SQL Server Management Studio 18, MS Powerpoint
Data source: Data.world

---

Capstone 3: Singapore Private Housing Transaction Report (PowerBI)

 

Technologies and Applications used: PowerBI Desktop
Data source: Data.gov.sg

Capstone 4: Bank Term Deposit Predictive Model (Python, Jupyter)

[Capstone Preview]

 

Technologies and Applications used: Jupyter Notebook, Anaconda, Numpy Python 3.8, MS Powerpoint
Data source: Data.gov.sg