Home
  • Portfolio
  • Tableau
  1. Projects
  • Reports
    • BI with SQL & Markdown
    • BI as Code
    • Docs as Code
    • Slides as Code
    • Duckdb & Evidence
    • Duckdb & Google Sheets
    • Judiciary Elections in Mexico
    • Social Security in Mexico
    • National Guard in Mexico
    • The Economist & Data Scientist Role in Public Security
    • Plotting with ggplot2 in Python
    • Understanding Spotify User Behavior
    • Gasoline Prices in Mexico
    • Farmacias Similares Locations
    • Cluster analysis with Python and Polars
  • Slideshows
    • Gasoline Prices in Mexico
    • Water Collection Systems in Mexico
    • Goodbye, Lake Zumpango
    • Why BI tools Fall short
    • Window Functions in SQL
    • Dashboards vs Web reports
  • Dashboards
    • Gasoline Prices in Mexico
    • Farmacias Similares Dashboard
    • Mexico City Crime Dashboard
    • Streamlit Financial Dashboard
    • Percepción de Seguridad en México ENSU 2015-2025
    • Car Sales Dashboard
Categories
All (39)
looker-studio (1)
python (31)
sql (8)
tableau (6)

Projects

An Application of Location Quotients to High-Impact Offenses

Crime Localization in Mexico 2025
python

Traditional crime rate metrics often mask geographic risk disparities by presenting aggregate averages.
In contrast, the LQ provides a robust analytical tool for determining whether a specific geographic area experiences a disproportionate share of a given crime type relative to a larger reference area, thereby highlighting true criminal hotspots.

Dec 8, 2025
Jesus L. Monroy

Mexico City Crime According to the Statistics

Issues and Figures, 2019-2024
python

Crime in Mexico City presents a complex and evolving challenge. The city, a sprawling metropolis, grapples with a range of criminal activities, from petty theft and street-level drug offenses to organized crime and violent acts. Factors contributing to this multifaceted issue include socioeconomic disparities, corruption, and the influence of transnational criminal organizations.

Jun 29, 2025
Jesus LM

Mexico City Crime Incidence 2019-2024

tableau
This dashboard was designed to track crime incidence in Mexico City during 2019-2024 by time, gender, age, mayorship and neighborhood.
Mar 21, 2025
Jesus LM

Stop Building Dashboards

Start Understanding the White Collar Workflow
python
sql

In today’s data-driven world, Business Intelligence (BI) tools promise powerful insights and streamlined reporting. Yet, the humble spreadsheet and slideshow persist in the white-collar world. While BI tools manages complex analysis and visualization, spreadsheets and slideshows offer unique advantages that keep them firmly entrenched in our workflows.

Feb 24, 2025
Jesus LM

Gasoline Prices in Mexico

Fuel Price Fluctuations, A Constant Concern
python

Gasoline prices in Mexico are a complex issue influenced by various factors. In this article we examine the gasoline prices in the 32 States that constitute Mexico and also their differences in cost, sale price and profits. Challenges remain in stabilizing prices and mitigating the impact on consumers and the economy.

Feb 3, 2025
Jesus LM

Implementing a Database System with DuckDB for Local Processing and MotherDuck for Scalable Cloud Storage

An Overview
python
sql

This project explores how to leverage the strengths of DuckDB and MotherDuck to build a robust data processing and storage solution. DuckDB excels at fast in-memory analytics, while MotherDuck provides a scalable and cost-effective cloud data warehouse. By combining these technologies, you can achieve optimal performance for both local and cloud-based data operations.

Jan 13, 2025
Jesus LM

Data Alchemy, SQL Analysis within Python

A Case Study using Duckdb, Polars and Plotly
python
sql

This project focuses on leveraging the strengths of DuckDB, Polars, and Plotly for efficient data analysis and visualization. DuckDB is used for fast in-memory data processing, Polars provides a user-friendly and high-performance DataFrame library, and Plotly offers interactive and customizable visualizations.

Jan 6, 2025
Jesus LM

Geospatial Analysis in Python

A Case Study using Duckdb, Polars and Folium
python

Geospatial analysis involves the application of spatial concepts and techniques to data that has geographic coordinates. With the rise of big data and the increasing availability of geospatial information, the demand for effective geospatial analysis tools has grown significantly. Python, with its rich ecosystem of libraries, has emerged as a powerful and popular choice for geospatial data scientists.

Jan 2, 2025
Jesus LM

Why BI Tools Fall Short, A Failure to Capture the Office Workflow

