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 →
O stakeholder te pediu um dashboard. Qual é o seu próximo passo?
Gabriela Costa and Juan Manuel Perafan discuss the importance of discovery in data projects. Rather than jumping directly to SQL or BI tools, professionals should first understand the stakeholder's underlying business problem.
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.
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.