David Langer (Dave on Data)
Analytics/Excel educator; shares FP&A forecasting techniques (Python-in-Excel, ARIMA/ML), scenario modeling, and data storytelling for finance.
Fuzzy Matching Beats LLMs for Cleaning Text Data
Free-form text data is everywhere in modern organizations. And it's usually dirty. Tomorrow, 39,000+ professionals will learn a powerful way to clean text data - fuzzy matching. In this age of AI, it's tempting to give free-form text data to an LLM tool like ChatGPT or Claude and ask it to perform the matching. However, there is a problem with this approach.
Free Sentiment Analysis Tutorial Reaches 39,000 Professionals Tomorrow
Tomorrow, 39,000 professionals will receive a new, free analytics tutorial on a topic executives love - sentiment analysis. You can think of sentiment analysis as a technique where you use a computer to analyze free-form text data and summarize the contents...
Mid‑market AI Success: Small Teams, Tight Budgets, Mature BI
Most of my clients are mid-market organizations, and they're all approaching AI the right way. And it has nothing to do with ChatGPT/Gemini/Claude. Here's what these organizations all have in common: 1 - Small teams. 2 - Tight budgets. 3 - Mature BI infrastructure. 4 -...
The Forbidden Excel Formula that Haunts Every Organization
I've been doing analytics for 14+ years. And I'm a Microsoft Excel MVP. I still see this regularly in organizations both large and small: The one formula nobody is allowed to touch.
More Analysis, Fewer Dashboards: Solve the Real Problem
I've worked as a Sr. Director of BI and Analytics and I had to learn something the hard way. Despite what business stakeholders say, another dashboard is rarely the right answer to their needs. Why? Because what's behind the ask is a misconception...
Turn Excel Into a Text Mining Powerhouse
Each week I send out a free analytics tutorial to 39,009 professionals. This week is Part 3 in a series on mining free-form text data using Python in Excel. Think about this for a second. Production quality, reproducible text mining inside an Excel...
Business Professionals Need Data Analysis Skills, Not Analyst Titles
I teach professionals data analysis. Not to be Data Analysts. Why? Because most analyses are conducted by business professionals, not IT. And with Copilot in Excel, that's only going to increase, not decrease.
Excel Pros Must Learn Python to Trust Copilot
I've been doing analytics for 14+ years. And I'm a Microsoft Excel MVP. It's 2026 and top Excel users know better than making this mistake: Ignoring Python. Because Copilot in Excel uses Python to work it's magic with your data. Even if it doesn't tell...
