Power BI, Git Integration & Azure DevOps, Implementing CI/CD for Power BI

Can BI development follow application development lifecycle? Answer is "YES!"

Power BI Deployment Pipelines help us achieve the "Deploy" part of the CI/CD life cycle in a manual way, but with Fabric the Git integration now makes it easy to use Azure Devops.
Versioning, automation of deployment can be achieved and enterprise BI teams can bring application lifecycle management to their power BI environments. The session will focus mainly on Power BI objects (reports, datasets) in the a Fabric workspace.

Agenda:
Understand Git Integration
Manage workspace with git
Deploy with Azure Devops

Type : Light on slides, heavy on demo

This session is perfect for those who are looking bring application life cycle management (ALM) to the their Power BI development space.

sessions@sqlbits.com.

Are you an admin overseeing multiple Power BI workspaces and grappling with the challenge of monitoring activities and performance across all of them in a unified view? This session is designed precisely for you. Join us as we delve into a comprehensive guide on how to streamline and optimize your Power BI environment using Azure Data Explorer (ADX) and Kusto Query Language (KQL).

In this session, we’ll kick off with a Introduction to Azure Data Explorer and Kusto, highlighting their roles and benefits in data management and analysis. You will get acquainted with ADX as a high-performance big data analytics platform that powers real-time dashboards and analytic applications.

Next, we’ll dive into the Basics of KQL (Kusto Query Language), the powerful query language used by Azure Data Explorer. Learn how to write and execute KQL queries, understand its syntax, and harness its capabilities for effective data manipulation and analysis.

We’ll then explore Kusto Dashboards, which provide an intuitive way to visualize your data. Discover how to create, customize, and share dashboards that offer deep insights into your Power BI environment.

We’ll also cover the crucial step of Linking your Log Analytics Workspace to Power BI for logs. This segment will walk you through configuring the Log Analytics workspace and connecting it to Power BI, enabling seamless integration and comprehensive log management.

Finally, we’ll demonstrate Using Log Data to Build Monitoring Dashboards. Leverage the data collected in your Log Analytics workspace to create detailed and informative monitoring dashboards in Power BI. Gain the ability to monitor performance metrics, track activity logs, and identify issues across multiple workspaces, all within a single, cohesive interface.

By the end of this session, you will have the knowledge and tools to efficiently monitor and manage multiple Power BI workspaces, ensuring optimal performance and streamlined administration. Whether you’re a seasoned Power BI admin or new to the platform, this session will provide valuable insights and practical techniques to enhance your monitoring capabilities.

Are you an Admin for multiple Power BI workspaces and need to monitor the activity and performance all in one place? Then this session is for you.
Agenda -
Introduction to Azure Data Explorer/Kusto
Basics of KQL
Kusto Dashboards
Linking Log Analytics Workspace to Power BI for logs
Using the log data to build monitoring dashboards

Git Integration and Azure DevOps for Power BI - Implementing CI/CD

Can BI development follow application development lifecycle? Answer is "YES!" Power BI Deployment Pipelines help us achieve the "Deploy" part of the CI/CD life cycle in a manual way, but with Fabric the Git integration now makes it easy to use Azure Devops. Versioning, automation of deployment can be achieved and enterprise BI teams can bring application lifecycle management to their power BI environments. The session will focus mainly on Power BI objects (reports, datasets) in the a Fabric workspace. Agenda: Understand Git Integration Manage workspace with git Test & Deploy Type : Light on slides, heavy on demo This session is perfect for those who are looking bring application life cycle management (ALM) to the their Power BI development space.

Getting started with Power BI Deployment Pipelines

If you are wondering, "Is CI/CD possible in Power BI?" , the answer is YES! and this can be achieved with "Deployment Pipelines"

With Deployment Pipelines, its now possible to move content smoothly from Development/Test to QA to Production, helping enterprise BI teams bring application lifecycle management to their power BI environments.
Understand deployment pipelines
Create a deployment pipeline
Deploy content with rules
Comparing Content
Move content from one stage to next

Wrangle data in Power BI with Power Query Editor

If you are wondering, "I don't know Power Query M, but can I still wrangle my data?" , the answer is yes! Power Query Editor in Power BI Desktop has several options to wrangle your data with little expertise on Power Query M. This session will cover and introduction to Power Query Editor and a demo on how to profile, clean, prepare & enrich data in Power Query Editor.
Profile data : Understand your data
Clean data : Find and replace, drop fields not required, remove outliers
Prep/enrich data : add/compute new fields, structure your data, merge datasets
Type : Light on slides, heavy on demo
This session is perfect for those who want to get started with using Power Query Editor for wrangling data.

Getting started with Power BI Desktop

Getting started with Power BI Desktop will introduce Power BI, it’s various components and then do a deep dive into Power BI Desktop with a demo. The demo will walk through the steps of building a report, by connecting to a data source and adding charts and others important components of a Power BI report and close with audience questions. This session is perfect for Power BI beginners and for those looking to get their feet wet in Power BI.