Every time I run a Copilot for Excel workshop, there’s one question that always comes up: “How can I make Copilot remember my prompts so it can do my weekly reports automatically?” Short …
How to create a real estate dashboard in Power BI, Part 2: Building the dashboard
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 →