John Kerski's Blog

Making Your Power BI Teams More Analytic - Tracking Changes In the last article, I provided a detailed overview of...

Making Your Power BI Teams More Analytic - The Foundation Continuing this series, in order to make our teams more...

Making Your Power BI Teams More Analytic - Introduction You spend all day helping your customers be more analytic, so...

Hiring and Motivating Technical Polyglots in Data Analytics If you’re working with Microsoft Fabric and Power BI, chances are you...

Automated Testing for Broken Visuals - It’s a Team Sport Over the past few years, I’ve found the Microsoft Power...

Automated Testing for Broken Visuals with Microsoft Playwright and Azure DevOps In my previous article, I explained how to run...

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 Paginated Reports offer us the ability to generate near pixel-perfect exports of our reports...

I need better equipment… that was the first line of my first blog post back in July of 2021. My...

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) I’m honored to receive a Microsoft Most Valuable Professional (MVP) award this year. When I...

Weaving DataOps into Microsoft Fabric – Invoke-DQVTesting and Orchestration In my last article, I discussed how to automate testing on your...

Weaving DataOps into Microsoft Fabric – Invoke-DQVTesting If you are building tests in Power BI and automating those tests in Azure...

Weaving DataOps into Microsoft Fabric - Automating DAX Query View Testing Pattern with Azure DevOps In my last article, I...

Weaving DataOps into Microsoft Fabric - DAX Query View Testing Pattern The last three months of Power BI Desktop releases...

Part 35 – Commenting Power Query with Azure OpenAI Leveraging Artificial Intelligence (AI) to reduce cycle times. Over the past...

Revisiting Fabric: DataOps Principles in the Newest Microsoft Analytics Solution When Microsoft unveiled the Public Preview of Fabric in May,...

Bringing “Quality is Paramount” for Gen1 Dataflows Continuing from Part 33, where I introduced the polling method for implementing version...

Make It Reproducible… for Gen1 Dataflows While I look forward to all the new capabilities Gen2 dataflows offer, it may...

The Data Journey: Don’t Assume What Worked Last Week Will Work Today Microsoft technologies and application programming interfaces (APIs) are...

DataOps Principle #14 - Analytics is manufacturing Exciting developments are underway for Microsoft users, with the recent announcements of Power...

DataOps 101 on YouTube Over the past year during meetups and conferences, I have had the opportunity to introduce the...

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 Last week, there was a wave of awesome news that has come...

DataOps Principle #8 - Reflect As promised from Part 27, I said I would offer tips on pulling SharePoint verison...

DataOps Principle #8 - Reflect As I stated in Part 26 of this ever-growing series (a real journey), my colleagues,...

DataOps Principle #16 - Monitor Quality and Performance For many of us we live in an E3/G3 world.  So, what...

DataOps Principle #18 – Improve Cycle Times Late in September 2022, I had the chance to meet with Mathias Thierbach,...

DataOps Principle #16 - Monitor Quality and Performance Over the past year I’ve been leveraging Application Insights on my blog...

DataOps Principle #14: Analytics is Manufacturing “Let’s switch gears” We’ll take a break from talking about dataflows and turn attention...

DataOps Principle #10: Orchestration In my last two entries I explained a way to integrate Power BI dataflows into source...

DataOps Principle #15: Quality is Paramount In my last entry I explained how to update a dataflow in the Power...

DataOps Principle #4: It’s a team sport Despite the negativity and seedy underbelly that comes with social media, it does...

Bringing DataOps to Power BI on YouTube Earlier this year I began a project to put part of this blog...

Distractions, DataOps, and Documentation If you have read Part 1 of this series, you probably know that I like to...

DataOps Principle #1: Continually satisfy your customer It’s complicated… that’s how I would sum up my relationship with SharePoint. On...

DataOps Principle #9: Analytics is code (cont., cont.) I love Regular Expressions… but I’ve been told I may lean on...

DataOps Principle #9: Analytics is code (cont.) And now we address Challenge #2… In Part 14 I identified the challenge...

DataOps Principle #9: Analytics is code Now how did that get there?… A client asked me about a new column...

DataOps Principle #17: Reuse “Don’t lose it, reuse it!”… is a catchphrase from a popular show that my little one...

DataOps Principle #7: Reduce heroism “You saved the day!”… one of our clients told my teammate. We had attended a...

DataOps Principle #14: Analytics is Manufacturing (cont.) “Time is money”… Continuing our work from Part 10 we have the data...

DataOps Principle #14: Analytics is Manufacturing “Patience is a virtue”… I am not a patient person. Red lights at traffic...

DataOps Principle #8: Reflect (cont.) “What gets measured gets done”… I’ve seen that message numerous times over my career and,...

DataOps Principle #8: Reflect I’m on a ship with no compass… that’s how I felt about our testing. Our team...

DataOps Principle #3: Embrace Change Change is constant… and the Power BI team at Microsoft has taken this idea and...

DataOps Principle #13: Simplicity We lacked consistency… a senior developer tells me this after he reviewed some of the Power...

DataOps Principle #10: Orchestrate Let’s Orchestrate… If you have read Part 3 and Part 4 of this series, you’ve probably...

DataOps Principle #15: Quality is Paramount Yep, I did it to myself… I thought I had fixed an issue in...

DataOps Principle #11 – Make it reproducible I am panicked… it has been a long week at work and a...

DataOps Principle #16 - Monitor for Quality and Performance Now before I talk about this principle, I would like to...

I need better equipment… I tell myself while trying to jog off the extra pounds I gained in 2020. The...