In a previous post, I showed how to take a tenancy schedule from a real estate brochure PDF and turn it into a Power BI dashboard. In the last post, we focused on retrieving and cleaning the …
Python in Excel: How to do feature engineering with Copilot
Feature engineering involves transforming raw data into meaningful variables to enhance machine learning models. It includes creating new features, encoding categorical data, and scaling or …
Continue Reading about Python in Excel: How to do feature engineering with Copilot →
Python in Excel: How to transform text with Copilot
Text transformation and analysis has never exactly been Excel’s strong suit. Sure, native text functions have significantly improved in recent years with new parsing and even regular expression …
Continue Reading about Python in Excel: How to transform text with Copilot →
How to unpivot a dataset in Excel Power Query vs R vs Python
What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we'll look at a frequent offender: unpivoted data. You'll learn …
Continue Reading about How to unpivot a dataset in Excel Power Query vs R vs Python →
How Power Query enforces good data hygiene in Excel
Not only is Power Query a phenomenal tool for transforming data in Excel, it also enforces good data hygiene 🧼. What do I mean by that? Think about the steps that you take every day to present …
Continue Reading about How Power Query enforces good data hygiene in Excel →
I ordered Chinese takeout… then this happened
The other day the family ordered Chinese takeout.Normally one of us would take out a notepad and scribble notes, which often became illegible and ran across multiple pages. There has to be a better …
Continue Reading about I ordered Chinese takeout… then this happened →