Taking a quick glance at your content marketing data, you can usually glean a couple of insights and major themes. While this anecdotal evidence can be beneficial, sometimes we need a deeper dive – the insights might not always be clear, or perhaps you have a theory that you want to test. Are certain topics […]
Working with nested JSON data in Excel If you’ve ever needed a quick way to do statistical analysis of JSON data or convert it to a delimited format like CSV, Microsoft Excel’s power query gives you that ability. However, if you’re used to only working with traditional delimited data like CSVs, there will likely be […]
Converting raw, non-delimited text into usable formats If you’ve spent as much time working with datasets as I have, you’ve probably run into a situation at least once where the data you need does not come in a neat, tidy, or even usable format. In a perfect world, raw data would be delimited in some […]
Parameters are an incredibly powerful tool when constructing queries in Microsoft Excel. And if your source data changes frequently, parameters can come in extremely handy to change multiple file names/paths hurry. For example, I had queries set up to pull data from about 30 spreadsheets from our finance department. Every month, they ran new reports […]