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 …
How to create a real estate dashboard in Power BI, Part 1: Data cleaning
Later this month I’m running a free webinar with Bayfield Training, a leading provider of real estate and financial modeling courses. Like most industries, real estate can get a big boost from solid …
Continue Reading about How to create a real estate dashboard in Power BI, Part 1: Data cleaning →
How I became an Excel trainer… the Stringfest origin story
Whenever I get asked the same thing two or three times, I figure it's worth turning into a post. So I am genuinely surprised I haven't written about how I became an Excel trainer yet. I've written …
Continue Reading about How I became an Excel trainer… the Stringfest origin story →
Python in Excel: How to do price elasticity analysis with Copilot
Understanding how price changes affect customer demand is one of the most valuable insights you can bring to your business. This concept, known as price elasticity of demand, helps answer practical …
Continue Reading about Python in Excel: How to do price elasticity analysis with Copilot →
Copilot in Excel: How to do social influencer analysis with Python
Understanding who your most influential customers are—those who consistently recommend your business—is essential for sustainable, cost-effective growth. This approach, called social influencer …
Continue Reading about Copilot in Excel: How to do social influencer analysis with Python →
Copilot in Excel: How to build ARIMA forecasts with Python
ARIMA (short for AutoRegressive Integrated Moving Average) is a classic statistical model for time series forecasting. It works by combining three elements: autoregression (using past values to …
Continue Reading about Copilot in Excel: How to build ARIMA forecasts with Python →