Slideshows and Spreadsheets Still Rule the Business World
python

Despite BI solutions, spreadsheets & slideshows persist in data-driven decision making.

Dec 5, 2024
Jesus LM

Sports Commerce

tableau
This dashboard was designed to show sales by store and time intervals.
Dec 5, 2024
Jesus LM

Supercharge Your SQL Analysis with Python and DuckDB

Rethinking Data Analysis: A New Paradigm
python
sql

This article explores the synergy between Python and DuckDB, a powerful in-memory database, to revolutionize SQL-based data analysis. By leveraging Python’s extensive data science ecosystem and DuckDB’s lightning-fast query execution, data professionals can significantly accelerate their workflows.

Nov 23, 2024
Jesus LM

Covid Cases in Americas

tableau
This dashboard was designed to track cases and deaths by covid in Americas in 2024 by region and country.
Nov 11, 2024
Jesus LM

Flying into Mexico

A Bird’s-Eye View of Major Airports
python

As a popular tourist destination, Mexico offers visitors a diverse range of experiences, from ancient ruins to pristine beaches. The country’s well-connected airport system ensures seamless travel to these captivating destinations.

Oct 30, 2024
Jesus LM

Spotipy, A Python Library for Spotify Music Lovers

Discover your Music Habits with Python
python

Ever wondered about the intricacies of your listening habits on Spotify? Or perhaps you’re a developer looking to build a music-related application? Enter Spotipy, a fantastic Python library that acts as a bridge between your code and the Spotify Web API.

Oct 30, 2024
Jesus LM

Creating Stunning Charts with Datawrapper and Python

An Overview
python

Datawrapper is a powerful online tool designed to help you create engaging and informative data visualizations. Whether you’re a journalist, researcher, or simply someone who wants to present data in a more visually appealing way, Datawrapper can make the process quick and easy.

Sep 12, 2024
Jesus LM

Mexico City’s Underground

A History of Challenges and Triumphs
python

Mexico City’s metro is the largest and busiest in Latin America, serving more than 5.5 million passengers daily in its 195 stations and 12 lines

Sep 2, 2024
Jesus LM

Mexico’s Peace index 2024

python

The Mexico Peace Index (MPI), created by the Institute for Economics and Peace (IEP), is a valuable tool for understanding peacefulness in Mexico.
According to IEP, Mexico’s peacefulness has improved for 04 years in a row. However, the situation isn’t uniform. While 15 states showed improvement, 17 got worse. Drug cartel activity and political violence remain challenges.

May 17, 2024
Jesus LM

Building Data Pipelines with BigQuery and Python

An Overview
python
sql

In the realm of data analytics, Extract, Transform, Load (ETL) processes play a pivotal role.
They streamline the integration of data from various sources, enabling its cleaning, manipulation, and loading into target systems like BigQuery, Google’s cloud-based data warehouse.
By leveraging Python’s versatility and BigQuery’s scalability, you can construct powerful ETL pipelines to prepare your data for insightful analysis.

May 2, 2024
Jesus LM

National Guard’s Deployed Personnel in Mexico

python

Mexico’s National Guard is a relatively new security force established in 2019. It was created to address the country’s high crime rates and complement traditional law enforcement.

Apr 19, 2024
Jesus LM

Creating Charts with HoloViews

Unveiling Insights with Less Effort by Using HoloViews
python

HoloViews offers a compelling alternative for data visualization in Python. With its emphasis on simplicity, flexibility, and interactivity, HoloViews empowers you to create insightful visualizations that effectively communicate your data’s story.

Apr 19, 2024
Jesus LM

Creating Dashboards with Python

Unleash the Power of Python
python

Python, a versatile programming language, empowers you to create interactive dashboards that unlock the hidden potential of your data.

Apr 12, 2024
Jesus LM

Why You Should Use Mermaid to Create Diagrams as a Data Scientist

Use Python code as your Secret Weapon
python

In this article, we will show how you can create diagrams with code within Jupyter and stop using external diagramming graphical user interfaces (GUIs) like draw.io or Lucidchart.

Mar 29, 2024
Jesus LM

Mexico’s Political Landscape

python

In this article, we will show an overview of Mexico’s Political Scenario and its correlation with Mexico City’s.

Mar 28, 2024
Jesus LM

Creating Slides with Python and Quarto

python
Quarto offers a powerful and versatile tool for data scientists to create presentations with code that are informative, transparent, reproducible, and visually appealing.
Mar 28, 2024
Jesus LM

