-
Critical Imperfection | Overcoming Imposter Syndrome
Did you ever feel like a well-dressed fraud? Like you got lucky, and stumbled into the exact right opportunities to get your invite, but any moment now, someone will tap you on the shoulder, clear their throat, and, with an all-knowing smirk, announce to everyone that you don’t actually belong here? Well, grab a coffee…
-
Project 2 – Codename: ‘Whirlwind’: Twirling Through Excel to Conjure an Automated Data Storm
Recommended Song for this breezy project: Buckle up, data enthusiasts! Today, we’re going on a whirlwind adventure. We’re stepping away from the safe haven of our data centers and stepping right into… the heart of a tornado! Oh, no need to look so terrified – we’re not really going to put you in the path…
-
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…
-
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,…
-
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…
-
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…
-
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…
-
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…
-
Pivot Tables: Your Personal Data Cruncher
Data. In our modern world, it’s everywhere. With the increase of digitized information, we have access to more data points than ever before. And Excel is one of the most popular tools for dealing with this data. But as any data analyst can tell you, large datasets can be a double-edged sword. Yes, they hold…
-
A Step Deeper into Excel: Mastering Lookups and Logical Functions
Hola, data enthusiasts! Ready to venture deeper into the world of Excel lookup and logic functions, and take a look at why they’re some of the most commonly used tools in the business? We’re taking a journey today through the landscape of Logical and Lookup functions. While logical functions allow us to have some control…
Abstract Foundations 