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 teach Power BI to Excel users quickly
If you’re responsible for leading Power BI adoption and training at your organization, you know the challenge: users deeply comfortable with Excel may resist adopting new tools, feeling overwhelmed by …
Continue Reading about How to teach Power BI to Excel users quickly →
How to build a top N parameter in Excel
In BI tools such as Tableau and Power BI, one of the most common milestones toward intermediate learner status creating a Top N parameter. This feature allows users to choose a value for N (e.g., 3, …
Continue Reading about How to build a top N parameter in Excel →
Power Platform for Excel: How to understand the Microsoft Dataverse
The Microsoft Dataverse is a powerful and versatile data platform that plays a central role in the Microsoft Power Platform ecosystem. For Excel users looking to expand their data management …
Continue Reading about Power Platform for Excel: How to understand the Microsoft Dataverse →
Will Python, Copilot, and Excel make Power BI obsolete?
Over on LinkedIn, Dennis Sawyers is always a lively and outspoken voice worth following. His latest post has sparked my interest, compelling me to share my own thoughts candidly. Dennis argues …
Continue Reading about Will Python, Copilot, and Excel make Power BI obsolete? →
How to load a data model from Excel to Power BI
One of the best things about Power Pivot and Power Query is that once you've learned how to use them in Excel, you can easily transfer that knowledge to Power BI: But not only do your skills …
Continue Reading about How to load a data model from Excel to Power BI →