Configuring Microsoft Azure DevOps

This is post four in my series on learning to use Microsoft Azure DevOps to manage analytics assets. Last week, I posed five questions to ask and answer before configuring ADO, so that you don’t have rework as I did. Now, we’re going to talk about configuring Microsoft Azure DevOps, specifically the organization, area paths, teams, and iterations. Read on to learn more.

Read More »Configuring Microsoft Azure DevOps

5 Questions to Ask and Answer Before Setting Up Azure DevOps

Welcome to Part 3 of my series on learning to manage analytics assets with Microsoft Azure DevOps (ADO). In Part 1, I explained how our analytics team works and why we needed an application to manage analytics assets. In Part 2, I talked ADO structure and terminology. This week, I’ll cover five questions to ask before setting up Azure DevOps to avoid rework. Read on to plan your ADO project.

Read More »5 Questions to Ask and Answer Before Setting Up Azure DevOps

Solve Query Timeout Issues in Alteryx

A few weeks ago, I wrote a post on how to resolve query timeouts using batch macros. Shortly after publishing, Mark Frisch of CReW Macros reached out to me to say that my post wasn’t wrong (whew!), BUT there is another way to fix query timeouts without resorting to macros. It’s taken me a while to get around to it, but I wanted to share his solution as well. Read on to learn another way to solve query timeout issues in Alteryx.

Read More »Solve Query Timeout Issues in Alteryx

Remove Leading Zeros in Alteryx

This week, I ran into a data engineering problem where I needed to extract a JV number from a string of numbers. The JV number can have 3,4, or 6 digits. For any number less than 6 digits, the system adds leading zeros. At first, I thought I needed to dig into some Regex, but there was a much simpler answer to remove leading zeros in Alteryx. Read on to add another tool to your Alteryx toolbox.

Read More »Remove Leading Zeros in Alteryx

How to Modify Individual Values in Spotfire

TIBCO designed Spotfire to bring data into the application, wrangle it into a useable form, and display visualizations for analysis. It’s not really designed to modify source data, but that doesn’t mean that people don’t want to or that you can’t. In fact, it’s easy to modify individual values in Spotfire if you know where to look, just like clicking on a cell in Excel. Read on for more information.

Read More »How to Modify Individual Values in Spotfire

The Danger of Hiding Data in Spotfire

Occasionally, I have a really hard time coming up with a good title for a post. This is one of those circumstances. But what I’m going to show you here is important if you want to sharpen your troubleshooting skills. A user reached out to me this week for help with a calculation on a cross table. It seemed like Spotfire was calculating inconsistently, but software doesn’t work that way. So, we had to be missing something. Would you have figured this out? How quickly would you have solved this puzzle? Can you find data hiding in Spotfire? Read on to learn more.

Read More »The Danger of Hiding Data in Spotfire

How to Fix Query Timeouts in Alteryx

Last week, I built a large workflow while querying a subset of the data. With the workflow complete, I need to “open ‘er up”. However, doing so resulted in time-out errors. The query was so large it couldn’t complete. Transactional finance data….am I right??? I came up with two ways to solve this problem. Read on to learn how to fix query timeouts in Alteryx.

Read More »How to Fix Query Timeouts in Alteryx