Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...

Have you ever found yourself buried under a mountain of Excel sheets, each holding pieces of data that need to be stitched together into one cohesive whole? It’s a common challenge for anyone working ...

If you’ve always been in awe of folks using the Google Search Console API to do cool things, this article is a good read for you. You can use BigQuery with the GSC bulk data export to get some of the ...

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet. There are several ways to find duplicates in a Microsoft Excel sheet. You ...

How to generate a list of Microsoft Excel sheet names by exposing Power Query metadata Your email has been sent When a Microsoft Excel workbook contains a lot of sheets, the sheet tab you need is ...

Have you ever found yourself staring at a long, messy column of data, wondering how to quickly transform it into a clean, structured table? For anyone working with Power Query, this challenge is all ...

Today, data is undoubtedly a leading driver of business success. How well a company is able to leverage insights from the ever-increasing wealth and complexity of available data is, increasingly, a ...