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

Power Platform Copilot In A Day

Power Platform is Microsoft's low-code, cloud-based service to turn ideas into impactful, end-to-end services. With the Power Platform having been available for over 10 years, it is now an enterprise level, low code platform to build reports, apps, flows, chatbots and websites. For the first time ever you can build your own solution and make it available for you company users. This skill of building professional low code apps is in such high demand that makers have successfully made a career out of it.

However, in the last year Microsoft has infused AI Copilot into all their cloud services and this change has affected Power Platform as well, some might say, more so than other services. Hence join Daniel Christian, a Microsoft MVP and certified trainer as he gives you a good overview of the Power Platform family in a day including all the AI Copilot features plus the changes coming to two of their services.

Monday 9:00 AM - 5:00 PM · Room 613:614

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 619:620

Everything You Wanted to Know About Power BI... but were afraid to ask!

Power BI is the gold standard for cloud-based report delivery, and forms the reporting component of Microsoft Fabric. It's very approachable - you can get up and running with it in minutes, but it's also very robust, secure and extensible. As you might expect, it has many pieces and nuances, and it's important to understand what is possible, even if you may not take immediate advantage of some features, to understand what to use when. This all day tutorial will explore the way that Power BI works, and what it can do. We will walk through its architecture, the Power BI web service, Power BI Desktop and how it works with Microsoft Excel. Then we focus on the relationship with SharePoint, what can be done in an on premises or hybrid environment and how to connect it and refresh it with all sorts of data. Finally, we will cover off how it is licensed, and a whole host of other miscellaneous topics including how it works on its own, and within Microsoft Fabric. This tutorial consists of a mix of theory and demonstrations, with emphasis on the demonstrations using real world data. It is designed for the beginner and the novice user, but even advanced users will find some nuggets of new information. Power BI is a fast moving, and ever-changing product, and this tutorial is constantly updated to reflect that. Above all we encourage questions and dialog. We can't answer your questions if you don't bring them, so please come armed! Feel free to even bring us data and we can work through any reporting challenges that you may have. If you want to get exposed to Power BI & Microsoft Fabric, this is certainly a session for you.

Tuesday 1:30 PM - 5:00 PM · Room 607

Half-Day Workshop : Power Platform Governance 101

Effective governance policies play a big role in the successful roll-out of the Power Platform across the organization and running it on a scale. In this half-day workshop, we will cover the key principles of Power Platform Governance, the tools available at our disposal, and how to use those. The governance policies will include Power Automate, Power Apps, Power Virtual Agents, Power Pages, Dataverse, and Power BI.

In this demo-driven workshop, we will cover,

1. Power Platform Governance Overview
2. Center of Excellence ( CoE ) Starter Kit
3. Managed Environments
4. How to use Co-Pilot for governance?
5. Automation Kit
6. Data Loss Prevention policies
7. User Management
8. Permission manager
9. License and capacity management
10. Security and Control
11. Best Practices

At the end of the workshop, attendees will have a working knowledge of how to implement Governance in Power Platform.

Wednesday 11:30 AM - 12:40 PM · Room 619:620

Exploring the Future of Microsoft Analytics with Microsoft Fabric

In today's world getting true data driven insights can take a lot of time and energy. Data is spread across a wide variety of storage systems, all of which can have different operating models, security models and integration requirements. The next generation of Microsoft's data platform, which includes Power BI aims to solve this problem.

Come to this session to explore some exciting new announcements from Microsoft, understand exactly what they mean, and how they can help position your organization for the new age of AI.

Wednesday 3:40 PM - 4:50 PM · Room 615:616

Transform Your Power BI Data in Microsoft Fabric

If you've worked at all with Power BI, you're familiar with Power Query - the built in data transformation engine. Power Query connects to hundreds of different data sources and allows you to powerfully transform your data before loading it into a data set.

While very powerful, this model can be a little limiting at times. What if you wanted to use the connectivity and flexibility of Power Query to load data into other date destinations? What if Power Query doesn't quite do what you want? What if you want to use alternate languages like Python to do your transformations? All of these things are possible in the context of Microsoft Fabric.

This session takes a look at these new options through the eyes of a Power BI professional. We'll examine Gen2 dataflows, Pipelines (from Data Factory), Jupyter Notebooks running Python against Lakehouse data, and Eventstreams. There is a whole new world of options available for data transformation in Microsoft Fabric, and this session will give you a taste of them.

Thursday 10:30 AM - 11:40 AM · Room 609

Unlocking insights with Power BI Copilot

Join us for an immersive session on getting started with Power BI Copilot, your trusted companion for data exploration and insights generation.

In this session, we'll delve into the innovative features and functionalities of Power BI Copilot, empowering you to streamline your data analysis workflow and uncover actionable insights with ease.

Learn how to leverage Copilot's advanced AI capabilities to uncover answers to your data questions, generate meaningful report pages, and drive informed decision-making within your organization.

This session will equip you with the knowledge and skills to harness the power of Copilot and elevate your analytics game to new heights.

Thursday 12:40 PM - 1:50 PM · Room 619:620

Deep Dive on Power BI, Teams and SharePoint

Microsoft Teams, SharePoint and Power BI can work very well together. 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 Power BI, and host content contextually.

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 Power BI to SharePoint opens up a whole new world for Excel. If it can be done with Power BI, SharePoint and Teams, this session will show you how.

Thursday 2:00 PM - 3:10 PM · Room 619:620

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

Thursday 3:50 PM - 5:00 PM · Room 619:620

Source Control with Power BI and Microsoft Fabric

The wait is over. It is now possible to integrate both Power BI Desktop and Microsoft Fabric workspaces with GIT repositories to provide a full set of CI/CD capabilities for Power BI reports.

This session will cover exactly how this works so that you can begin to take advantage of this capability now. We'll cover what is possible, and what is currently not possible, and explain the difference between the GIT integration in Power BI Desktop, and in Microsoft Fabric workspace.

If you're part of a team that works with Power BI, you won't want to miss this.

Friday 9:00 AM - 10:10 AM · Room 619:620

Driving Productivity and a Data-Driven culture with Power BI in Microsoft 365

Learn how to make your organization more productive and foster a data-driven culture by seamlessly and securely flowing insights into Microsoft 365.

You’ll learn how everyone in your organization can collaborate faster, analyze better, and present more clearly by using Power BI. We’ll cover all the new Power BI capabilities in Microsoft Teams, SharePoint, PowerPoint, and more.

If you’re trying to make an impact to improve productivity across entire workforce, this session is for you.

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

From SQL Developer to Business Analyst: Harnessing Fabric's Innovations

Data warehouse in Fabric is made for developers of any skillset. Learn how to take advantage of the newest innovations and developer experiences whether you are a SQL developer or a business analyst.

In this session we’ll provide an overview of capabilities, share best practices and enable you to use Fabric to power your analytical use cases from enterprise reporting to self service BI - and easily manage it in production.