Skip to Content
Artificial Autonomy Pte. Ltd.
Artificial Autonomy Pte. Ltd.
Home
About
Contact
Privacy Policy
Macro
Multi-Factor-Risk-Model
Risk-Parity
RKECDX-YTD
RKECDX-1Y
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
RKE-Fund-Switch
News
Portfolio Optimization
Derivatives
DOPRG
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Counting-Permutations-Combinations
Model-Binomial
Matrix
ML-XL-000-Excel-Functions
ML-XL-010-Model(Algo(Data))-Regression-Linear
ML_XL_011_Model(Algo(Data))_Regression_Linear_Beta
Non-Linear Regression
Neural Network
Graph Neural Networks (GNN)
SVM = Support Vector Machines
Reinforcement Learning (RL)
Architecture-2017-Transformer
Fine-Tuning
Deployment
RAG = Retrieval Augmented Generation
Multi-Agent Systems
Checklist
02-Data-Extract-Transform-Load
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ynum-use-t-1s-dep0
ynum-x1num-x2num-use-anova
XL-Data-Load-by-Folder-File-Merge
XL-Data-Load-by-File
XL-Data-Quality
XL-Data-Source-Update
XL-Data-Transform-Delete-Columns
XL-Data-Pivot
XL-Data-Transform-Delete-Rows
XL-Data-Pivot-Chart
XL-Data-Legend
XL-Data-Pivot-Chart-Bar-Vertical-Stacked
XL-Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
XL-Data-Box
XL-Data-Histogram
XL-Data-yNum-Bin
XL-Data-Chart-Export
Data-Modality-Multi
Data-Text
Data-Text-Docs
Data-Text-Image
Data-Text-Image-Video
Data-Text-Audio-Voice
Transport-Air-Planes-SIA
Transport-Land-Cars-Used
Transport-Sea-Containers
Transport-Sea-Containers-Ports-Vessels-Latency
Transport-Sea-Ships-Fuel-CO2
Goods-Consumer-Moving-Fast
Goods-Consumer-Moving-Fast-Snacks-TW
Google Cloud
iOS-AA-HelloWorld
www-app-chat-convex
www-app-vercel-v0
www-app-replit
www-app-lovable
www-app-base44
python-streamlit
python-pandas
python-files
python-functions
R
R-class
R-vector
R-function
R-sapply
R-dataframe
AI-Anthropic-Claude
AI-Objective
AI-Risk
AI-Governance
Code-Excel-VBA
Code-Python
HR-Payroll-CPF
Edu-Rent-a-Study-Buddy
Game-Chess
Game-Chess-Jelly
Game-Chess-Belly
GCE-A-H1-8865-Mathematics
GCE-A-H2-9570-Economics
GCE-A-H2-9628-China-Studies-In-English
GCE-A-H2-9173-Geography
Products
(0)
Cart (0)
Artificial Autonomy Pte. Ltd.
Artificial Autonomy Pte. Ltd.
Home
About
Contact
Privacy Policy
Macro
Multi-Factor-Risk-Model
Risk-Parity
RKECDX-YTD
RKECDX-1Y
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
RKE-Fund-Switch
News
Portfolio Optimization
Derivatives
DOPRG
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Counting-Permutations-Combinations
Model-Binomial
Matrix
ML-XL-000-Excel-Functions
ML-XL-010-Model(Algo(Data))-Regression-Linear
ML_XL_011_Model(Algo(Data))_Regression_Linear_Beta
Non-Linear Regression
Neural Network
Graph Neural Networks (GNN)
SVM = Support Vector Machines
Reinforcement Learning (RL)
Architecture-2017-Transformer
Fine-Tuning
Deployment
RAG = Retrieval Augmented Generation
Multi-Agent Systems
Checklist
02-Data-Extract-Transform-Load
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ynum-use-t-1s-dep0
ynum-x1num-x2num-use-anova
XL-Data-Load-by-Folder-File-Merge
XL-Data-Load-by-File
XL-Data-Quality
XL-Data-Source-Update
XL-Data-Transform-Delete-Columns
XL-Data-Pivot
XL-Data-Transform-Delete-Rows
XL-Data-Pivot-Chart
XL-Data-Legend
XL-Data-Pivot-Chart-Bar-Vertical-Stacked
XL-Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
XL-Data-Box
XL-Data-Histogram
XL-Data-yNum-Bin
XL-Data-Chart-Export
Data-Modality-Multi
Data-Text
Data-Text-Docs
Data-Text-Image
Data-Text-Image-Video
Data-Text-Audio-Voice
Transport-Air-Planes-SIA
Transport-Land-Cars-Used
Transport-Sea-Containers
Transport-Sea-Containers-Ports-Vessels-Latency
Transport-Sea-Ships-Fuel-CO2
Goods-Consumer-Moving-Fast
Goods-Consumer-Moving-Fast-Snacks-TW
Google Cloud
iOS-AA-HelloWorld
www-app-chat-convex
www-app-vercel-v0
www-app-replit
www-app-lovable
www-app-base44
python-streamlit
python-pandas
python-files
python-functions
R
R-class
R-vector
R-function
R-sapply
R-dataframe
AI-Anthropic-Claude
AI-Objective
AI-Risk
AI-Governance
Code-Excel-VBA
Code-Python
HR-Payroll-CPF
Edu-Rent-a-Study-Buddy
Game-Chess
Game-Chess-Jelly
Game-Chess-Belly
GCE-A-H1-8865-Mathematics
GCE-A-H2-9570-Economics
GCE-A-H2-9628-China-Studies-In-English
GCE-A-H2-9173-Geography
Products
(0)
Cart (0)
Folder: Info
Back
Home
About
Contact
Privacy Policy
Folder: Mkt
Back
Macro
Multi-Factor-Risk-Model
Risk-Parity
RKECDX-YTD
RKECDX-1Y
R_r_US_Govt_FedFundsRate
C_US_USD_CME-COMEX_Fut_GC
RKE-Fund-Switch
News
Folder: Quant
Back
Portfolio Optimization
Derivatives
DOPRG
Folder: Risk
Back
Market Risk
Liquidity Risk
Credit Risk
Technology Risk
Folder: Math
Back
Counting-Permutations-Combinations
Model-Binomial
Matrix
Folder: Machine
Back
ML-XL-000-Excel-Functions
ML-XL-010-Model(Algo(Data))-Regression-Linear
ML_XL_011_Model(Algo(Data))_Regression_Linear_Beta
Non-Linear Regression
Neural Network
Graph Neural Networks (GNN)
SVM = Support Vector Machines
Reinforcement Learning (RL)
Architecture-2017-Transformer
Fine-Tuning
Deployment
RAG = Retrieval Augmented Generation
Multi-Agent Systems
Folder: Analytics
Back
Checklist
02-Data-Extract-Transform-Load
ynum-xnum-use-regr-lin
Regression-Linear-Simple-yNum-xNum
Regression-Linear-Multiple-yNum-x1Num-x2Num-x3Num
ynum-use-t-1s-dep0
ynum-x1num-x2num-use-anova
Folder: Engineering
Back
XL-Data-Load-by-Folder-File-Merge
XL-Data-Load-by-File
XL-Data-Quality
XL-Data-Source-Update
XL-Data-Transform-Delete-Columns
XL-Data-Pivot
XL-Data-Transform-Delete-Rows
XL-Data-Pivot-Chart
XL-Data-Legend
XL-Data-Pivot-Chart-Bar-Vertical-Stacked
XL-Data-Pivot-Chart-Bar-Vertical-Stacked-Normalized
XL-Data-Box
XL-Data-Histogram
XL-Data-yNum-Bin
XL-Data-Chart-Export
Folder: Data
Back
Data-Modality-Multi
Data-Text
Data-Text-Docs
Data-Text-Image
Data-Text-Image-Video
Data-Text-Audio-Voice
Folder: Indus
Back
Transport-Air-Planes-SIA
Transport-Land-Cars-Used
Transport-Sea-Containers
Transport-Sea-Containers-Ports-Vessels-Latency
Transport-Sea-Ships-Fuel-CO2
Goods-Consumer-Moving-Fast
Goods-Consumer-Moving-Fast-Snacks-TW
Folder: Infra
Back
Google Cloud
Folder: Dev
Back
iOS-AA-HelloWorld
www-app-chat-convex
www-app-vercel-v0
www-app-replit
www-app-lovable
www-app-base44
python-streamlit
python-pandas
python-files
python-functions
R
R-class
R-vector
R-function
R-sapply
R-dataframe
AI-Anthropic-Claude
Folder: Ethics
Back
AI-Objective
AI-Risk
AI-Governance
Folder: Audit
Back
Code-Excel-VBA
Code-Python
Folder: Admin
Back
HR-Payroll-CPF
Folder: Edu
Back
Edu-Rent-a-Study-Buddy
Game-Chess
Game-Chess-Jelly
Game-Chess-Belly
GCE-A-H1-8865-Mathematics
GCE-A-H2-9570-Economics
GCE-A-H2-9628-China-Studies-In-English
GCE-A-H2-9173-Geography
Products
Data_Analytics_PIL_04_Data_Explore_DescStats_ChartLine_ByMonth_Normalized.png
Products › Data_Analytics_PIL_04_Data_Explore_DescStats_ChartLine_ByMonth_Normalized.xlsm

