iiinova — where your digital self keeps evolving

Dave Langer @daveondata.bsky.social · 28/04/2025

Vibe Analytics with Copilot in Excel - Day 2 Copilot in Excel does an excellent job of using column names to understand the nature of your data. So I decided to test Copilot in Excel using column names like: Column1 Column2 Column3 Here's what happened...

110

Dave Langer @daveondata.bsky.social · 27/04/2025

Want to differentiate yourself at work with Excel skills? Leaders aren't excited about this in 2025: - Using PivotTables - Knowing many functions You know what they're excited about: AI And that means Copilot in Excel. Here are 4 ways to build skills to impress your leaders:

100

Dave Langer @daveondata.bsky.social · 27/04/2025

Want to predict customer churn? Don't overcomplicate it. Use logistic regression. It's powerful, interpretable, and works great with real business data. Start with Python in Excel.

000

Dave Langer @daveondata.bsky.social · 26/04/2025

Is your company rolling out Copilot in Excel? Here's the mistake your executives are probably making: To make the most out of AI in Microsoft Excel, you need to know 2 things: 1 - Python 2 - DIY data science Copilot in Excel relies heavily on Python. 👇

100

Dave Langer @daveondata.bsky.social · 25/04/2025

Excel → Power Query → Python → Machine Learning That's the real progression for DIY data science. You don't jump to neural networks. You grow step by step. From formulas to forecasts.

120

Dave Langer @daveondata.bsky.social · 25/04/2025

8,587 professionals will receive a new machine learning tutorial tomorrow: ML with Python in Excel. It will be the first in a series of tutorials showing how Microsoft Excel is the platform for DIY data science. Want in? Click the link in my profile to get started.

100

Dave Langer @daveondata.bsky.social · 24/04/2025

The Copilot AI inside Excel can write Python code for you. That's the future Microsoft envisions. Here's what Microsoft won't tell your executives. If you can't prompt it well, you're playing with 🔥. Learn enough Python to guide the AI... And leave 99% of Excel users in your dust.

000

Dave Langer @daveondata.bsky.social · 24/04/2025

Want to join the top 1% of Excel users in the age of AI? Here’s the biggest mistake you can make in 2025: Ignoring Python in Excel. Here's why:

100

Dave Langer @daveondata.bsky.social · 23/04/2025

Need to join 3 tables? Formulas = pain SQL = elegant Learn JOIN, GROUP BY, CASE WHEN Drop the SQL into Power Query. Your Excel workflow will never be the same.

110

Dave Langer @daveondata.bsky.social · 23/04/2025

In 2025, Microsoft Excel power users will be using Python in Excel. Here are 5 reasons why (with business scenarios):

100

Dave Langer @daveondata.bsky.social · 22/04/2025

Your PivotTable won't find customer segments. Cluster analysis will. Tools like k-means help you group customers by many behaviors. So many behaviors it makes PivotTables cry. Try it with Python in Excel. It's like discovering new tribes in your data.

110

Dave Langer @daveondata.bsky.social · 22/04/2025

Most Excel users don’t realize it yet... But Python in Excel is the biggest upgrade to the tool in 30+ years. Here’s why it changes everything for people who live in spreadsheets:

100

Dave Langer @daveondata.bsky.social · 22/04/2025

Reporting tells you what happened. Analysis tells you why. Prediction tells you what's next. Most professionals stop at the first one. Want more impact? Learn the other two.

100

Dave Langer @daveondata.bsky.social · 21/04/2025

Most Excel pros ignore the most powerful tool in the app. It’s not formulas. It’s not macros. It’s Power Query. Here’s why Power Query is your secret weapon for doing real analytics in Excel:

100

Dave Langer @daveondata.bsky.social · 21/04/2025

Excel formulas are great. But SQL lets you: - Query millions of rows - Filter like a data whisperer - Prep data BEFORE it hits Excel SQL + Excel == next-level spreadsheets. And now with Python in Excel? It's a must-learn.

100

Dave Langer @daveondata.bsky.social · 20/04/2025

Most ML advice is built for future data scientists. But what if you just want to solve real business problems? Here’s the 5-step path I teach working professionals:

100

Dave Langer @daveondata.bsky.social · 19/04/2025

Most real-world machine learning isn't Gen AI or neural nets. It’s this: - Profile your data - Engineer useful features - Use decision trees ML isn’t magic. It’s just pattern-finding + good inputs. Start with intuition. Scale with trees.

010

