Tips

• tips.csv

• dict for tips.csv

• source for tips.csv

Mtcars

• mtcars.csv

• dict for mtcars.csv

• source: Base R

Iris

• iris.csv

• dict for iris.csv

• source for iris.csv

Chickwts

• chickwts.csv

• pivoted chickwts dataset.csv

• dict for chickwts.csv

• source: Base R

Sleep

• sleep.csv

• pivoted sleep dataset.csv

• dict for sleep.csv

• source: Base R

Quakes

• quakes.csv

• dict for quakes.csv

• source: Base R

Heart Disease

• heart.csv

• dict for heart.csv

• source for heart.csv

Vaccination

• vaccination.csv

• dict for vaccination.csv

• source: unknown

Dengue

• dengue.csv

• dict for dengue.csv

• source: unknown

PSLE

• psle.csv

• source: unknown

Products and Sales

• Products_2016.csv

• Sales_2016.csv

• source: TI github

College

• college.csv

• dict for college.csv

• source: unknown

HSA

• hsa.csv

• dict for hsa.csv

• source: unknown

Parkinsons

• parkinsons.csv

• dict for parkinsons.csv

• source: UCI

PIMA Diabetes

• pima.csv

• dict-for-pima.csv

• source: kaggle

Penguins

• penguins.csv

• dict for penguins.csv

• source: github

SGX Portfolio

• SGX portfolio.csv

• dict for SGX portfolio.csv

• source: simulated

AirQuality

• airquality.csv

• dict for airquality.csv

• source: Base R

AirQuality PM 25

• airqualitypm25.csv

• source: openaq

Airquality No.2

• airqualityno2.csv

• dict for airqualityno2.csv

Health by Gender and Education

• Health_by_ Gender.csv

• Health_by_Education.csv

• source: simulated

Number of Long Term Care Facilities

• No of Long Term Care.csv

• dict for LTC.csv

• source: data.gov.sg

Preliminaries

• Split Text.xlsx

Charts

• charts.xlsx

• bar-chart.xlsx

• scatter-plot.xlsx

• sparklines.xlsx

• combination-chart.xlsx

• thermometer-chart.xlsx

• gantt-chart.xlsx

• pareto-chart.xlsx

• waterfall chart.xlsx

• treemap.xlsx

• histogram.xlsx

Data Validation

• data-validation.xlsx

• reject-invalid-dates.xlsx

• budget-limit.xlsx

• prevent-duplicate-entries.xlsx

• product-codes.xlsx

• dependent-drop-down-list.xlsx

Power Query Datasets

Power Pivot Datasets

• m01.xlsx

• project - new.xlsx

• project-alpha.xlsx

• project-beta.xlsx

• project-something.xlsx

• project-something-else.xlsx

• Students & Courses.xlsx

• dailycensus_7665.xlsx

• drug_administrations.txt

• Patient Experience Survey Template.pdf

• patient_satisfaction_results.csv

• dailycensus_2259.xlsx

• power pivot 1.xls

• Cookie Types.xls

• Cookie Customers.xls

• Cookie Orders.xls

• loan_data.xls

• sales_team.xls

• sales_goals.xls

• products_pp.csv

• orders_pp.csv

• customers_pp.csv

Excel Dashboard

1st Project (Revenue Dashboard)

• Revenue Dashboard Raw Data.csv

• Revenue Dashboard.xlsx (complete dashboard)

2nd Project (Olympic Medals)

• Olympic Medals.xlsx (raw data)

• Olympic Medals Complete Dashboard.xlsx

3rd Project (Hotel Quarterly Expenses)

• PP.xlsx (raw data)

• Hotel Quarterly Expenses Dashboard.xlsx

4th Project (Republicans vs Democrats)

• Republicans vs Democrats.xlsx (raw data)

• Republicans vs Democrats.xlsx (complete dashboard)

  Excel Dashboard Template

• https://exceldashboardtemplate.com/

• Excel Dashboard Template.xls

• Sample_Card_Layout_For_Excel_Crew.xlsx

• Foraging_Guide.xlsx

• Futuristic_Dashboard.xlsx

• Color_Guide.xlsx

• Light_Blue_Theme_for_Newsletter.xlsx

• sample_dash_filters_pc.xlsx

• Newsletter_Sample_Template.xlsx

• Geo Dash.xlsx

• GeoVisual.xlsx

• Ecommerce Dash.xlsx

Others

