data with derek

My blog with my personal projects and discoveries in data analytics.

Forecasting with Prophet in R - Part I

R
Learn With Me
Forecasting
In this post, we learn how to forecast using Prophet by following the code in the documentation. Prophet is a procedure implemented in R or Python for forecasting time…
Feb 27, 2026
Derek Rodriguez

Geospatial Analysis of Metro Manila Cafes - Part 1

R
Geospatial Analysis
Metro Manila
This is a continuation to my previous post on the topic. Since we have a good amount of data on our hands, I wanted to run some initial exploratory analysis using a…
Jan 12, 2026
Derek Rodriguez

Creating a database of Cafes in Manila using Google Maps

Python
APIs
Google Maps
Metro Manila
In this post, I start building a database of cafes in Metro Manila (Philippines) primarily using Python and Google’s Places API. The intent is to use such a database for…
Dec 10, 2025
Derek Rodriguez

Visualizing Tariff Rates Using Power BI

PowerBI
Tariff
Visualization
In this post, I use Power BI to visualize the import duties or tariffs for a group of products into different countries using data from the World Trade Organization (WTO).
May 22, 2025
Derek Rodriguez

Tracking Commander Deck Builds in PowerBI - Part I

Python
PowerBI
Web Scraping
MTG
I start building a PowerBI report, or a tracker, to monitor changes to user-submitted decks in EDHREC to see if there are any changes to how players build their decks, if…
Apr 29, 2025
Derek Rodriguez

Identifying Crime Hotspots in LA

R
Geospatial Analysis
USA
Los Angeles
In this post, I look at reported crimes in LA (2020-2023) to see which areas have high and low incidence– which might be one way to gauge the level of safety in those areas.…
Dec 15, 2024
Derek Rodriguez

Starting Linear Programming in Python

Python
Optimization
Linear Programming
Learn With Me
In this post, I will solve a simple linear programming (LP) problem using three Python packages: Google’s ORTools, PuLP and SciPy.
Nov 28, 2024
Derek Rodriguez

Diagonal Reference Lines in Power BI

PowerBI
Visualization
Business Analytics
In this post, I present a way to create (certain) dynamic diagonal reference lines in PowerBI. The tool has built in ways to create horizonal and vertical reference lines…
Nov 22, 2024
Derek Rodriguez

Analysing Card Choices with Frequent Pattern Mining

Python
Pattern Mining
Market Basket Analysis
Web Scraping
MTG
In this post, I use frequent pattern mining or association rule mining, which is typically used for market basket analysis, in order to analyze card choices in more than a…
Nov 19, 2024
Derek Rodriguez

Discovering Impact of COVID-19 on Thai Tourism Economy

R
Geospatial Analysis
Thailand
This is my second project (take home exercise) for our course Geospatial Analysis. This exercise makes use of techniques in geospatial analysis to discover clustering and…
Nov 13, 2024
Derek Rodriguez

Geographically Weighted Modeling of Financial Inclusion in Tanzania

R
Geospatial Analysis
Tanzania
This was my final project for the course Geospatial Analysis. Here I looked at the information from FinscopeTanzania 2023 to model measures of financial inclusion both…
Nov 13, 2024
Derek Rodriguez
No matching items