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.

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 611

Building a Modern Data Lake with OneLake: The OneDrive for Data

OneLake eliminates pervasive and chaotic data silos created by developers configuring their own isolated storage. OneLake provides a single, unified storage system for all developers. Unifying data across an organization and clouds becomes trivial.

With the OneLake data hub, users can easily explore and discover data to reuse, manage or gain insights. With business domains, different business units can work independently in a data mesh pattern, without the overhead of maintaining separate lakes.

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.