-
Elementary, My Dear Data Analyst: Unraveling the Mysteries of Data Acquisition
The Great Data Hunt. In the vast labyrinth of modern business processes, data comes in all shapes and sizes, from your conventional CSV files to the high-tech world of APIs. We don’t always get to dictate how data is handed to us, but fear not, for every data format presents a thrilling puzzle waiting to…
-
Python 101: Unraveling the Basics of the Most Popular Coding Language
Roll up your sleeves, folks, because today we’re diving into the deep end of the coding pool with Python, the world’s most popular programming language! (Don’t worry, Python’s as a coding language is far less dangerous than its namesake!)
-
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…
Abstract Foundations 