• Geographical Heatmap of Singapore.xls

• Sunburst Chart Showing Work Activities.xls

Excel Solver / Linear Programming

• KAZO Linear Programming.xls

• AHP for KAZO.xls

• AHP for Investment Selection for Joey's Client.xls

• AHP for Perdaus.xls

• LP for Perdaus.xls

Main Lessons

Superstore

• Sample - Superstore (USA).xls

• global_superstore_2016.xls

Dengue Cluster Story

• World_Bank_CO2.xls

• surface-air-temperature-monthly-mean.csv

• dengue-clusters-kml.kml

• dengue-outbreak-statistics.csv

Product Sales Story

• Sales 2016.xls

• Products 2016.csv

Wrangling

• GlobalVehicleSales.xls

• acrossthebay10k.xls

• Weather.xls

• ProductsCustomersOrders.xls

• 12 Rows of Customer Sales.xls

• Beverages Products and Customers.xls

• Beverages Transactions.xls

• US Tree Nut Production.xls

• Orders.xlsx

• Targets.json

Bar Chart Race

GDP

• https://data.worldbank.org/indicator/NY.GDP.MKTP.CD

• historical_gdp.xls

COVID

• https://www.ecdc.europa.eu/en/publications-data/download-todays-data-geographic-distribution-covid-19-cases-worldwide

• COVID DEATHS 2020.xls

DIVORCE

• https://beta.data.gov.sg/datasets/d_f512c6cce898595684c55c7ef6aeeccb/view

• Singapore-Divorce-Cases(2022).csv

Maps

London Borough

• London_Borough_Excluding_MHW.shx

• London_Borough_Excluding_MHW.shp (html)

• London_Borough_Excluding_MHW.shp

• London_Borough_Excluding_MHW.sbx

• London_Borough_Excluding_MHW.sbn

• London_Borough_Excluding_MHW.prj

• London_Borough_Excluding_MHW.NAME.atx

• London_Borough_Excluding_MHW.dbf

• London_Borough_Excluding_MHW.GSS_CODE.atx

No. of Females in Singapore

• https://dataportal.asia/dataset/192521611_singapore-residents-by-planning-area-age-group-and-sex-june-2016-female

• PLAN_BDY_AGE_FEMALE_2016.dbf

• PLAN_BDY_AGE_FEMALE_2016.prj

• PLAN_BDY_AGE_FEMALE_2016.sbn

• PLAN_BDY_AGE_FEMALE_2016.sbx

• PLAN_BDY_AGE_FEMALE_2016.shp

• PLAN_BDY_AGE_FEMALE_2016.shp (XML)

• PLAN_BDY_AGE_FEMALE_2016.shx

Eldercare

• ELDERCARE.dbf

• ELDERCARE.prj

• ELDERCARE.sbn

• ELDERCARE.sbx

• ELDERCARE.shp

• ELDERCARE.shp

• ELDERCARE.shx

Hail Storm

• Hail Storm Damage.xls

• Manhattan NY City Taxi Pickups

Projects

Insurance Story

• insurance.xls

• https://www.kaggle.com/simranjain17/insurance

• Ameen’s Capstone Project.twbx

Doing Business in Singapore Story

• https://www.kaggle.com/datasets/fkosmowski/cdp-ease-of-doing-business

• https://public.tableau.com/app/profile/vincenttzc

• Doing Business in Singapore.twbx

• WB_DoingBusiness_2018-20.xls

Australia’s Bushfires

• https://www.abs.gov.au/statistics/standards/australian-statistical-geography-standard-asgs-edition-3/jul2021-jun2026/access-and-downloads/digital-boundary-files

• https://en.wikipedia.org/wiki/2019-20_Australian_bushfire_season

Singapore Crime

• https://public.tableau.com/app/profile/elias8766/viz/ApictureofcrimeinSingapore/Map-rank

• Singapore Crime Statistics - Neighborhood Police Centre (2010 to 2014)

Singapore Death Statistics

• https://public.tableau.com/app/profile/dr.alvin.ang/viz/SingaporeDeathsStatistics2006-2021/

• Top 10 Causes of Death in Singapore (2006 - 2021).xlsx

Singapore’s Master Plan Zones

• Planning Area (2017).zip

• Subzones (2017).zip

Population of Singapore Towns (2024)

• Population of Singapore Towns.xls

HDB Resale Price

• HDB Resale Price (2017 to 2022).csv