Automated Testing for Broken Visuals with Micro...
Automated Testing for Broken Visuals with Microsoft Playwright Figure 1 This image plagues my dreams, a grey box of death...
Multiple Value Parameters in Paginated Reports
Multiple Value Parameters in Paginated Reports Paginated Reports offer us the ability to generate near pixel-perfect exports of our reports...
Bringing DataOps to Power BI... In Year 3
I need better equipment… that was the first line of my first blog post back in July of 2021. My...
Logging Test Results to OneLake
Weaving DataOps into Microsoft Fabric – Logging Test Results to OneLake In my last article, I reviewed how to automate testing...
Microsoft Most Valuable Professional (MVP)
Microsoft Most Valuable Professional (MVP) I’m honored to receive a Microsoft Most Valuable Professional (MVP) award this year. When I...
Invoke-DQVTesting and Orchestration
Weaving DataOps into Microsoft Fabric – Invoke-DQVTesting and Orchestration In my last article, I discussed how to automate testing on your...
Invoke-DQVTesting -Local
Weaving DataOps into Microsoft Fabric – Invoke-DQVTesting If you are building tests in Power BI and automating those tests in Azure...
Automating DAX Query View Testing Pattern with ...
Weaving DataOps into Microsoft Fabric - Automating DAX Query View Testing Pattern with Azure DevOps In my last article, I...
DAX Query View Testing Pattern
Weaving DataOps into Microsoft Fabric - DAX Query View Testing Pattern The last three months of Power BI Desktop releases...
Commenting Power Query with Azure OpenAI
Part 35 – Commenting Power Query with Azure OpenAI Leveraging Artificial Intelligence (AI) to reduce cycle times. Over the past...
Revisiting Microsoft Fabric and DataOps Principles
Revisiting Fabric: DataOps Principles in the Newest Microsoft Analytics Solution When Microsoft unveiled the Public Preview of Fabric in May,...
Part 34: Bringing DataOps to Power BI
Bringing “Quality is Paramount” for Gen1 Dataflows Continuing from Part 33, where I introduced the polling method for implementing version...
Part 33: Bringing DataOps to Power BI
Make It Reproducible… for Gen1 Dataflows While I look forward to all the new capabilities Gen2 dataflows offer, it may...
Part 32: Bringing DataOps to Power BI
The Data Journey: Don’t Assume What Worked Last Week Will Work Today Microsoft technologies and application programming interfaces (APIs) are...
Part 31: Bringing DataOps to Power BI
DataOps Principle #14 - Analytics is manufacturing Exciting developments are underway for Microsoft users, with the recent announcements of Power...
Part 30: Bringing DataOps to Power BI
DataOps 101 on YouTube Over the past year during meetups and conferences, I have had the opportunity to introduce the...
Part 29: Bringing DataOps to Power BI
Quality is Paramount and the Cell-Level Error Cell-Level errors (like the one in Figure 1) are things of nightmares to...
How DataOps is woven into the Microsoft Fabric
How DataOps is woven into the Microsoft Fabric Last week, there was a wave of awesome news that has come...
Part 28: Bringing DataOps to Power BI
DataOps Principle #8 - Reflect As promised from Part 27, I said I would offer tips on pulling SharePoint verison...
Part 27: Bringing DataOps to Power BI
DataOps Principle #8 - Reflect As I stated in Part 26 of this ever-growing series (a real journey), my colleagues,...
Part 26: Bringing DataOps to Power BI
DataOps Principle #16 - Monitor Quality and Performance For many of us we live in an E3/G3 world. So, what...
Part 25: Bringing DataOps to Power BI
DataOps Principle #18 – Improve Cycle Times Late in September 2022, I had the chance to meet with Mathias Thierbach,...
Part 24: Bringing DataOps to Power BI
DataOps Principle #16 - Monitor Quality and Performance Over the past year I’ve been leveraging Application Insights on my blog...
Part 23: Bringing DataOps to Power BI
DataOps Principle #14: Analytics is Manufacturing “Let’s switch gears” We’ll take a break from talking about dataflows and turn attention...
Part 22: Bringing DataOps to Power BI
DataOps Principle #10: Orchestration In my last two entries I explained a way to integrate Power BI dataflows into source...
Part 21: Bringing DataOps to Power BI
DataOps Principle #15: Quality is Paramount In my last entry I explained how to update a dataflow in the Power...
Part 20: Bringing DataOps to Power BI
DataOps Principle #4: It’s a team sport Despite the negativity and seedy underbelly that comes with social media, it does...
Part 19: Bringing DataOps to Power BI
Bringing DataOps to Power BI on YouTube Earlier this year I began a project to put part of this blog...
Part 18: Bringing DataOps to Power BI
Distractions, DataOps, and Documentation If you have read Part 1 of this series, you probably know that I like to...
Part 17: Bringing DataOps to Power BI
DataOps Principle #1: Continually satisfy your customer It’s complicated… that’s how I would sum up my relationship with SharePoint. On...
Part 16: Bringing DataOps to Power BI
DataOps Principle #9: Analytics is code (cont., cont.) I love Regular Expressions… but I’ve been told I may lean on...
Part 15: Bringing DataOps to Power BI
DataOps Principle #9: Analytics is code (cont.) And now we address Challenge #2… In Part 14 I identified the challenge...
Part 14: Bringing DataOps to Power BI
DataOps Principle #9: Analytics is code Now how did that get there?… A client asked me about a new column...
Part 13: Bringing DataOps to Power BI
DataOps Principle #17: Reuse “Don’t lose it, reuse it!”… is a catchphrase from a popular show that my little one...
Part 12: Bringing DataOps to Power BI
DataOps Principle #7: Reduce heroism “You saved the day!”… one of our clients told my teammate. We had attended a...
Part 11: Bringing DataOps to Power BI
DataOps Principle #14: Analytics is Manufacturing (cont.) “Time is money”… Continuing our work from Part 10 we have the data...
Part 10: Bringing DataOps to Power BI
DataOps Principle #14: Analytics is Manufacturing “Patience is a virtue”… I am not a patient person. Red lights at traffic...
Part 9: Bringing DataOps to Power BI
DataOps Principle #8: Reflect (cont.) “What gets measured gets done”… I’ve seen that message numerous times over my career and,...
Part 8: Bringing DataOps to Power BI
DataOps Principle #8: Reflect I’m on a ship with no compass… that’s how I felt about our testing. Our team...
Part 7: Bringing DataOps to Power BI
DataOps Principle #3: Embrace Change Change is constant… and the Power BI team at Microsoft has taken this idea and...
Part 6: Bringing DataOps to Power BI
DataOps Principle #13: Simplicity We lacked consistency… a senior developer tells me this after he reviewed some of the Power...
Part 5: Bringing DataOps to Power BI
DataOps Principle #10: Orchestrate Let’s Orchestrate… If you have read Part 3 and Part 4 of this series, you’ve probably...
Part 4: Bringing DataOps to Power BI
DataOps Principle #15: Quality is Paramount Yep, I did it to myself… I thought I had fixed an issue in...
Part 3: Bringing DataOps to Power BI
DataOps Principle #11 – Make it reproducible I am panicked… it has been a long week at work and a...
Part 2: Bringing DataOps to Power BI
DataOps Principle #16 - Monitor for Quality and Performance Now before I talk about this principle, I would like to...
Bringing DataOps to Power BI
I need better equipment… I tell myself while trying to jog off the extra pounds I gained in 2020. The...