Analytics Engineer · Instructor · Author · Community Builder
Juan Manuel Perafan
A decade of experience helping organizations make their data resemble their business, not forcing their business to fit a data model. Welcome to my corner of the internet, where I keep my books, talks, videos, podcasts, and blogs.
What You'll Find Here
Conference Talks
Slides and recordings from live events
Video Tutorials
Technical deep dives and how-tos
Podcasts
Conversations about data and community
Blog Posts
Articles on analytics engineering
Let's Work Together
I'm available to speak at your next conference, meetup, or corporate event, train your team on analytics engineering and the modern data stack, or provide strategic consulting for your data initiatives.
Speaking
- • Conference keynotes
- • Technical deep dives
- • Meetup presentations
Training & Mentorship
- • Curriculum design
- • Leading workshops & training
- • Team mentorship
Consulting
- • Data strategy & architecture
- • Data modeling & SQL
- • Modern data stack
Podcast Appearances
View all →
Foundations of Analytics Engineer Role: Skills, Scope, and Modern Practices
In this episode, we discuss the Analytics Engineer role. What it includes and how it complements data engineers, data scientists, and business teams
From Psychology to Analytics Engineering
In this episode, Bolaji interviews Juan Manuel Perafan, a psychology major turned analytics engineer, who shares his journey from Colombia to the Netherlands and his transition into the data field.
Decifra lo que tu cliente quiere: Pongámosle datos al Marketing
En este episodio, Juan Manuel Perafan, Analytics Engineer en Xebia, comparte su experiencia en el mundo de los datos y cómo estos pueden transformar las estrategias de marketing.
Recent Videos
View all →
dbt-excel, the revolutionary dbt adapter that turns spreadsheets into data warehouses
Welcome to dbt-excel, the revolutionary dbt adapter that combines the rigor of dbt with the flexibility and familiarity of Excel. Get ready to change the way you look at data analytics forever. ...
The Problem with Tableau & Power BI
I love how Tableau & Power BI are constantly pushing each other to become better tools. Both of these tools come with an army of shiny features. But I believe could still learn a lot from DevOps an...
The Problems with KPI's (Key Performance Indicators)
KPI's are an invaluable tool to track the progress of your organization. But they can be a double-edge sword and here are 3 reasons why.
Recent Blog Posts
View all →
The WriteOps Manifesto: DevOps for Writers
Why technical writers need CI/CD pipelines, version control, and automation just as much as developers do.
AsciiDoc > Markdown
AsciiDoc is objectively better than Markdown for technical writing. Here's why you should make the switch.
Book Review: SQL for Data Analytics (4th Edition)
I recently finished reading SQL for Data Analytics (4th Edition). Here are my thoughts on the book.