Data_Analytics_PIL_04_Data_Explore_DescStats_ChartLine_ByMonth_Normalized.xlsm

SGD 0.04

https://www.youtube.com/watch?v=ead8i9CI0Hk

In this video, I walk through the PIL dataset, focusing on the raw data and descriptive statistics by month. I created pivot tables and charts to visualize average units, unit dwells, and average dwells, highlighting their differences over the months. I also discussed normalizing the data to better compare trends and correlations, particularly between February and March. I encourage you to review the charts and consider how we can further analyze the data by filtering for different variables like countries and container types. Please let me know your thoughts on this approach and any additional insights you might have!

00:00 Introduction to Data Set

01:55 Chart Type Adjustment

06:34 Average Units Analysis

08:26 Chart Visualization Strategy

11:28 Seasonality Analysis

17:40 Correlation Insights

https://www.youtube.com/watch?v=ead8i9CI0Hk

In this video, I walk through the PIL dataset, focusing on the raw data and descriptive statistics by month. I created pivot tables and charts to visualize average units, unit dwells, and average dwells, highlighting their differences over the months. I also discussed normalizing the data to better compare trends and correlations, particularly between February and March. I encourage you to review the charts and consider how we can further analyze the data by filtering for different variables like countries and container types. Please let me know your thoughts on this approach and any additional insights you might have!

00:00 Introduction to Data Set

01:55 Chart Type Adjustment

06:34 Average Units Analysis

08:26 Chart Visualization Strategy

11:28 Seasonality Analysis

17:40 Correlation Insights

Data Analytics, Quantitative Research, Technology

Artificial Autonomy Pte. Ltd.
UEN 201512111K


Contact

Artificial Autonomy Pte. Ltd. | UEN 201512111K
work@artificial-autonomy.com
+65 9172 4555