-
Painting with Data: The Art of Creating Compelling Power BI Reports and Dashboards
Imagine you’re an artist, standing before a canvas with a palette full of vibrant colors at your disposal. But instead of oils or watercolors, you’re working with data – swathes of numbers, intriguing metrics, and intricate patterns. Your task? To paint a picture that tells a compelling story, one that captivates your audience and drives Read more
-
Charting the Course: Knowing and Measuring What Matters
Song Recommendation for today’s article: Hello, data whisperers! Remember the game Watch Dogs, where Aiden Pearce used his mad hacker skills to turn a whole city into his playground? Imagine if we could do the same with our businesses—cracking the code of success, and knowing exactly what actions to take to reach our objectives. Well, Read more
-
Project 1 – Codename ‘Deep Below’: A User-Friendly Voyage through Excel, Power Query, and Power BI
Ahoy there, fellow data sailors! Recommended song for this project: “Sleeping in the cold below?” Not us, not today. We’re about to set sail on an adventure as exciting as any sea shanty, with a treasure more valuable than gold doubloons: data. Yes, my brave companions, today we embark on a journey that spans the Read more
-
Heart in the Machine: Emotion, Empathy, and Their Unforeseen Role in Automation
I can neither confirm nor deny that I may have botched the scheduled publication time of today’s post on VBA… But in the spirit of consistency, I still wanted to get something fresh out for anyone who may be reading in the evenings after work. In the spirit of full disclosure, I am the type Read more
-
VBA for Excel: Unleashing the Power of Automation
Hello, and welcome back! Today, we’re venturing into the magical realm of Excel automation with a look at Visual Basic for Applications (VBA), the programming language that turns Excel from a simple spreadsheet application into an automation powerhouse. Quick note here – I typically use VBA in this setting, as it just fits better with Read more
-
Excel Beyond Excel: The Power of Power Query
Today’s businesses thrive on data. Data is being produced at an unprecedented rate and comes in almost too many different formats, from different sources, and with varying levels of quality. As a result, extracting useful information from this sea of data can sometimes feel like looking for a needle in a haystack. This is where Read more
Abstract Foundations 