Dave Langer @daveondata.bsky.social · 19/04/2025

Excel isn’t just formulas anymore. It’s a full-blown data stack. But most users are stuck in 2007. Here’s how you become a modern Excel power user in 2025:

110

Dave Langer @daveondata.bsky.social · 18/04/2025

I've been using SQL for 25 years. I've been doing analytics for 13 years. Here are 6 hard-won lessons I've learned when using SQL for DIY data science:

100

Dave Langer @daveondata.bsky.social · 17/04/2025

Microsoft Excel → Python PivotTable to count items by category? In Python: table.groupby('category').size() Boom! Instant PivotTable in one line.

100

Dave Langer @daveondata.bsky.social · 17/04/2025

Don't focus so much on the "Python" aspect of Python in Excel. A better way to look at it is this: Microsoft Excel is now the ultimate choose-your-own-adventure analytics tool. Building data analysis skills with Excel is like visiting various stops on a wandering journey...

100

Dave Langer @daveondata.bsky.social · 16/04/2025

Microsoft Excel → SQL Need to remove duplicates in Excel? You'd use Data -> Remove Duplicates. In SQL: SELECT DISTINCT customer_id FROM transactions DISTINCT shows you unique values. No clicks needed. **AND** You've automated it for reproducibility.

010

Dave Langer @daveondata.bsky.social · 16/04/2025

With the release of Python in Excel, there's more reason than ever to learn Power Query. While you can wrangle data using Python formulas, here are good reasons to prefer Power Query to Python. If you're a "Pythonista," this opening might anger you. Please read on before 🔥 me...

100

Dave Langer @daveondata.bsky.social · 15/04/2025

With Python and Copilot in Excel, learning SQL is more valuable than ever for Microsoft Excel users. Here's the "why" in two words: Power Flexibility First, let's talk about Python in Excel.

100

Dave Langer @daveondata.bsky.social · 15/04/2025

Microsoft Excel → Python Need a new "level" column on a table with logic like: =IF(C2 > 1000, "High", "Low") In Python: table['level'] = np.where(table['sales'] > 1000, 'High', 'Low') Your Excel knowledge can unlock the power of Python.

100

Dave Langer @daveondata.bsky.social · 14/04/2025

2025 will be the year that separates Excel users: 1 - Those with SQL skills. 2 - Those without SQL skills. While SQL has always been wildly useful for Excel users, 2025 is different because of these three words: Python in Excel. Here's why:

100

Dave Langer @daveondata.bsky.social · 14/04/2025

Microsoft Excel → SQL Sorting your data Z→A in Excel? Just click the column dropdown. In SQL: SELECT * FROM SalesData ORDER BY ResellerName DESC Same concept, only automated. And works with millions of rows.

000

Dave Langer @daveondata.bsky.social · 13/04/2025

Microsoft Excel users are often stuck. They have text data (e.g., customer service chats) that leaders want analyzed. They also have Security/Legal telling them they can't upload proprietary data to ChatGPT. Are you stuck like this? This is how you get unstuck, step-by-step:

110

Dave Langer @daveondata.bsky.social · 12/04/2025

Call me crazy. If you're a Microsoft Excel user, I want to teach you Python. For free. I want to empower you to take advantage of the next AI hype trend: Vibe analytics. Here's why it will be coming to your organization in 2025:

100

Dave Langer @daveondata.bsky.social · 11/04/2025

Microsoft Excel → Python Filter for "Region = West" in Excel? Click the dropdown. In Python: TableName.query("Region == 'West'") One line. Works even if you have 10 million rows.

100

Dave Langer @daveondata.bsky.social · 11/04/2025

8,587 professionals will receive a new machine learning tutorial tomorrow morning. The topic? Hierarchical clustering using Python. But that's not all. 👇

110

Dave Langer @daveondata.bsky.social · 10/04/2025

Microsoft Excel → SQL VLOOKUP() in Excel helps you populate data in one table by pulling data from another table. In SQL, that's a JOIN: SELECT * FROM orders JOIN customers ON orders.customer_id = customers.customer_id Similar concept. But works with multiple columns and millions of rows.

100

Dave Langer @daveondata.bsky.social · 10/04/2025

So much machine learning content is made for career changers. Bootcamps. Certificates. “How to become a Data Scientist.” But what if you don’t want a new career? What if you want to use ML to have more impact at work? Here’s the DIRE method I teach to get you there:

100

Dave Langer @daveondata.bsky.social · 09/04/2025

