Monday 9:00 AM - 5:00 PM · Room A404

Power BI Bootcamp for SharePoint Professionals

NOTE: YOU WILL NEED A COMPUTER WITH THE LATEST VERSION OF POWER BI DESKTOP INSTALLED PRIOR TO WORKSHOP TIME. THIS IS A HANDS ON BOOTCAMP.

Need to create stunning dashboards from your SharePoint data?

Yes you do!

In this bootcamp, we’ll show you: • How should I approach my BI need? • What things should be considered when creating dashboards? • What are the best practices? • How much is this going to cost me to license? • What security aspects should concern me?

Who should take this course: If your company uses Office 365 or SharePoint 2013/2016 and you are a: • Manager • Business Analyst • Power User • SharePoint Administrator • Consultant

If you work in these areas, you will see value: • Marketing • Information Technology • Finance • Sales • Social Media

The class assumes no prior knowledge of Power BI and Data Concepts.

What is required for this class: Install Microsoft Power BI Desktop on your laptop (recommended but not required) We'll provide an Office 365 site for you to use for exercises

In this workshop you will: • Learn how to create Production Dashboards using Power BI, from SharePoint list and document library data • How to use Power BI in a multitude of situations, including ad hoc analysis and the creation of formal dashboard. • Learn the Power BI components: Power BI Desktop, PowerBI.com, Power BI mobile applications and how they can be used with Office 365 and SharePoint • Receive an introduction into the core functions of Power BI; Data extraction, loading and transformation using Power Query Formula Language (“M”) and DAX. • Receive some guidelines on how to extract Project data in fast manner. • Discover some data modeling practices that will ensure you have maximum flexibility in analysis. You'll also learn some visualization best practices to ensure you can tell your digital story effectively • Learn best practices for maintaining content with your organization

This workshop provides an end to end view of Power BI for SharePoint reporting, so that you are able to use Power BI immediately for your needs.

Tuesday 9:00 AM - 5:00 PM · Room A403

Everything You Wanted to Know About Microsoft Fabric and Power BI, But Were Afraid to Ask.

"Everything You Wanted to Know About Fabric and Power BI" is an intensive, full-day tutorial designed to equip participants with a comprehensive understanding of Microsoft Fabric which includes. This tutorial delves into the core functionalities and advanced features of the platform, enabling attendees to harness its full potential for their organizational needs.

Participants will explore the robust capabilities of Microsoft Fabric, including its seamless integration with various Microsoft services, advanced data management, and analytics tools. The tutorial covers essential topics such as creating and managing fabric instances, deploying and configuring Fabric applications, and utilizing built-in security and compliance features to ensure data integrity and privacy.

The session is structured to cater to a diverse audience, from IT professionals and data analysts to software developers and business managers. Through interactive demonstrations, real-world scenarios, and practical exercises, attendees will gain practical skills and insights to effectively implement and manage Microsoft Fabric in their respective environments.

By the end of the day, participants will have a solid foundation in Microsoft Fabric, empowering them to drive innovation, enhance productivity, and achieve their business objectives with confidence.

Tuesday 9:00 AM - 12:30 PM · Room A315

Beginners Guide to Power BI Workshop

This session will provide you with the knowledge that you need to quickly become productive using Power BI.

You will be introduced to:

• Power BI licensing
• Power BI Components
• Using the Power BI Desktop app
• Using the Power BI Service
• How to create reports and dashboards
• DAX and Visual Calculations
• PowerPoint integration
• SharePoint integration
• Learning Resources

Don't have a Power BI license? You can start using Power BI for free!

Attend this demo-rich session and get started with Power BI!

Wednesday 10:20 AM - 11:30 AM · Room A312

Beginners Guide to Power BI

This session will provide you with the knowledge that you need to quickly become productive using Power BI.

You will be introduced to:

• Power BI licensing
• Power BI Components
• Using the Power BI Desktop app
• Using the Power BI Service
• DAX and Visual Calculations
• PowerPoint integration
• SharePoint integration
• How to create reports and dashboards
• Learning Resources

Don't have a Power BI license? You can start using Power BI for free!

Attend this demo-rich session and get started with Power BI!

Wednesday 11:40 AM - 12:50 PM · Room A312

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.

Wednesday 2:00 PM - 3:10 PM · Room A312

I want it NOW! The impact of Real Time Intelligence in Microsoft Fabric on Power BI

Power BI has always provided a rich set of tools for analyzing data at rest. For data in motion, there are approaches to help reduce or eliminate data latency, but many of them require tradeoffs. The Real Time Intelligence (RTI) workload within Microsoft is designed to meet this challenge. RTI is focused on monitoring with near zero data latency to address the needs of data in Motion.

In this session we will demonstrate a real world scenario which will relate to everyone - pulling data from home automation systems including security, thermostats, entertainment, lighting and weather. We will stream all of thise signals into an eventhouse using event streams, and monitor this data with real time dashboards.

Real Time Intelligence is a new paradigm, and does for data in motion what Power BI does for data at rest. If you have data monitoring needs, this session is for you.

