Featured Analytics Project

Investment Analytics Dashboard

A personal analytics project focused on monitoring markets in real time, understanding macroeconomic conditions, and turning external data into a practical reporting and decision-support dashboard.

Overview

Personal market monitoring dashboard for allocation tracking, macro review, and repeatable decision support.

Problem

Investment decisions benefit from a repeatable workflow instead of scattered notes and one-off market checks.

My Role

Designed the review flow, data presentation, and AI-assisted commentary for the public-safe dashboard.

Tools & Technologies

Google Sheets, Looker Studio, TradingView widgets, Apps Script, public market data, and AI-assisted commentary.

Relevant Roles

Demonstrates dashboard thinking, personal analytics workflow design, data storytelling, and reporting automation.

Limitations / Confidentiality

This is a personal analytics project using public or non-sensitive market context. It is not financial advice and does not expose private financial records.

Workflow / Approach

Google Sheets collects the data, Looker Studio presents the dashboard, and TradingView widgets provide market context for the review flow.

Google Sheets
Looker Studio
API Integration
Analytics
Automation

Market Environment

Monitoring macroeconomic indicators and liquidity-sensitive assets to better understand broader market conditions.

Central Bank Monitor

Monitoring policy rates across major central banks.

AI Market Commentary

AI-assisted interpretation of macroeconomic conditions, liquidity environment, and market positioning.

Business / Analytical Value

Loading summary...

AI Portfolio Allocation

Experimental AI-assisted allocation view based on macroeconomic conditions, liquidity environment, and market positioning. This is a personal analytics demonstration, not investment advice.

Market News

Latest macroeconomic, equity, crypto and Indonesia market developments.

System Architecture

End-to-end automated data pipeline powering market monitoring, AI analysis, and reporting.

API

Market APIs

News API, TradingView

v
ETL

Apps Script

ETL Processing

->
SHEET

Google Sheets

Data Storage

->
AI

AI Analysis

Gemini/OpenAI

v
JSON

JSON API

Apps Script Endpoint

->
SITE

Portfolio Site

HTML + JS

->
BI

Looker Studio

Reporting Layer