Create Vehicle Insights from Vehicle Database API with dbt, DuckDB, and Power BI (Part 3/3)

3 January, 2025

I create reports and dashboards from Vehicle Database summary tables by exploring the data visualization tool using Microsoft Power BI. The end goal in this blog is to simulate the overall end-to-end data analytics pipelines and show the end-user data products using the common BI tool (Power BI).

Create Vehicle Insights from Vehicle Database API with dbt, DuckDB, and Power BI (Part 2/3)

1 December, 2024

I create a data modelling with dbt (Data Build Tool) from the raw vehicle market value data by implementing the Medallion architecture, which consists of three separate layers: 'Bronze', 'Silver', and 'Gold'. The end goal is to produce a couple of dimension and fact tables which will be sit in the Silver layer. Finally, on top of the Silver layer, there will be summary tables which sit in the Gold layer, that eventually will be used for creating dashboards with Power BI.

Create Vehicle Insights from Vehicle Database API with dbt, DuckDB, and Power BI (Part 1/3)

19 November, 2024

I found an interesting website that provides various vehicle informations in a form of APIs. One API that caught my attention is the Vehicle Market Value API. Having said that, I make an experiment to pull the data as well is to demonstrate on how to use dbt, and then visualize using Power BI that we store at the local database using DuckDB. The data that I use is data scraping from the Vehicle Databases API using Python and insert the retrieved data into my DuckDB database.

Car Detection with React and TensorFlow.js

17 November, 2024

I'm experimenting using React web, Tensorflow.js, and the COCO-SSD object detection model to detect cars using from the device's camera. The car detection component processes a video stream from the device, detects cars in real-time, and draws bounding boxes around them.

Surface Shoe Care Landing Page Project

8 November, 2024

This landing page is created to support Surface Shoe Care, a shoe-cleaning service started by a friend of mine from college in Indonesia. The goal is to provide a professional online presence for Surface Shoe Care, showcasing their services, prices, and contact information to potential customers. Additionally, Google Analytics is integrated to track visitor traffic, allowing the client to monitor site performance and understand user behavior.

Sentiment Analysis on Jakarta's Tourism Spots from Twitter and Google Maps

25 July, 2021

I teamed up with my fellow BI analyst to create a couple of sentiment analysis dashboard about tourism spots in Jabodetabek, Indonesia. With scraping the sources from Twitter and Google Maps, using the keywords related to tourist spots. This project is initiated by Atourin, a tourism startup that works on promoting Indonesia's tourism spots by using UGC as their contents.

Franchise Distribution Dashboard using Tableau

14 May, 2020

I created a franchise distribution dashboard in hope of buying the right franchise business and open it around my neighborhood! By combining data from Google Places API, Waralaba.com, and Tableau, this dashboard provides valuable insights into franchise distribution patterns, helping users identify ideal locations or evaluate competition density.

Place Related to Automotive Needs in Tableau

3 June, 2019

I created a dashboard that showcasing the automotive related location dashboard in hopes to help my petrolhead frieds on maintaining their expensive vehicles by adding more location references to them. The dashboard leverages data gathered from the Google Places API and is an ideal tool for anyone interested in exploring and analyzing automotive-related locations based on specific car brands.

Creating a CV/ resume using Tableau

30 May, 2019

Creating a CV with Tableau is a great way to showcase skills, experience, and data visualization expertise. Unlike traditional resumes, a Tableau-based CV allows for dynamic and engaging storytelling.