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 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 →
Python in Excel: How to do k-nearest neighbors with Copilot
K-Nearest Neighbors (KNN) is a straightforward and powerful analytical tool that helps you make predictions by looking at the most similar cases or "neighbors" in your data. It's intuitive because it …
Continue Reading about Python in Excel: How to do k-nearest neighbors with Copilot →
Python in Excel: How to build decision trees with Copilot
Decision trees are intuitive analytical tools that help us explore and predict outcomes by asking simple, branching questions about our data. They're popular because they're visual, easy to interpret, …
Continue Reading about Python in Excel: How to build decision trees with Copilot →
Python in Excel: How to do hierarchical clustering with Copilot
Hierarchical clustering is a technique that groups similar data points into clusters based on their attributes, forming a hierarchy or tree-like structure. Imagine organizing customers based on their …
Continue Reading about Python in Excel: How to do hierarchical clustering with Copilot →