Tag: Power Query
-
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…
-
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…
-
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…
-
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…
-
Power Query: Tell me you’re decent with Excel without telling me you’re decent with Excel.
Hello again, data enthusiasts! It’s time to get our hands dirty with some serious data crunching as we delve deeper into the powerful world of Power Query. In our last article, we touched on the basic features of Power Query. Now, let’s kick things up a notch and explore some commonly used options that can…
Abstract Foundations 