Fredy Santos
Data Analyst and SQL & Excel storytelling Specialist
New to Contra
Fredy is building their profile!
📝 Ninth Publication: Efficiency vs. Repetition: The Logic of Stored Procedures 🌱
In data analysis, the most valuable resource isn't just the data itself—it’s time. Today, I’m exploring how moving from manual, repetitive queries to automated systems can transform a workflow from...
The Road Makes the Goal: Why I’m Celebrating the Small Wins 🌱
We often talk about the 'Senior Data Analyst' goal or the 'Big Contract' finish line. But lately, I’ve realized something powerful: The goal is just a destination, but the road is where the growth actually happens.
...
Why I Model Before I Code: The Blueprint for Data Integrity 📝
You wouldn't build a house without a blueprint, so why build a database without a model? Skipping the Relational Design phase is the fastest way to create 'Data Debt' that will haunt your business later.
🔍 The...
Is Your Database Running or Crawling? The Power of Indexing ⚡
Imagine walking into a library with 1 million books and no catalog. To find one specific title, you’d have to check every single shelf. That is exactly what your database does when you forget to create an Index.
🔍 The...
Stop Hard-Coding Rankings: The Power of SQL Window Functions!
In Business Intelligence, context is everything. It’s not enough to know how much a product sold; you need to know how it ranks against its peers or how its performance is trending over time. This is where Window...
