WORKING FILES
〰️
WORKING FILES 〰️
https://ssgtraqom.qualtrics.com/jfe/form/SV_3K9i7rTJ9OLsauW?Q_CHL=qr
https://www.straitstimes.com/opinion/jobs-will-soon-become-a-national-security-issue
https://content.mycareersfuture.gov.sg/sunrise-vs-sunset-industries-singapore-hiring-2024/
Salary of Fresh Grad SG 2022.pdf
Global Remote Work Opportunities.pdf
https://www.ncss.gov.sg/docs/default-source/ssc/fy2023salaryguidelinesforthesocialservicesector.pdf
https://mustsharenews.com/grab-driver-job-opportunities/
https://www.asiaone.com/lifestyle/singapore-couple-relocates-bali-seeking-better-lifestyle-work
https://mustsharenews.com/jb-apartment-singaporean/
https://www.instagram.com/p/C4UqiUWMByC/
https://www.channelnewsasia.com/commentary/workplace-discrimination-age-jobs-recruitment-3900191
Apache Spark Training
〰️
Apache Spark Training 〰️
Step 1: Local Laptop Cluster Setup
Teach them Local laptops Cluster Setup… then ask them to do it on another laptop and try
Anaconda3-2022.10-Windows-x86_64
https://www.apache.org/dyn/closer.lua/spark/spark-3.3.1/spark-3.3.1-bin-hadoop2.tgz
https://github.com/steveloughran/winutils/archive/refs/heads/master.zip
Environment Variables (windows)
HADOOP_HOME = C:\SPARK\hadoop
JAVA_HOME = C:\Program Files\Java\jdk1.8.0_202
SCALA_HOME = C:\SPARK\scala
SPARK_HOME = C:\SPARK\spark
PYSPARK_PYTHON = C:\Users\user\anaconda3\python.exe
PATH Variables:
%SPARK_HOME%\bin
%HADOOP_HOME%\bin
%SCALA_HOME%\bin
%JAVA_HOME%\bin
Jupyter Environment Variables
PYSPARK_DRIVER_PYTHON = C:\Users\User\anaconda3\Scripts\jupyter.exe
PYSPARK_DRIVER_PYTHON_OPTS = notebook
STep 2: Local Spark Shell
Step 3: Spark cluster in Google Cloud
Step 4: Spark cluster in AWs Databricks
Step 5: Spark on colab
How To Start A Spark Session & Read in CSV frrom Website.ipynb
Step 6: Pyspark DataFrames
Dataframes with PySpark Example 1 by Dr Alvin.ipynb
Dataframes with PySpark Example 2 by Dr Alvin.ipynb
purchases.csv (this dataset has 4 millions rows.. u can’t open in Excel!)
DataFrames with PySpark Example 2 (EXERCISE) by Dr Alvin Ang.ipynb
Step 7: Showcase VAEX
VAEX for Crunching Big Data by Dr Alvin Ang.ipynb
Automated_Traffic_Volume_Counts.csv (this dataset is 3GB!!!)
Others
hierarchical-clustering-with-python-and-scikit-learn-shopping-data.csv
Structured_Streaming_with_PySpark.ipynb
KMEANS_PySpark_by_Dr_Alvin.ipynb
Hierarchical_Clustering_In_Spark_With_Bisecting_K_Means.ipynb
Normalizer,_Scaler,_Bucketizer_and_Binarizer_with_PySpark_by_Dr_Alvin_Ang.ipynb
https://www.linkedin.com/in/nandeshreddy/
Soya Kim - Big Data Healthcare
Spark Commands by Raj Bharat.txt
https://www.youtube.com/watch?v=lisIQ9ohU8g
https://www.datanami.com/2024/03/05/duckdb-walks-to-the-beat-of-its-own-analytics-drum/
Tensorflow Training
〰️
Tensorflow Training 〰️
Deep Learning with Applications Using Python.pdf
the little book of deep learning by Francois.pdf
https://starttechacademy.com/cnn-for-computer-vision-in-python/
Keras Datasets: https://keras.io/api/datasets/
CHEQUE - Digital Recognition by Deep Learning Techniques.pdf
halal food prediction paper using ANN.pdf
https://thehighestofthemountains.com/brainmaps.html
deep learning interview questions.pdf
A Visual Introduction to Deep Learning (sample).pdf
A Visual Introduction to Deep Learning (part 1).pdf
A Visual Introduction to Deep Learning (part 2).pdf
Neural Network Principles by Robert Havey.pdf
https://stanford.edu/~shervine/teaching/cs-229/cheatsheet-deep-learning
https://raw.githubusercontent.com/tertiarycourses/datasets/master/video_game_sales_training.csv
ANN
Dr. Alvin’s IBF Day 3 - ANN Regression.ipynb
Dr. Alvin’s IBF Day 3 - ANN Classification.ipynb
CNN
Understanding CNN with Dr. Alvin.ipynb
Dr. Alvin's IBF Day 4 CNN on MNIST Digits Dataset.ipynb
(Classifying Handwritten Digits with CNN)
Trained Classification Model for Fashion MNIST Dataset.h5
Predicting Images of Clothes using CNN by Dr Alvin Ang.ipynb
Predicting Images of Common Objects using CNN by Dr Alvin Ang.ipynb
https://setosa.io/ev/image-kernels/
RNN
Understanding LSTM Input and Output (RNN) by Dr. Alvin Ang.ipynb
IBF Day 4: Predicting DBS Stock Price using RNN by Dr Alvin Ang.ipynb
Python Training
〰️
Python Training 〰️
Beginner
[List.Tuples.Dictionary.Sets] + [Operators.True.False.And.Not.<.==.>] + [If.Else.While.For.Loops] + [Functions.Def.Lambda]
Python Fundamentals with Dr Alvin.ipynb
https://codebeautify.org/python-formatter-beautifier
NICF Python Fundamental Course for Beginners.ipynb
Basic Python Handwritten Programming Notes.pdf
https://ehmatthes.github.io/pcc_2e/regular_index/
python basics - Practical INtroduction.pdf (short version)
Python Basics Practical Introduction Full Version.pdf
why python index start at 0.pdf
Data_Science_With_Python_Workflow by Business Science.io.pdf
Intermediate
[Comprehension.i.for.i.in.range] + [Mounting.Google.Drive.File.IO] + [Object.Oriented.Programming.Class.Inheritance .Parents] + [SQLite.Databasing] + [Error.Handling.IndexError.IOError.TypeError.ValueError]
Mounting and Creating Files in Google Drive with Colab.ipynb
Updating HR Records using Object Oriented Programming by Dr. Alvin Ang
https://pandas.pydata.org/docs/user_guide/visualization.html#visualization-barplot
https://python-tricks.com/matplotlib-introduction/
https://python-tricks.com/plotting-in-pandas/
https://www.tutorialspoint.com/how-to-change-the-text-color-of-font-in-the-legend-using-matplotlib
https://tonysyu.github.io/raw_content/matplotlib-style-gallery/gallery.html
https://www.digitalocean.com/community/tutorials?q=python&hits_per_page=12
Python PDFS
Introduction to Programming using Python by Daniel Liang
30 Python Libraries to Boost Your Data Science Productivity.pdf
Python Data Science Tips Full Archive by avi chawla. subs tack. com
PANDAS
[Import.Export.CSV.Dataframe.Slicing.Filtering.DropNA] + [Join.Append.Merge.Pivot.Groupby] + [Box.Scatter.Pie.Area.Histogram.Plots] + [Correlation.DateTime.Time.Series.Plots] + [Pipe.Apply]
How to Join Append Concat Two Tables with Python by Dr Alvin Ang.ipynb
Restructuring CSV for Data Science.pdf
Statistics
[Descriptive.Stats] + [Seaborn.Visualization] + [Hypothesis.Testing.ANOVA] + [LR.MR.R2]
Day 4 with Dr Alvin.ipynb (Statistics)
Python Visualization
Data Visualization with Python by Dr Alvin Ang.ipynb
Top 7 Python Libraries for Data Visualization.pdf
Practical Guide to Matplotlib.pdf
Python Specials
DataPrep + MissingNo by Dr Alvin Ang.ipynb
Ways to Display Json Formats Neatly in Python by Dr Alvin Ang.ipynb
How to Create Random Data with Python by Dr Alvin Ang.ipynb
https://github.com/xiaohk/stickyland
https://www.kdnuggets.com/2022/12/top-5-nlp-cheat-sheets-beginners-professional.html
https://docs.python.org/3/library/functions.html
https://docs.python.org/3/library/stdtypes.html
https://docs.python.org/3/index.html
https://docs.python.org/3/library/index.html
https://fortune.com/education/articles/using-python-for-data-science/
Data Cleansing and Wrangling
〰️
Data Cleansing and Wrangling 〰️
Steps in Data Wrangling and Cleansing
Data Cleansing Steps by Data Ranch.pdf
Data Wrangling Steps by Data Ranch.pdf
Converting JSON to CSV from Scikit Learn Datasets by Dr. Alvin Ang.ipynb
How to Do Train Test Splits with Python by Dr Alvin Ang.ipynb
Data Wrangling a Population of Countries’ Dataset
Population of Countries in 2000.csv
Data Wrangling a Population of Countries Dataset by Dr Alvin Ang.ipynb
Data Wrangling & Visualizing Healthcare Datasets
Hospital Admissions
hospital-admissions-by-sector-annual.csv
Data Cleansing a Hospital Admissions Dataset by Dr Alvin Ang.ipynb
Health Expenditure
government-health-expenditure.csv
Data Cleansing a Government Health Expenditure Dataset.ipynb
Long Term Care Facilities
number-of-residential-long-term-care-facilities-sector-breakdown.csv
Data Wrangling a Long Term Care Facilities Dataset by Dr Alvin Ang.ipynb
Data Cleansing a Rock Song Dataset
Data Cleansing a Rock Song Dataset with Python by Dr. Alvin Ang.ipynb
Data Wrangling Air Quality Datasets
Data Wrangling Air Quality Datasets with Python by Dr Alvin Ang.ipynb
Searching and Slicing a Video Games Dataset
Searching and Slicing a Video Games Dataset with Python by Dr Alvin Ang.ipynb
Wrangling Automobile Datasets
Slicing & Dicing a Motorcars Dataset (European + Japanese Cars)
Slicing & Dicing a Motorcars Dataset with Python by Dr Alvin Ang.ipynb
Factors Affecting Price of European and Japanese Cars
Feature Selection on Automobile Dataset with Python by Dr. Alvin Ang.ipynb
Dealing with Missing Data in European Cars Dataset
Data Cleansing a European Automobile Dataset with Python by Dr Alvin Ang.ipynb
Cross Validating a European and Japanese Cars Dataset
Cross Validating a European and Japanese Car Dataset by Dr Alvin Ang.ipynb
Python for Finance
LendinClubLoan(22k rows - very dirty).csv
Lending Club Loan Data Dictionary.xls
https://www.kaggle.com/datasets/wordsforthewise/lending-club
https://drive.google.com/file/d/1VCaoIFxzpYgzCaIerj24EWx-wW87C440/view?usp=drive_link (alvin’s google drive FULL LendingClubLoan Dataset)
Feature Selection on Lending Club Loan Dataset by Dr Alvin Ang.ipynb
Data Cleansing the Lending Club Loan Dataset by Dr Alvin Ang.ipynb
Train Test Splitting the Lending Club Loan Dataset by Dr Alvin Ang.ipynb
Imploring YFinance by Dr Alvin Ang.ipynb
Python for Finance by yves hilpisch.pdf
Hypothesis Testing and ANOVA with Python
Hypothesis Testing and ANOVA with Python by Dr Alvin Ang.ipynb
Machine Learning Training
〰️
Machine Learning Training 〰️
Machine Learning for Everyone.pdf
Machine Learning with Tensorflow.pdf
Practical Java Machine Learning.pdf
Amazon Machine Learning Developer’s Guide.pdf
Supervised Learning by Data Ranch.pdf
What is Unsupervised Learning by Data Ranch.pdf
Generative AI by Data Ranch.pdf
ML guide with Code by Shivam Modi.pdf
ML Life Cycle by Shivam Modi.pdf
Quick Machine Learning in Python.pdf
ML DL AI Cheat sheet by NIKHIL YADAV.pdf
ML Cheatsheet.pdf
Machine Learning Infographics Cheatsheet.pdf
ML Cheat sheet by Business Science.io.pdf
the little book of deep learning
AI for Everyone notes by Andrew Ng
https://thecleverprogrammer.com/2020/11/15/machine-learning-projects/
How to Load the Iris Dataset into Python by Dr. Alvin Ang.ipynb
Various Places to Get Datasets for Machine Learning by Dr Alvin Ang.ipynb
Various Ways of Train Test Splits with Python by Dr Alvin Ang.ipynb
Unsupervised Learning
Clustering
Overview of Clustering Methods.pdf
KMeans_using_Python_by_Dr_Alvin.ipynb
Hierarchical_Clustering_using_Python.ipynb
Clustering Cheatsheet by Business Science.io.pdf
PCA
Supervised Learning
Linear / Multiple / Polynomial Regression
Simple Linear Regression with Statsmodel by Dr Alvin Ang.ipynb
Simple Linear Regression using SKLearn by Dr Alvin Ang.ipynb
Multiple Regression using Scikit Learn with Python by Dr Alvin Ang.ipynb (Advertising.csv)
Multiple Regression using Scikit Learn with Python (Part II) by Dr Alvin Ang.ipynb (AutomobileEDA.csv)
Polynomial Regression with Python by Dr Alvin Ang.ipynb
Regression Analysis by Data Ranch.pdf
Logistics Regression
Logistics Regression by Data Ranch.pdf
Support Vector Machine (SVM)
Understanding SVM using Python by Dr Alvin Ang.ipynb
Simple SVM Applied to Iris Dataset with Python by Dr Alvin Ang.ipynb
Grid, Random and Bayes Search - Hyperparameter Tuning on SVM with Python by Dr Alvin Ang.ipynb
Decision Tree / Random Forest
Decision Tree (Classification) on the Iris Flower Dataset using Python by Dr Alvin Ang.ipynb
Random Forest (Classification) on the Iris Flower Dataset using Python by Dr Alvin Ang.ipynb
Decision Trees by Data Ranch.pdf
Random Forest by Data Ranch.pdf
Metrics, Normalization and Regularizations
Binary Classification & Performance Metrics by Data Ranch.pdf
Regression Metrics for ML Models (R2 and MSE) by Dr Alvin Ang.ipynb
Classification Metrics for ML Models by Dr Alvin Ang.ipynb
Bias / Variance
Understanding Bias vs Variance in Python by Dr. Alvin Ang.ipynb
L1 and L2 Regularization
L1 Lasso and L2 Ridge and Elastic Net Regression using Python by Dr Alvin Ang.ipynb
MinMax and Standard Scaler
Decision Tree (Classification) on the Iris Flower Dataset using Python by Dr Alvin Ang.ipynb
ML for Trading
〰️
ML for Trading 〰️
Machine Learning for Finance (Klaas).pdf
Deep Learning for Finance - Sofien.pdf
Machine Learning for Algorithmic Trading by Stefan Jansen.pdf
Systematic multi‐factor trading strategy based on SGX market.pdf
Steps to Teach ML for Trading.txt
Steps for ML Trading by Dr. Alvin Ang
Activity for Logistics regression for Financial Trading (wo RSI & ADX) by Dr Alvin Ang.ipynb
Logistics regression for Financial Trading (FULL) by Dr Alvin Ang.ipynb
Multiple Regression for Financial Trading by Dr Alvin Ang.ipynb
Decision Tree Classifier for Financial Trading by Dr Alvin Ang.ipynb
Random Forest Classifier (RFC) for Financial Trading by Dr Alvin Ang.ipynb
Simple Neural Network for Financial Trading by Dr. Alvin Ang (using Keras).ipynb
Is there a Correlation in Stock Prices between DBS and UOB by Dr Alvin Ang.ipynb
Facilitator Guide for Machine Learning 101 for Financial Trading.ipynb
Simple Linear Regression for TSLA Stock Price Prediction THE WRONG WAY (Negative Demo).ipynb
Simple Linear Regression for TSLA Stock Price Prediction THE RIGHT WAY by Dr Alvin Ang.ipynb
Performing Basic Multiple Regression to Tesla Stock Price Prediction by Dr. Alvin Ang.ipynb
Applying Logistic Regression on TSLA Stock by Dr. Alvin Ang.ipynb
Learning TA-Lib in Python by Dr. Alvin Ang.ipynb
Learning Pyfolio by Dr Alvin Ang.ipynb
How to Plot Candlestick Chart using Plotly by Dr. Alvin Ang.ipynb
Learning Pandas TA by Dr Alvin Ang.ipynb
CFTE
https://eoddata.com/stocklist/SGX.htm (ticker symbol)
https://algorithmictrading.substack.com/
https://www.priceactionlab.com/Blog/price-action-lab-software/
https://wire.insiderfinance.io/
https://www.gurufocus.com/guru/warren%2Bbuffett/summary
https://www.benzinga.com/apis/
https://www.youtube.com/@Algovibes
https://greyhoundanalytics.com/
https://singaporeanstocksinvestor.blogspot.com/ (AK)
https://www.dymonasia.com/career/
https://www.tower-research.com/
Handbook of Technical Analysis.pdf
Technical Analysis from A to Z.pdf
Technical Analysis Plain and Simple.pdf
Technical Analysis of Stock Trends Explained.pdf
https://eodhd.medium.com/trading-predictions-using-ai-and-python-cdaad4de3447
https://github.com/suparjotamin/stockie
https://medium.com/trading-data-analysis/metatrader5-python-trading-bot-230bd19285e9
R Training
〰️
R Training 〰️
Basic R Course
Topic 1 - Introduction to R Data Types.R
Topic 2 - R Datasets and Data IO by Dr Alvin.R
Topic 3 - R Data Visualization by Dr Alvin.R
Topic 4 - R Programming by Dr. Alvin.R
Topic 5 - R Statistics by Dr. Alvin.R
Tidyverse Package Course
Topic 1 - Tidyverse Data Cleansing.R
Topic 2 - Tidyverse Data Summary.R
Topic 3 - Tidyverse Statistics.R
Topic 4 - Qualitative Data Analysis (Text Mining).R
Topic 5 - GGPlot Data Visualization.R
Files
R Ebooks
Deep Learning Made Easy with R by ND Lewis.pdf
N.D. Lewis - Machine Learning made easy with R-N.D. Lewis (2017).pdf
Data_Science_With_R_Workflow by Business Science.io.pdf
https://matthewrenze.com/workshops/practical-machine-learning-with-r/
Text Mining with R
Text Mining with R by Dr. Alvin Ang.R
Data Wrangling with R
Data Wrangling with Tidyverse by Dr Alvin Ang.R
Data Wrangling with Core R by Dr Alvin Ang.R
Data Visualization with R
Data Visualisation with BASIC R by Dr. Alvin Ang.R
Data Visualisation with GGPLOT R by Dr. Alvin Ang.R
Regression with R
Simple Linear Regression using R by Dr. Alvin Ang.R
Multiple Regression using R by Dr Alvin Ang.R
Statistics with R
Statistics with Tidyverse by Dr Alvin Ang.R
R Sites
https://togaware.com/projects/rattle/index.html
https://universeofdatascience.com/
https://www.r-bloggers.com/2022/06/the-most-overlooked-r-package-that-can-get-you-through-a-data-science-job-interview/
https://online.stat.psu.edu/statprogram/tutorials/statistical-software/r
https://biostat.app.vumc.org/wiki/Main/RS
https://tuos-bio-data-skills.github.io/intro-stats-book/
https://cran.r-project.org/web/packages/available_packages_by_name.html
https://r4ds.had.co.nz/index.html
https://www.tidytextmining.com/
https://posit.co/resources/cheatsheets/
https://yihui.shinyapps.io/formatR/
https://www.kaggle.com/code/rtatman/data-cleaning-challenge-json-txt-and-xls
https://education.rstudio.com/learn/
https://www.business-science.io/finance/2020/02/26/r-for-excel-users.html
Tableau Training
〰️
Tableau Training 〰️
Profile Links
https://public.tableau.com/app/profile/dr.alvin.ang
https://public.tableau.com/views/EarthquakesOnTheRise-Full/Earthquakestory
https://public.tableau.com/app/profile/hisan.shafaque/viz/1996-97ChicagoBullsBuckets/BullsBuckets
https://public.tableau.com/app/profile/pawan.sachdeva/viz/HowHappyAreWe_15891520173890/HowHappyAreWe
https://public.tableau.com/app/profile/janapati.balaji
https://public.tableau.com/app/profile/thi.ho
Storytelling
Change Over Time:
https://public.tableau.com/app/profile/andy.kriebel/viz/EPLInjuries/InjuryCrisis
Drill Down:
https://public.tableau.com/app/profile/mac.bryla/viz/TellmeaboutWill/TellmeaboutWill
Zoom Out:
https://public.tableau.com/app/profile/peacockworks/viz/VancouverCyclists/VancouverCyclists
Contrast:
https://public.tableau.com/app/profile/robertrouse/viz/Pyramids_1/EgyptianPyramids
Maps
https://public.tableau.com/s/sites/default/files/media/co2_emissions_by_london_borough.zip
https://community.tableau.com/s/question/0D54T00000C6TDLSA3/singapore-map-not-displayed
https://data.gov.sg/search?res_format=SHP
Wrangling
Others
Tableau Introduction by Princeton University.pdf
https://tableaupublic.princeton.edu/#/signin
https://www.thetableaustudentguide.com/
Tableau Official Help
https://www.tableau.com/about/blog/LOD-expressions
https://public.tableau.com/en-us/s/resources
https://tableaupracticetest.com/#get-our-most-popular-downloads
Tableau whitepaper - visual analysis guidebook.pdf
Which Chart is Right for You by Tableau.pdf
3 blind men and an elephant by Tableau.pdf
3 Steps to make your Data Clearer by Tableau.pdf
4 Traits of Data Driven Financial Services Organization by Tableau.pdf
5 Best Practices for Creating Effective Dashboards by Tableau.pdf
5 Steps to Scalable Self-Service Analytics by Tableau.pdf
5 Things Your Spreadsheet Can't Do by Tableau.pdf
5 ways to maximise your salesforce data by Tableau.pdf
7 Best Practices for Mobile Business Intelligence A Whitepaper by Tableau.pdf
7 Tips for Success with Big Data in 2013 by Tableau.pdf
8 ways Universities are Making Impact with Data by Tableau.pdf
10 Essential Dashboards Every Retailer Should Use.pdf
Advanced Analytics with Tableau.pdf
Best Practices for Tableau Online.pdf
Big Data Trends Insights and Strategies from Tableau.pdf
Building Effective Dashboards by Tableau.pdf
Define Analytics by Tableau.pdf
Developing a Governed Self Serive BI Strategy by Tableau.pdf
Embedded Analytics by Tableau.pdf
Evaluations Guide How to Choose the Right MOdern BI platform by Tableau.pdf
Good Enough to Great by Tableau.pdf
how Wayfair and Pepsi use Visual Analysis to Dirve Business Results by Tableau.pdf
Making Flow Happen by Tableau.pdf
Modern Manufacturing 4 ways data is transforming by Tableau.pdf
Must Dos of Marketing Dashboards by Tableau.pdf
Redefining the Role of IT in a Modern BI World.pdf
Sales Force Attitudes towards Forecasting by Tableau.pdf
Sales Performance Report by Tableau.pdf
Solving the Internet of Things Last Mile Problem by Tableau.pdf
The Evolution of Data Storytelling by Tableau.pdf
The Marketing Analytics Evolution by Tableau.pdf
Top 5 Retail Trends for 2018 by Tableau.pdf
Top 7 Business Intelligence Trends for Government in 2017.pdf
Understanding LOD by Tableau.pdf
Visual Analysis for Everyone by Tableau.pdf
Which Chart or Graph is right for you by Tableau.pdf
Why Visual Analytics Matters by Tableau.pdf
https://www.tableau.com/products/public/download
Tableau Prep
Superstore
Bar Chart Race
GDP
https://data.worldbank.org/indicator/NY.GDP.MKTP.CD
COVID
DIVORCE
https://beta.data.gov.sg/datasets/d_f512c6cce898595684c55c7ef6aeeccb/view
Singapore-Divorce-Cases(2022).csv
Dengue Cluster Story
surface-air-temperature-monthly-mean.csv
dengue-outbreak-statistics.csv
Product Sales Story
Insurance Story
https://www.kaggle.com/simranjain17/insurance
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
Australia’s Bushfires
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
HDB Resale Price
HDB Resale Price (2017 to 2022).csv
Tan Kah Ming Predict HDB Price.pdf
Hail Storm
Tableau Official Cert Practice Exams
Tableau Certified Data Analyst Exam Guide.pdf
Tableau Desktop Specialist Exam Guide.pdf
Tableau Certification Question and Answers.pdf
No. of Females in Singapore
SQL Training
〰️
SQL Training 〰️
https://www.cloudways.com/en/pricing.php
https://www.dbta.com/Columns/SQL-Server-Drill-Down/
https://blog.devops.dev/sql-analysis-of-netflix-dataset-808e870e5bd6
https://github.com/pawelsalawa/sqlitestudio/releases
For those with problems installing….
https://alpha.sqliteviewer.app/
https://www.draxlr.com/tools/sql-formatter/
Oracle SQL
https://www.oracle.com/database/technologies/xe-downloads.html
〰️
Power BI Training
〰️ Power BI Training
Resource Management Optimisation Training
〰️
Resource Management Optimisation Training 〰️
Statistics Training
〰️
Statistics Training 〰️
Stats with Excel (Course Activity)
Course Activity for Stats with Excel.xls
Business Analytics by James Evans.pdf
Statistics Quick Reference Guide.pdf
https://stats.mom.gov.sg/SL/Pages/Labour-Force-Introduction.aspx
https://probability4datascience.com/index.html
https://careerfoundry.com/en/blog/data-analytics/standard-error-vs-standard-deviation/
https://thesire.sg/average-penis-size-in-singapore-sg/
https://kirschsubstack.com/p/singapores-ministry-of-health-is
https://probability4datascience.com/index.html
https://www.alvinang.sg/s/BUS-105-Study-Guide-2013-SPSS.pdf
https://www.alvinang.sg/s/BUS105_Study-Guide-2014-excel.pdf
https://www.alvinang.sg/s/BUS105_StudyGuide-2016-excel.pdf
https://www.alvinang.sg/s/BUS105_StudyGuide-2019.pdf
https://www.alvinang.sg/s/1.pdf (textbook part 1)
https://www.alvinang.sg/s/2.pdf (textbook part 2)
https://www.alvinang.sg/s/3.pdf (textbook part 3)
https://www.statssolver.com/hypothesis-testing.html
https://www.drdawnwright.com/tail-of-the-test-interpreting-excel-data-analysis-t-test-output/
Excel Training
〰️
Excel Training 〰️
Preliminaries
SORT
Filter
number-text-filters.xlsx
Conditional Formatting
Hiding Rows and Columns
Offset / Index
VLookup / Xlookup
Data Validation
Charts
IF / AND / OR / Ifs / SUMIF /COUNTIF /AVGIF
Pivot Table
Tables
Fuzzy Lookup
10 Excel functions every Financial Analyst should know.pdf
Power Query
Bunch of Files
Scenario Manager, Data tables, Goal Seek & Forecast Sheet
Network Modeling
Data Analytics with Excel Course Activities
Data Analytics with Excel Course
Design of Experiments (DOE)
〰️
Design of Experiments (DOE) 〰️
DOE CHATILLON AND URANIA SIMULATOR.xlsx
https://support.minitab.com/en-us/datasets/doe-data-sets/golf-ball-data/
https://sigmazone.com/catapult-grid/
https://www.itl.nist.gov/div898/handbook/pri/pri.htm
Response Surface Design (old Minitab manual).pdf
Mixture Design (old minitab manual).pdf
Taguchi Design (old minitab manual).pdf
JMP Basic Analysis and Graphing.pdf
JMP Modeling and Multivariate Methods.pdf
Fundamentals of Predictive Analytics with JMP - 1.pdf
Fundamentals of Predictive Analytics with JMP - 2.pdf
Flexsim
〰️
Flexsim 〰️
WEKA
〰️
WEKA 〰️
Google Workspace
〰️
Google Workspace 〰️
Tech with Tim's Facial Recognition Project (on local laptop)
〰️
Tech with Tim's Facial Recognition Project (on local laptop) 〰️
Splunk Tutorial
〰️
Splunk Tutorial 〰️
UCMHP
〰️
UCMHP 〰️
Sample OIP Projects
〰️
Sample OIP Projects 〰️
Intelligent Real-time Medicine Inventory Management Solution
How might we develop an centralized inventory solution that provides real-time intelligence to optimize the demand and supply for medicinal drugs and reduce the wastage and cost inefficiencies for dispensaries?
Award: SGD30,000
Understanding Customer Order Behaviour for More Efficient Supply Chain
How can we better understand our customers’ orders to fulfil their requests in a timely manner to
improve the customer experience, while ensuring efficiency in supply chain planning and inventory
management?
Award: SGD 25,000
Tracking Solution for Liquid-based Stock
How can we help our customers track and manage their liquid-based stock on a real-time basis?
Award: SGD 10,000
Dynamic Digital Floor Plans, Time Schedules and Route Optimization for Exhibition Spaces
How might we better plan and execute the movement of exhibits into and out of diverse and dynamic event sites with greater efficiency?
Award: SGD 35,000
Data Analytics To Identify Opportunities For Developing Better Financial And Non-Financial Offerings
How might we better understand our customer’s needs, so we develop financial and nonfinancial offerings (e.g. products, insights, education materials, etc.) that better meets their current and emerging needs to better engage the investors in the customer buying journey?
Award: SGD 50,000
Real-Time Data Visualization and Predictive Analytics
How might we create a platform, drawing on our database of real-time receipts data, to not only visualise shopper past behaviour but also to provide predictive shopper actionable insights that will enable brand owners to timely, effectively reach and engage targeted
shoppers?
Award: SGD 20,000
Elevated Customer Experience Through Integrated Insights From Digital Solutions
How can we elevate our customers’ digital experience in a seamless and personalised manner by providing valuable integrated insights across Carrier’s suite of digital solutions?
Award: SGD 25,000
Collaborative Platform For Mall Tenants To Provide Complementary Services That Delight Mall Goers
How might we create a digital collaboration tool, powered by collective data insights, for shopping mall tenants to collaborate among themselves, so as to provide complementary products and services for the mall-goers?
Award: SGD 30,000
Predictive Recommendation Engine To Match Business Event Attendees With The Right People And The Right Content
How might we create a predictive engine for more accurate match rate for professional event attendees to networks and content during and after the event?
Award: SGD 35,000
Visualization Tool that Provides Data Driven Insights For Better Event Evaluation
How might we create a visualisation tool to process visitors and other related-event data so as to empower event organisers and owners to better evaluate event success and ROIs?
Award: SGD 35,000
Smart Customer Relationship Management System
How might we automate the ordering process to be more efficient and effective, and achieve a better customer experience?
Award: SGD 35,000
Understanding Customer Order Behaviour For Better Customer Experience
How might we gain insights of the customer’s ordering behavior to facilitate an improved order management with better customer experience?
Award: SGD 25,000
A Data Analytic Collaborative Platform for Insurance Ecosystem Partners and Clients
How might we create a shared data platform with our ecosystem of partners and clients that can support innovative health and life insurance services?
Award: SGD 20,000
Understanding Users' Behaviour Through Data Analytics And Transaction Tracking Methods Within Mobile App
How might we provide an integrated mobile platform that can enable, track and manage communications and transactions between app users (home residents) and ResidentServices™ Providers (RSPs) and effectively connecting and engaging them, so that we can turn these data into valuable insights, predictions and decisions?
Award: SGD 20,000
Healthcare Oncology Patient Experience Portal
How might we create a digital platform to empower cancer patients and their families along their treatment and recovery journey with external parties and treatment information, so as to make better and sound decisions and stay connected with key communities?
Award: SGD 25,000
Analytics and Insights to Improve Efficiency of Internal Business & Operational Processes
How might we improve our internal processes to derive relevant insights, particularly through utilising our data, in order to operate more effectively and efficiently?
Award: SGD 20,000
Enhance Maintainability of Pre-Fabrication Facility
How might we intelligently manage and perform preventive maintenance of equipment and machinery in our construction and pre-fabrication facility?
Award: SGD 30,000
Automation Of Data Extraction And Verification For Contact List Building
How might we automate the collection and verification of potential customer contact lists, to increase accuracy and save time for higher value work?
Award: SGD 20,000
Asset Management & Investment Recommendation Solution for Portfolio Managers and Analysts
How might we create solution that provides robust investment models, that takes into account the huge amounts of data that are available for analysis, in order to come up with well-timed actionable investment recommendations that results in market outperformance, after all possible slippage costs are considered?
Award: SGD 20,000
Intelligent Dynamic Scheduling & Placement System to Facilitate Grave Exhumation & Reinterment
How might we create a dynamic yet able to meet time specific needs with automated exhumation scheduling and reinterment placement process of graves?
Award: SGD 35,000
Integrated Procurement Chain System for Optimisation of F&B Ecosystem
How might we provide an integrated procurement chain system that can connect F&B operators’ front-of-house to its suppliers’ warehousing and logistics needs seamlessly, to enable smarter purchasing decisions?
Award: SGD 25,000
Interesting Stuff
〰️
Interesting Stuff 〰️
External Whitepapers
〰️
External Whitepapers 〰️
STRIPE - The_DNA_of_an_Adaptive_Enterprise
STRIPE - Stripe_2023_Insights_Report
LOUSY - EQUINIX architecting_the_digital_infrastructure_for_singapore
Hype Cycle for Artificial Intelligence, 2020, Published 27 July 2020_ Gartner Reprint
oracle netsuite - 7-steps-to-recession-proof-your-business
Scalable Efficient Big Data Pipeline Architecture – Machine Learning for Developers
EDB Guide to Setting Up Your Business In Singapore Tech-Startup_Tech-Guide 2023
Useful Sites
〰️
Useful Sites 〰️
Learning
Whether you're prepping for interviews or just want to level up, these are perfect for you.
1. 𝗔𝗣𝗜 𝗙𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀: https://lnkd.in/e8eMet_k
2. 𝗔𝗣𝗜 𝗦𝗶𝗺𝗽𝗹𝗶𝗳𝗶𝗲𝗱: https://lnkd.in/er9JiGxw
3. 𝗔𝗣𝗜 𝗠𝗲𝘁𝗵𝗼𝗱𝘀: https://lnkd.in/ey9v7-hU
4. 𝗔𝗣𝗜 𝗧𝗲𝗿𝗺𝗶𝗻𝗼𝗹𝗼𝗴𝗶𝗲𝘀: https://lnkd.in/eRsPMzpd
5. 𝗔𝗣𝗜 𝗔𝘂𝘁𝗵𝗲𝗻𝘁𝗶𝗰𝗮𝘁𝗶𝗼𝗻: https://lnkd.in/eNPfpAdE
6. 𝗔𝗣𝗜 𝗦𝘁𝗮𝘁𝘂𝘀 𝗖𝗼𝗱𝗲𝘀: https://lnkd.in/egXizUrS
7. 𝗥𝗘𝗦𝗧 𝗔𝗣𝗜 𝘃𝘀 𝗚𝗿𝗮𝗽𝗵𝗤𝗟: https://lnkd.in/eZHREdgC
8. 𝗔𝗣𝗜 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: https://lnkd.in/eDASPP5m
9. 𝗔𝗣𝗜 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 𝗶𝗻 𝗗𝗲𝘁𝗮𝗶𝗹: https://lnkd.in/eZwFVrH7
10. 𝗔𝗣𝗜 𝗧𝗲𝘀𝘁𝗶𝗻𝗴: https://lnkd.in/emgmWJqH
11. 𝗔𝗣𝗜 𝘄𝗶𝘁𝗵 𝗣𝘆𝘁𝗵𝗼𝗻: https://lnkd.in/eM23ah2y
12. 𝗔𝗣𝗜 𝗦𝗰𝗮𝗹𝗶𝗻𝗴: https://lnkd.in/e3mZSvmn
13. 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗶𝗻𝗴 𝗥𝗼𝗯𝘂𝘀𝘁 𝗔𝗣𝗜𝘀: https://lnkd.in/eBXzbFyg
14. 𝗔𝗣𝗜𝘀 𝘄𝗶𝘁𝗵 𝗣𝗼𝘀𝘁𝗺𝗮𝗻: https://lnkd.in/ezue3d4B
15. 𝗧𝗲𝘀𝘁𝗶𝗻𝗴 𝗔𝗣𝗜𝘀 𝘄𝗶𝘁𝗵 𝗣𝗼𝘀𝘁𝗺𝗮𝗻: https://lnkd.in/eCPnGTGi
16. 𝗔𝗣𝗜 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆: https://lnkd.in/e79ZYfPa
17. 𝗔𝗣𝗜𝘀 𝗳𝗼𝗿 𝗘𝘃𝗲𝗿𝘆𝗼𝗻𝗲: https://lnkd.in/e4WGDffA
EBooks
https://drive.google.com/drive/folders/1CgN7DE3pNRNh_4BA_zrrMLqWz6KquwuD
https://freecomputerbooks.com/
Practical Guide to Github using Windows.pdf
Ecommerce analytics _ analyze and improve the impact of your digital strategy.pdf
The Executive Guide to Artificial Intelligence.pdf
An Introduction to Stochastic Modeling - Karlin.pdf
Sheldon Ross - Intro to Probability Models.pdf
Sheldon Ross - Answers to Probability Models.pdf
Sheldon Ross - First Course in Probability.pdf
The Ultimate Guide to Writing a Dissertation.pdf
Getting Started with Kanban.pdf
Discrete Event Simulation I - Jerry Banks.pdf
Discrete Event Simulation II - Jerry Banks.pdf
What Are ChatGPT and Its Friends.pdf
How to (Actually) Use ChatGPT to Its Full Potential.pdf
Humans need not apply by Jerry Kaplan.pdf
AI What Everyone needs to know by Jerry Kaplan.pdf
Generative AI by Jerry Kaplan.pdf
Real Life Analysts / Scientists
Others
https://thenewstack.io/why-are-so-many-developers-hating-on-object-oriented-programming/
https://medium.com/machine-words/the-rise-and-fall-of-object-oriented-programming-d67078f970e2
https://iianalytics.com/community/blog/the-age-of-agile-must-end
https://statguyuser.github.io/feature-engg-selection-for-explainable-models.github.io/
https://medium.com/mlearning-ai/this-study-shows-how-ai-can-change-your-job-f55d88256e1
https://waitbutwhy.com/2015/01/artificial-intelligence-revolution-1.html
https://unicsoft.com/blog/building-an-ai-proof-of-concept-benefits-and-steps/
https://cloud.google.com/blog/products/gcp/5-google-cloud-product-cheat-sheets-2021
https://oa.mg/journals/open-access-computer-science-journals
AI for MUSIC
Streamlit Apps
〰️
Streamlit Apps 〰️
DOE
https://fullfactorial1.streamlit.app/
https://fullfactorial2.streamlit.app/
https://fractfactorial1-coffee-brewing.streamlit.app/
https://fractional-factorial-2.streamlit.app/
https://plackettburman-1.streamlit.app/
https://plackettburman-2.streamlit.app/
https://boxbehnken-1.streamlit.app/
https://boxbehnken-2.streamlit.app/
https://simple-cpf-calculator.streamlit.app/
https://timevalueofmoney.streamlit.app/
https://tech-stock-candlestick-chart.streamlit.app/
https://taxi-fare-calculator.streamlit.app/
https://myveryfirst.streamlit.app/
https://lr4techstock.streamlit.app/
https://income-level-checker.streamlit.app/