Renewable Grid Simulator (Web App for Science and Sustainability) ♻️💚
A real-time simulation of a renewable energy grid, this full-stack web app models the balance between solar, wind, and hydro production against grid consumption. Users adjust input parameters (sunlight hours, wind speed, water flow, and demand) and the system calculates net energy output using physics-based formulas.
I chose to focus on renewable ‘green’ energies (solar, wind, and hydro) because they represent the most accessible and impactful pathways toward a sustainable future.
Perfect for a science class or as an interactive resource to prepare for Earth Day🪴 (April 22), this project blends technical precision with visual storytelling to make sustainability data engaging and intuitive.
13
142
The Library of Babel (Full-Stack Inventory App)
Inspired by Jorge Luis Borges’ vision of infinite knowledge, I built a full-stack inventory management app that simulates a digital library system.
The backend, powered by FastAPI, handles CRUD operations and persistent data storage in a flat JSON file.
The frontend, built with Next.js, TypeScript, and Tailwind CSS offers a parchment-themed interface with real-time counters for unique titles and total volumes.
Key features include:
- Smart stacking: Adding a book with an existing ISBN increases its quantity.
- Gradual vanishing: Titles disappear only when all volumes are removed.
- Global search: Filter by title, author, year, or ISBN.
- Archival UI: Designed to evoke the feel of Borges’ hexagonal galleries.
21
225
It’s summer in the Southern Hemisphere, and families in this area are heading to the beach. One of the most amazing places to visit is Florianópolis, known for its vibrant culture and seaside charm.
To understand what makes the city’s Mercado Público so special, I built an end‑to‑end data pipeline: scraping Google Maps reviews with Python and Selenium, storing them in PostgreSQL, and categorizing them with Pandas. The insights are visualized in an interactive Tableau dashboard. It's also the first time I used another tool: Beekeeper!
This project blends data engineering, sentiment analysis, and business intelligence to highlight how people experience one of Brazil’s most beloved destinations.
You can explore my GitHub repo (https://github.com/ciroduro01/floripa_tourism_analysis) for more information.
Have a nice week! ♥️
2
14
190
For this week’s #contraquest, I want to share the project that means the most to me.
A Data Analysis of the Film Noir Era (1940–1962)
On the surface, it’s a data pipeline: raw Excel, Python ETL, Tableau dashboard... The minor reason it’s special is that I stepped outside my comfort zone and used Tableau instead of my usual Power BI.
But the major reason is personal. This topic, American Film Noir, takes me back to my last year of high school, when I wrote a monograph on the genre’s Golden Age. Revisiting it now, through the lens of data analysis, felt like reconnecting with a piece of my past.
Check it out on my GitHub repo (https://github.com/ciroduro01/Film_Noir_Movies/tree/main), or read the Medium article (https://medium.com/@ciroduro01/shadows-cinema-a-data-analysis-of-the-film-noir-era-1940-1962-b2dd80cde76c).
6
27
443
E-commerce brands often struggle to track true profitability across platforms. So, I built a full-stack solution that integrates TikTok Shop operations with Shopify logistics, automating financial reconciliation and delivering executive-level insights.
This project is designed to be modular, secure, and client-friendly, with a clear path from raw data to strategic insight.
GitHub repo here (https://github.com/ciroduro01/Shopify_Project)
25
521
"And have you any dreams you'd like to sell? Dreams of loneliness." — Stevie Nicks
This line has always resonated with me. It inspired my latest project, where I explore the transition from Descriptive Analytics to Predictive Analytics. Not just as a technical shift, but as a metaphor for how we approach our own aspirations.
In this piece, I dive into the world of parallel dreams: the paths we imagine, the futures we forecast, and the ways data can mirror the uncertainty and beauty of human ambition.
It’s my most personal project to date, because beyond the analytics, it reflects my own dream: to finally find a job where my skills, philosophy, and way of working can thrive.
Read the full article here (https://medium.com/@ciroduro01/the-aspiration-oracle-predictive-life-strategy-513b12e84fd3)
Don't stop dreaming ♥️
13
440
BI Meets Japan: A Dashboard That Tells a Story
Tokyo’s luxury hotels. Kyoto’s quiet ryokans. Osaka’s capsule pods. I built a Business Intelligence dashboard that doesn’t just track bookings, it maps the heart of Japanese tourism.
This project dives into regional income flows using PostgreSQL, DBeaver, and Power BI. The result? A dynamic dashboard where Kanto dominates, Kansai charms, and Hokkaido waits for its moment.
It’s not just data, it’s storytelling through filters, KPIs, and treemaps.
If you love travel, analytics, or Japan’s layered beauty, this one’s for you.
Read the full breakdown here: Japan Travel Agency (BI) (https://medium.com/@ciroduro01/business-intelligence-japan-travel-agency-9c2618cae6d1)
16
497
Last-Mile Logistics in Mexico City
Mexico City is more than a metropolis — it’s a living system of movement, culture, and connection.
This project is my tribute to its complexity: a full-stack logistics model that maps package flow from a central hub to key destinations across CDMX.
This isn’t just about logistics — it’s about designing systems that reflect the pulse of a city I deeply admire.
Read the full breakdown: Logistics in Mexico City (https://medium.com/@ciroduro01/database-modeling-last-mile-logistics-in-mexico-city-1b6d5a428ea6)
To everyone who’s supported my previous posts — thank you. Your feedback, likes, and curiosity keep me building, sharing, and refining. This one’s for you❤️
25
554
Award season meets analytics — and it all comes to a head this Sunday, January 11, when the Golden Globes 2026 ceremony takes place in Los Angeles.
To celebrate, I built a full-stack data project exploring the 2026 Golden Globes movie nominations, starting with a custom CSV dataset featuring:
🎬 Movie, Director, Genre, Nominations
🍅 Tomatometer, 🍿 Popcornmeter, Metascore Approval & User Score
From there, I created:
📊 Python visualizations with Matplotlib & Seaborn
🍩 Power BI Donut Charts showing genre distribution and metascore approval
This project combines technical depth with cultural relevance, showing how data can illuminate trends in film recognition and audience reception.
Read my Article on Medium ➡️ Article (https://medium.com/@ciroduro01/golden-globes-2026-a-data-driven-look-at-the-movie-nominations-8df7a40e84b1)
15
453
Autonomous Web Intelligence & SQL Reporting Pipeline
Automation doesn’t have to be hidden in the background, it can be interactive and accessible.
I built a professional‑grade Selenium automation system for Microsoft Edge that combines speed with a human‑in‑the‑loop workflow. The engine navigates and captures data, while you stay in control of the search before generating a clean, stakeholder‑ready report.
This project shows how automation can be both powerful and approachable, turning complex web tasks into polished business outputs.
25
523
Celebrating Cinema Through Data: Diane Keaton at 80
Some projects go beyond numbers.
To honor the 80th birthday of legendary actress Diane Keaton, I built a Python Notebook on Kaggle featuring a curated selection of 25 of her most iconic films. From Annie Hall to Something’s Gotta Give, the dataset highlights her impact across decades of cinema.
This project is both a technical showcase and a cultural tribute, proof that data analysis can capture not only trends, but also the legacy of an artist.
Read the full article here: Diane Keaton: 80th Birthday Tribute (https://medium.com/@ciroduro01/diane-keaton-80th-birthday-tribute-c2abaffb64d2)
2
28
560
Behind every star rating is a story — and behind every review is an emotion.
In this project, I applied Natural Language Processing (NLP) techniques to analyze thousands of movie reviews, uncovering how audiences truly feel about the films they watch.
This project shows how data can capture not just numbers, but the emotional pulse of cinema.
2
18
456
Movies don’t just tell stories — they leave behind data trails.
In this project, I applied time series techniques to the MovieLens dataset, uncovering how ratings evolve across years and genres, and what those shifts say about audience preferences.
This project shows how data can capture the pulse of cinema — from the rise of certain genres to the subtle decline of others.
3
20
387
Ever wondered what your favorite movies look like through the lens of data?
In this project, I built a complete ETL pipeline to clean and structure the MovieLens dataset, then applied Python + SQL analysis to uncover trends in ratings, genres, and viewer behavior.
Digital Foundations Series: 120+ practical activities designed to take students from basic computer use to mastery. Open-source educational materials for IT/ICT teachers and students.
0
74
Sending Automatic Reports via Email (Automating Notifications with smtplib)
1
22
228
Popular Videogames Analysis: From Flat Data to Relational Insights
0
75
Weather Data Analyzer (REST API Interaction, HTTP Requests, and JSON Processing)
0
61
Visual Analysis of Sales Data (Data Visualization with the Matplotlib Library)
0
67
Inventory System with ORM (Database Abstraction with SQLAlchemy (Object-Relational Mapping))
0
60
Task Management System (CRUD Application with SQLite Database)
0
49
Sentiment Analysis of Movie Reviews
0
48
Home Value Prediction (Regression)
0
45
Geospatial Analysis of Traffic Accidents in the United Kingdom
0
49
Time Series and Trend Analysis
0
52
ETL and Data Analysis of Movies
1
1
56
Academic Management — Database Development & SQL Analytics
0
49
Database Modeling - E-Commerce Platform
0
43
Book Catalog Web Scraper (Web Data Extraction with Python)