DuckDB: A Compelling Solution for Data Analysis within Python Environment

A valuable tool for data scientists working with Python due to its speed, ease of use, and tight integration.
python
sql

DuckDB is a fast, embedded analytical database that outstands in in-memory operations. It provides a SQL interface, making it easy for users with database querying experience.

Mar 18, 2024
Jesus LM

Mexico: A Populous Nation with a Dynamic Demographic Landscape

An Overview of Mexico’s Population Dynamics since 1950
python

Mexico boasts a population of nearly 130 million, ranking it as the 10th most populous country globally.
Mexico is a highly urbanized nation, with 88% of the population residing in cities.
This trend is expected to continue, driven by economic opportunities and infrastructure development.

Mar 16, 2024
Jesus LM

Water Collection System in Mexico City - 2022

Rainwater harvesting systems are a prominent water collection method in Mexico
python

Rainwater harvesting is a sustainable and effective way to manage water resources in Mexico. By promoting water conservation and increasing water security, these systems offer a path towards a more water-resilient future.

Mar 16, 2024
Jesus LM

Manipulating JSON Files with Python

An Overview Using Pandas
python

This article presents a straightforward and efficient method for reading JSON files using Python Pandas library. We will show how to import JSON data into DataFrames, enabling comprehensive analysis and exploration. This approach significantly simplifies the process of working with JSON data, making it accessible for data analysis.

Mar 12, 2024
Jesus LM

Exploring Lego Toys with Polars

A quick summary about Lego bricks
python

The Lego brick was invented in 1949 by Ole Kirk Christiansen, and the company has since grown to become one of the world’s leading toy manufacturers. Lego products are sold in over 140 countries, and the company has over 40,000 employees worldwide.

Mar 11, 2024
Jesus LM

Federal Prisons in Mexico

A Geographical Overview of Mexico’s Federal Penal System
python

Mexico’s federal prisons, known as Ceferesos (Centros Federales de Readaptación Social), are a complex system facing challenges. While intended for rehabilitation, reports often highlight overcrowding, violence, and inadequate living conditions.
In this article we will show the location of federal prisons in Mexico, including the famous Islas Marías, which closed in 2019.
We wil use Folium, a powerful Python library to enhance data analysis and geographic visualization.

Mar 6, 2024
Jesus LM

Polynomial Regression

An Extension for Linear Regression Models
python

In this article, we shall show where linear regression falls short and we should use polynomial regression instead.

Mar 2, 2024
Jesus LM

Regression Analysis Overview

A quick summary about linear and nonlinear regression
python

Whether you want to do statistics, machine learning, or economic analysis, it’s likely that you will have to use regression analysis. Regression analysis is one of the most important fields in statistics, economics and machine learning. We shall briefly explore the different techniques about regression.

Feb 28, 2024
Jesus LM

Cohort Analysis

Understanding Customer Behavior
python

Cohort analysis is an extremely helpful tool that can be used to improve business practices and can effectively increase user retention if businesses implement necessary changes according to the test results.
In today’s world where data is everywhere, cohort analysis is effective in extracting useful information by analyzing the behavioral patterns of customers in order to predict the future of the business.
Observing cohorts over time gives insight into user experience and helps in developing better tactics.

Feb 9, 2024
Jesus LM

Unleashing the Power of Big Data with PySpark

An Overview
python
sql

In today’s data-driven world, we’re constantly bombarded with massive amounts of information. Analyzing this data efficiently and effectively is crucial for businesses and researchers alike. That’s where PySpark comes in. It’s a powerful tool that brings the distributed computing capabilities of Apache Spark to the familiar and versatile Python ecosystem.

Jan 12, 2024
Jesus LM

Missing People in Mexico

tableau
This dashboard was designed to track missing people by location, last place seen and place type.
Oct 11, 2023
Jesus LM

US Sales Dashboard

tableau
This dashboard was designed to track sales, profits and customers by categories, months and locations.
Aug 11, 2023
Jesus LM

Looker Studio

looker-studio
We used Looker Studio to present results about customer behavior and online sales and conversions from Google Analytics.
Feb 25, 2023
Jesus LM

Tableau Charts example

tableau
In this section we present some examples of charts created with Tableau.
Feb 11, 2023
Jesus LM

Diving into the World of SQL

sql
In today’s data-driven world, the ability to access, manipulate, and understand information is paramount. At the heart of this capability lies SQL (Structured Query…
Dec 14, 2022
Jesus LM
No matching items
 
  • License

  •   © 2026