John Kerski's Blog

A blog about technology and more.

Commenting Power Query with Azure OpenAI

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 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...