Wednesday 4:00 PM - 5:10 PM · Room A316

Creating a Cohesive Brand Identity in Microsoft 365 and Power Platform

Branding is essential for creating a cohesive image across your organization, improving user experience, increasing engagement, building trust in custom solutions, and reinforcing your organization’s identity.

Microsoft 365 offers various branding capabilities through the new Brand Center, Organizational Settings, and themes in the Power Platform to help you achieve brand cohesion.

This session will provide a comprehensive overview of these tools and demonstrate how to use them to enhance your brand’s presence and consistency.

We'll explore the SharePoint Brand Center, a centralized application that allows you to manage and deploy your organization’s brand assets seamlessly. You’ll learn how to use custom fonts, images, logos, colors, templates, and site themes across Microsoft 365 to ensure a unified look and feel. Finally, we'll demo themes in the Power Platform, showcasing how to create branded apps and workflows that reflect your organization’s identity backed by user experience better practices.

Thursday 9:00 AM - 10:10 AM · Room A312

DAX the Easy Way: Visual Calculations in Power BI

Visual calculations empower even novice Power BI users to build new calculations from any visual inside Power BI using an Excel grid-like interface. If you can write an Excel formula, you can create DAX expressions using visual calculations.

Many new Power BI users struggle to write and create DAX calculations. Even many calculations that are more complex when writing DAX expressions can easily be created using visual calculations. For example running sums, moving averages and percent of grand totals, and more are quick and easy using the Excel-like interface.

Attend this session and take you Power BI reports to the next level using visual calculations.

Thursday 10:50 AM - 12:00 PM · Room A312

Power BI Power Hour of Tips and Tricks

In this session, you'll learn from the panel our favorite tips and tricks that you can use to make your reporting solutions amazing.

Thursday 1:00 PM - 2:10 PM · Room A312

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.

Thursday 2:20 PM - 3:30 PM · Room A312

Power BI monitoring with Log Analytics Workspace

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.

Thursday 4:10 PM - 5:20 PM · Room A312

Deep Dive on Microsoft Fabric, Power BI, Teams and SharePoint

Microsoft Teams, SharePoint and Power BI can be tightly integrated within Microsoft Fabric. SharePoint can be a data source (lists), a container for data files (Excel. CSV etc in libraries), and as a dashboarding platform (pages). Teams can be a complete front end for reports, and host content contextually. Fabric can take your SharePoint data to new heights altogether.

This demo rich session will explore all of these scenarios in great depth. SharePoint data can be finicky to retrieve, and this session will show examples and suggest a few best practices for doing so. In addition, connecting Fabric to SharePoint opens up a whole new world for Excel.

Friday 9:00 AM - 10:10 AM · Room A312

What are Power BI Metrics?

In this session, you'll learn about Power BI Metrics and how they can be used in your organization to track the metrics that matter to you.

You'll learn about:

1. Scorecards
2. Goals
3. Check-ins
4. Target and Current values

Friday 10:20 AM - 11:30 AM · Room A312

Bring Your SharePoint Data to Life Using Power BI!

Power BI can transform how your users see and interact with your SharePoint data! In this session, you'll learn tips, tricks and best practices for using SharePoint with Power BI. We'll start by discussing the "out of the box" SharePoint list integration with Power BI and Power BI licensing. Then we'll move on to importing list data into Power BI and transforming that data. Finally, we'll create and publish a Power BI report and embed that report on a SharePoint page.

Attend this session and see how Power BI can bring you SharePoint data to life!

Friday 10:20 AM - 11:30 AM · Room A313

Discover the Full Potential of Microsoft Lists with Power Platform

Microsoft Lists, a core component of Microsoft 365, has been significantly enhanced through its integration with the Power Platform. In this session, we will examine three fundamental features of the Power Platform embedded within Microsoft Lists. Together, we'll explore the baked in options for the following:

Power Apps: Form Options Comparison

• Create an App: Build a canvas app directly connected to a List
• Customize Forms: Integrate Power Apps into a native List form

Power Automate: Streamline Processes with Pre-built Flows

• Content Approval: Navigate page approval processes effortlessly.
• Request Sign-off: Simplify decision-making with streamlined audit trail
• Reminder Options: Specify a date for task follow-ups

Power BI: Unlocking Insights from Data

• Visualize Lists: Quickly transform data into compelling visual narrative
• Microsoft List as a Data Source: Create refreshable reports connected directly to List data

Live demos throughout the session will illustrate practical implementations of these tools. Additionally, we'll address the pivotal question of when organizations may outgrow integrated options, along with essential licensing considerations for scaling up to advanced solutions.

Friday 12:30 PM - 1:40 PM · Room A312

Leveraging Large Language Models with Power BI

Large Language Models, like ChatGPT, have the potential to transform how you develop and deliver Power BI solutions. In this session, you'll learn how to integrate Azure OpenAI and GitHub Copilot into your Power BI development process, leveraging prompt engineering techniques to improve your solutions.

Friday 1:50 PM - 3:00 PM · Room A312

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.