Available for hire

Iván de Jesús Díaz Navarro

Data Analyst

Data Analyst · BI · Automation

I turn complex data into clear, actionable intelligence using executive dashboards, statistical analysis, A/B testing, and process automation. Python · SQL · Power BI / Tableau · Google Apps Script.

View Projects arrow_forward

🇺🇸 CV English 🇲🇽 CV Español

database SQL

code Python

bar_chart Tableau

functions Apps Script

settings_suggest Data Automation

Core
Stack

school

Driving better decisions every sprint

Trusted by leadership and teams

insights

Data Driven

Analytical focus

neurology Flagship projects

The five cases that best explain my profile

If an interview only had room for five examples, these are the ones I would lead with: Oasis Live '25, executive storytelling, operations automation, cultural product design, and analytics product design.

music_note Project #1

Tempo

41 concerts / 17 cities

Oasis Live '25

Interactive Streamlit dashboard to explore Oasis' reunion tour with filters for city, date, estimated attendance, estimated gross, and setlist variants.

Streamlit Python Dashboard Music analytics

graphic_eq

Core capability

Interactive music analytics

Challenge: Turn a live tour into a clear read by city, setlist, and estimated demand.

Result: An opening case that blends data, public images, and an exploratory flow that feels like a concert.

open_in_new View details code View on GitHub

auto_graph Executive dashboard

Lens

Categories, regions & time

Storytelling & Integration

My reference case for stakeholders: it turns a large dataset into an immediate visual read of categories, regions, and time evolution.

SQL Looker Studio Python Dashboard

query_stats

Core capability

Executive storytelling with data

Challenge: Compress thousands of records into a visual story that any stakeholder can read in minutes.

Delivery: Data cleanup, condensed KPIs, regional map, and time-based reading inside a public Looker Studio dashboard.

open_in_new View details code View on GitHub

schedule Operations platform

Coverage

WhatsApp, mobile & back office

WhatsApp Attendance Control Platform

Attendance operations system combining WhatsApp capture, a NestJS backend, a React/Capacitor app, and traceability for supervisors.

WhatsApp NestJS React + Capacitor Apps Script

event_available

Core capability

Operations automation with traceability

Problem: Manual logging, poor traceability, and fragmented operations across WhatsApp, reporting, and follow-up.

Result: One flow for capture, auditing, alerts, and attendance read-state.

open_in_new View details code View on GitHub

travel_explore Cultural experience

Interaction

QR, map & audio

Zoque Murals of Copainalá

Mobile-first cultural app that turns the mural route into an experience powered by geolocation, QR scanning, story, and audio.

Next.js PWA Leaflet QR

map

Core capability

Mobile-first cultural product

Challenge: Turn local heritage into a digital experience meant to be used on-site, not just displayed as a static case study.

Outcome: Published PWA with a live map, mural detail views, QR entry points, and audio capsules.

open_in_new View details travel_explore Open experience

smart_toy Analytics product

Input

Natural language to SQL

AI Data Analyst Platform

Conversational analytics product that turns business questions into safe SQL, charts, insights, and downloadable reports.

FastAPI Streamlit SQLAlchemy Plotly scikit-learn

analytics

Core capability

AI-assisted analytics

Input: Datasets plus business questions in natural language.

Output: Safe queries, analysis, visualizations, and actionable recommendations.

open_in_new View details rocket_launch Open demo

Technical Skills

Tools and platforms I rely on to drive insights from data and guide smarter decision-making.

terminal

Python & R

Data cleansing (Pandas), exploratory analysis, and statistical modeling.

database

SQL Avanzado

Writing complex queries, optimizing performance, and managing relational databases.

monitoring

Power BI / Tableau

Data storytelling and crafting interactive dashboards for stakeholders.

psychology

Machine Learning

Building basic predictive models and classifiers with Scikit-Learn.

settings

Google Apps Script & Automation

Automating operational workflows, dynamic reporting, and API integrations (WhatsApp, Google Sheets, and business pipelines).

query_stats

Statistical Analysis & A/B Testing

Hypothesis testing, cohort analysis, retention metrics, and data-driven decision validation.

dashboard

Business Intelligence & Executive Dashboards

Designing KPI-focused dashboards, data storytelling, and executive decision support.