2026 Lunar New Year Data Analysis
Ciro D
Like this project
Posted Jan 27, 2026
Mapped and visualized Lunar New Year celebrations and Zodiac cycles using data analytics.
Likes
0
Views
0
Lunar New Year Data Analysis: A Tribute to the Year of the Fire Horse
From PostgreSQL to Power BI: mapping the global pulse of Lunar New Year celebrations.
Introduction
The Lunar New Year isn’t just a date; it’s a global rhythm. In 2026, we enter the Year of the Fire Horse, a rare and powerful zodiac cycle known for bold energy and transformation.
This project is a tribute to that moment. Using a full-stack data pipeline, I mapped the global footprint of Lunar New Year celebrations and visualized the Chinese Zodiac cycle from 2016 to 2026. It’s a blend of cultural storytelling and technical precision; a way to honor tradition through data.
Tech Stack
Database: PostgreSQL (pgAdmin 4)
Language: Python 3.x (psycopg2)
Visualization: Power BI Desktop
Data Source: Curated cultural and geographic data
Database Architecture
The backend is built on two relational tables:
city_festivities: Global cities with latitude/longitude and a Magnitude score (1–5) for festivity intensity
zodiac_calendar: Zodiac animals, elements, and lucky colors from 2016 to 2026
This structure allows for both geospatial mapping and cultural filtering.
Python Integration
A custom script connects securely to the database and automates reporting:
Retrieves ranked city data for celebration intensity
Pulls zodiac metadata for the selected year (2026)
Verifies data integrity before visualization
Key Insights
1. Year of the Fire Horse (2026)
Element: Fire
Lucky Colors: Red, Blue, White
These colors shaped the dashboard’s visual theme: bold, energetic, and auspicious.
2. Global Celebration Hubs
Magnitude 5 Cities: Beijing, Hong Kong, Shanghai, Taipei
Magnitude 4 Cities: Bangkok, Kuala Lumpur, San Francisco
Magnitude 3 Cities: London, Sydney
Magnitude 2 City: Buenos Aires (a sign of growing cultural presence in South America)
3.️ Diaspora Density
The map reveals how Lunar New Year transcends borders, with high-intensity celebrations in both East Asia and Western cities.
Reflections
This project is more than a dashboard; it’s a cultural mirror. The Fire Horse is a symbol of bold change, and this analysis captures that spirit.
By blending relational databases, Python automation, and Power BI storytelling, I wanted to show how tradition can be honored through technology.
Whether you’re in Taipei or Buenos Aires, Lunar New Year is a reminder that celebration is both local and global, and that data can help us see the connections.