Microsoft Excel → Python Sorting sales data in Excel? Just click the table's "sales" column. In Python: table.sort_values('sales', ascending=False) Just like sorting in Excel. Only automated.

111

Dave Langer @daveondata.bsky.social · 09/04/2025

Most professionals get stuck in reporting mode. Endless charts, dashboards, and status updates. But real impact happens when you show: Why it happened What’s next ...not just what happened last week/month/quarter. Here’s the ladder to level up your data skills

110

Dave Langer @daveondata.bsky.social · 08/04/2025

Microsoft Excel → SQL Excel's IF formula: =IF(B2 > 1000, "High", "Low") SQL version: CASE WHEN amount > 1000 THEN 'High' ELSE 'Low' END Same logic. More power.

100

Dave Langer @daveondata.bsky.social · 08/04/2025

Most Excel users stop at formulas and PivotTables. But that’s just the surface. Would you like to stand out from the crowd? You need to start thinking like an analyst. Here are 4 data analysis techniques that will take your Excel skills to the next level:

100

Dave Langer @daveondata.bsky.social · 07/04/2025

Microsoft Excel → Python: In Excel, you'd use =AVERAGE(TableName[ColumnName]) to find the average. In Python: TableName['ColumnName'].mean() One line. Works even if you have 10 million rows.

010

Dave Langer @daveondata.bsky.social · 07/04/2025

It’s a tough job market out there. If you want to stand out, learn this game-changing combo: Power Query + Python in Excel. It's how Microsoft envisions the future of Microsoft Excel. Here’s how to use it to differentiate yourself:

100

Dave Langer @daveondata.bsky.social · 06/04/2025

Want to get ahead of 99% of Microsoft Excel users? Learn Power Query. It’s built into Excel. It’s point-and-click. And it gives you 4 data superpowers that most professionals don’t even know exist:

100

Dave Langer @daveondata.bsky.social · 06/04/2025

8,587 professionals received a new machine learning tutorial yesterday morning. The topic? Tuning hierarchical clustering using Python. But that's not all these DIY data scientists are learning. 👇

110

Dave Langer @daveondata.bsky.social · 05/04/2025

Most Excel users focus on formulas. If you want to stand out, focus on thinking. Here are 2 data analysis skills that separate true data pros from common spreadsheet users:

110

Dave Langer @daveondata.bsky.social · 04/04/2025

8,587 professionals will receive a new machine learning tutorial tomorrow morning. The topic? Tuning hierarchical clustering using Python. But that's not all these DIY data scientists are learning. 👇

100

Dave Langer @daveondata.bsky.social · 03/04/2025

Call me crazy, but if you're a Microsoft Excel user, I want to teach you the most valuable data skill: SQL I'm on a mission to empower professionals like you with data skills. So, I will teach you SQL for free. Your Excel knowledge will make this easier than you think. Check this out. 👇

100

Dave Langer @daveondata.bsky.social · 02/04/2025

It's a tough job market out there. One way to differentiate yourself is by having better Microsoft Excel skills. And I'm not talking about learning more Excel functions. I'm talking about analyzing data. Here are 2 skills that will put you ahead of 99% of Excel users:

100

Dave Langer @daveondata.bsky.social · 02/04/2025

So, you've decided to build data science skills. I want to help jumpstart your journey with my newsletter. Here are two examples of what makes it different: 5-part tutorial on data profiling for machine learning. 5-part tutorial on interpreting ML predictive models. But that's not all. 👇

140

Dave Langer @daveondata.bsky.social · 01/04/2025

Have you heard of "vibe coding"? It's the latest AI trend on social media. I'm betting it won't be long before we have "vibe analytics." Here's why the first is a curiosity. And why the second is dangerous. 🧵👇

100

Dave Langer @daveondata.bsky.social · 01/04/2025

With AI we now have "vibe coding." It's not going to be long before we have "vibe analytics." Collecting my thoughts on this for Tomorrow's thread.

000

Dave Langer @daveondata.bsky.social · 31/03/2025

Building data skills in your current job has always been a good idea. Unfortunately, today's job market is making it a requirement. If you've got Microsoft Excel skills, here's a roadmap of how to build skills today:

210

Dave Langer @daveondata.bsky.social · 30/03/2025

So much real-world machine learning has nothing to do with predicting the future. <GASP> For example, k-means clustering helps you understand the present. And in the real world, that can be more valuable. Here’s why you need cluster analysis in your DIY data science tool belt: 👇

110