Most Active Speaker

John Kerski

John Kerski

Director, Client First Technologies

Washington, Washington, D.C., United States

Actions

John leverages his 10+ years of technical and government leadership experience to help Federal Agencies, and private sector clients utilize Microsoft products to their fullest potential. His certifications with Microsoft products offers customers a high rate of return when looking to invest in Microsoft solutions.

Awards

  • Most Active Speaker 2023

Area of Expertise

  • Information & Communications Technology

Topics

  • #Microsoft
  • Microsoft Power BI
  • Power Platform

Implementing Continuous Integration & Continuous Deployment for Power BI Semantic Models - Workshop

From version control to automated testing, applying DataOps principles to Power BI semantic models can be a challenge. In this session I show you how to overcome these challenges by using version control and building automated tests using free templates.

In the first half of the session, we'll introduce DataOps and then use Visual Studio Code and DAX Query View to build tests and run tests locally. I'll show techniques for quickly building tests for a data model and how to test schema/data drift.

In the second half of the session, I'll demonstrate how to commit the code to Azure DevOps and walk through a Continuous Integration pipeline. I'll cover Git terminology and how to extract metrics to evaluate your development process.

Session participants will also be provided free, open-source templates to use on their current or next Power BI project.

DAX Query View Testing Pattern

Are you struggling with managing issues in your semantic models/datasets? Would you like to conduct tests and easily share those tests with your team? In this session I show you a DAX Query View Testing Pattern. This pattern combines the new DAX Query View feature in Power BI Desktop and DataOps principles to help you improve project delivery and reduce errors.

Querying SharePoint Data in Power BI - Options & Performance

Do you rely on SharePoint data for building your Power BI reports? Do you find dataset refreshes with SharePoint are exceedingly slow? If so, in this session I offer a review of the ways to connect to SharePoint within Power BI and techniques to improve refresh times.

Bringing DataOps to Power BI Dataflows

Implementing DataOps in your project can be a challenge if you are working on Power BI dataflows. How do you institute version control and how do you automate the testing of your dataflows? In this session I'll cover key DataOps principles and how tools like Azure Functions, Event Hub, and PowerShell can make you build a more reliable data analytic pipeline with Power BI dataflows.

DataOps 102 – Bringing DataOps to Power BI

Are you interested in the practical application of DataOps within Power BI? In this session I’ll share lessons learned, best practices, and the free starter code to incorporate into your current or next project. And wait, there’s more! I will also demonstrate how to automatically build, test, and promote datasets and dataflows.

DataOps 101 – A Better Way to Develop and Deliver Data Analytics

Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.

Querying Power BI REST APIs within a Power BI Dataset

Would you like to build a Power BI dataset that could inventory your workspaces, reports, datasets, and refresh schedule? Would you'd like to query another dataset to import into your dataset? In this session I'll show you how to leverage an open-source custom connector that connects to Power BI's REST APIs to do just that.

Would you like to build a Power BI dataset that could inventory your workspaces, reports, datasets, and refresh schedule? Would you'd like to query another dataset to import into your dataset? In this session I'll show you how to leverage an open-source custom connector that connects to Power BI's REST APIs to do just that.

This session introduces the open-source Power Query Custom Data Connector for Power BI REST APIs (https://github.com/kerski/powerquery-connector-pbi-rest-api-commercial), how to use it in Power BI Desktop, and I provide you a free Power BI template to get started for your current or next Power BI project.

How to Weave DataOps into Microsoft Fabric

Are you looking at upgrading from Power BI Pro or Premium Per User to Fabric? Are you struggling with managing issues with datasets, dataflows, reports, and dashboards which reduces the time your project team has to build new products? Learn how DataOps can help you improve project delivery, reduce errors, and which features in Fabric weave DataOps principles into the platform.

In this session you will learn how DataOps can help you improve project delivery, reduce errors, and which features in Fabric weave DataOps principles into the platform.

Triangle Area SQL Server User Group (TriPASS) User group Sessionize Event Upcoming

August 2024

Microsoft TechCon365 DC 2024 Sessionize Event Upcoming

August 2024 Washington, Washington, D.C., United States

SQL Saturday Albany 2024 Sessionize Event Upcoming

August 2024 Albany, New York, United States

SQL Saturday Baton Rouge 2024 Sessionize Event Upcoming

July 2024 Baton Rouge, Louisiana, United States

Power BI Days DC User group Sessionize Event Upcoming

June 2024 Washington, Washington, D.C., United States

SQL Saturday RVA 2024 Sessionize Event

May 2024 Richmond, Virginia, United States

SQL Saturday Jacksonville #1068 Sessionize Event

May 2024 Jacksonville, Florida, United States

Community Days NJ Sessionize Event

April 2024 East Brunswick, New Jersey, United States

SQL Saturday Austin 2024 Sessionize Event

March 2024 Austin, Texas, United States

Power BI & Fabric Summit 2024 Sessionize Event

February 2024

SQL Saturday Atlanta 2024 - BI & Data Analytics Sessionize Event

February 2024 Alpharetta, Georgia, United States

SQLSaturday Denver 2023 Sessionize Event

September 2023 Denver, Colorado, United States

Microsoft 365 EduCon DC 2023 Sessionize Event

June 2023 Washington, Washington, D.C., United States

SQLBits 2023 - General Sessions Sessionize Event

March 2023 Newport, United Kingdom

Power BI Summit 2023 Sessionize Event

March 2023

John Kerski

Director, Client First Technologies

Washington, Washington, D.C., United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top