DM – Analytics

From Excel to Python: Every Data Analyst’s Natural Evolution

From Excel to Python: Every Data Analyst’s Natural Evolution “The best analyst isn’t the one who creates the most reports. It’s the one who spends the least time creating reports and the most time discovering insights.” That realization completely changed how I approached analytics. Like many analysts, I started my career living inside Excel. Every […]

Python

From 48 Hours to 6 Minutes: My Journey Optimizing a Pandas Reconciliation Process for Large-Scale Data

Introduction I recently went through a wild but rewarding ride optimizing a heavy pandas-based reconciliation workflow. What started as a slow, clunky piece of code eating up over 48 hours, ended up getting polished into a lean, mean 6-minutes machine. I wanted to share my story – not as a tutorial, but as a real-world […]