Data Wrangling

Your Spreadsheet Format Sucks, Alteryx Will Fix It

Last week, I was working with one of our engineers to streamline an alarm reporting process. They receive spreadsheet CSVs of alarm data, and they have an Excel macro process to collate the data and pull out what they need. It’s not a great process, and it’s not sustainable, so we are using Alteryx to improve it. And, the CSVs come in a very unfortunate format. So, for this week’s post, I’m going to show you exactly how I took a wonky spreadsheet and turned it into something that BI applications can easily consume.

Read More »Your Spreadsheet Format Sucks, Alteryx Will Fix It

Error Reporting with Alteryx & Spotfire

It’s a fact. If you have manual data entry, there will be errors. I found this out the hard way when working with our completions team on a Spotfire KPI project. We built the Spotfire KPIs and were attempting to tie out to spreadsheets. The numbers didn’t match. Discrepancies consistently traced back to bad data entry. We would fix the bad data, but without proper controls to keep it out, we were chasing our tails. So, we addressed bad data with a QAQC or error report. The first version was all Spotfire, but it had flaws. Version 2 performed error reporting with Alteryx. Ultimately, I wound up with a combination of Alteryx and Spotfire. To see what it looks like and how it was implemented, read on.

Read More »Error Reporting with Alteryx & Spotfire