Skip to content
View juandelaf1's full-sized avatar
5 followers · 9 following

Achievements

Achievement: QuickdrawAchievement: Pull Sharkx2

Achievements

Achievement: QuickdrawAchievement: Pull Sharkx2

Block or report juandelaf1

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
juandelaf1/README.md

👋 Hi! I'm Juan

Data Analyst | SQL · Python · Power BI | Operations & Business Analytics

📍 Madrid, Spain

🧠 About Me

I am a Data Analyst with a strong background in business operations, where for more than 7 years I worked with key metrics such as sales, costs, margins, demand and operational efficiency. This experience gave me a deep understanding of how real businesses operate and how data can improve decision-making, optimize resources and anticipate problems.

After transitioning into Data Science & Analytics, I developed technical skills in Python, SQL and Power BI. Today I combine my operational experience with analytical capabilities to transform complex datasets into clear, visual and actionable insights.

I specialize in:

  • 📊 Business and KPI analysis
  • 🧮 SQL for data analysis and reporting
  • 📈 Dashboard development in Power BI
  • 🐍 Python for data analysis and automation
  • 🔍 Actionable insights focused on business impact

🧰 Tech Stack

Category Tools / Technologies
Visualization Power BI, Streamlit, Plotly, Seaborn, Matplotlib
Data Analysis & Processing pandas, numpy
Databases PostgreSQL
Programming Languages Python
Version Control & Tools Git, GitHub

📂 Featured Projects

🔹 DashLogistics — End-to-End Logistics Analysis

ETL pipeline + data analysis + dashboard development to evaluate logistics performance through KPIs such as delivery time, operational costs and efficiency.
🔗 Repository: DashLogistics

🔹 Optimus Price — Data-Driven Hotel Pricing

Demand and seasonality analysis using hospitality KPIs (ADR, RevPAR, occupancy) to identify pricing optimization opportunities.
🔗 Repository: OptimusPrice_proyecto_final_ML

🔹 Spanish Wine EDA — Price Pattern Exploration

Exploratory data analysis to identify relationships between wine price, region and quality ratings.
🔗 Repository: mas_alla_de_la_etiqueta_EDA

💼 What I Bring to a Company

  • 🔍 Business perspective: real experience working with operational metrics and performance indicators.
  • 📊 Analytical rigor: clean data, clear KPIs and actionable conclusions.
  • 🚀 Optimization mindset: focus on efficiency, cost control and continuous improvement.
  • 🤝 Team collaboration: clear communication and results-oriented work.
  • 🧩 Execution mindset: if information is missing, I find it; if something breaks, I fix it.

📬 Let's Connect

🔗 LinkedIn: https://www.linkedin.com/in/juandelafuentelarrocca/
📧 Email: juandelafuentelarrocca@gmail.com

Pinned Loading

  1. SkyCast SkyCast Public

    Enterprise Climate Intelligence Platform - FastAPI, Streamlit, PostgreSQL, AEMET OpenData

    Python

  2. mas_alla_de_la_etiqueta_EDA mas_alla_de_la_etiqueta_EDA Public

    Exploratory data analysis (EDA) of Spanish wines focused on identifying key patterns. Examines relationships between wine attributes and pricing dynamics.

    Jupyter Notebook

  3. OptimusPrice_proyecto_final_ML OptimusPrice_proyecto_final_ML Public

    Optimus Price is an ML-powered revenue management tool for hotels, delivering real-time pricing based on demand patterns and seasonality.

    Jupyter Notebook

  4. DashLogistics DashLogistics Public

    End-to-end ETL pipeline for logistics data, including advanced KPI calculations, analysis, and visualization for actionable insights.

    Jupyter Notebook

  5. ProyectoSQL ProyectoSQL Public

    Forked from AlbeertoDZ/ProyectoSQL

    This team project involved designing a relational database to manage academic information such as students, teachers, bootcamps, evaluations, and resources. I contributed to the relational model, E…