One of our users was manually entering data into a spreadsheet every single day rain or shine, weekday or weekened, vacation or not. She needed an automation solution, and I built one for her. But, we ran into a small but time-consuming problem to solve. The automation added data to an Excel spreadsheet, but the updated data didn’t appear in PowerBI. Half the battle was figuring out whether Excel, PowerBI, Power Automate, or Alteryx was causing the problem. Wanna guess which one it was? Read on to find out.Read More »Automation with Excel, PowerBI, Power Automate & Alteryx! What Could Go Wrong?
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