Chicago, IL

Monday, September 26th 2022, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

WRK101 - A Beginner’s Guide to Power BI for SharePoint Users

NOTE: YOU WILL NEED A COMPUTER WITH THE LATEST VERSION OF POWER BI DESKTOP INSTALLED PRIOR TO WORKSHOP TIME. THIS IS A HANDS ON WORKSHOP. Need to create stunning dashboards from your SharePoint data? Yes you do! In this workshop, 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 Project reporting, so that you are able to use Power BI immediately for your needs.

Monday, September 26th 2022, 9:00 am

  • Daniel Christian

    Microsoft MVP and MCT

WRK108 - Microsoft Power Platform In A Day Workshop

With the Power Platform having been available for over 6 years, it is now an enterprise level, low code platform to build reports, apps, flows and chatbots. For the first time ever you can build your own solution and make it available for your 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. Join Daniel Christian, a Microsoft MVP, certified trainer and an early adopter of the Power Platform, as he walks you through how this Power Platform journey began and gives you a technical overview of Power Apps (Canvas and Model-Driven), Power Automate, Power BI and Power Virtual Agents. This workshop will comprise of several walk-through demos, stories with examples and even an interview with a surprise guest. Here is an overview of the workshop: · Power Apps ○ Canvas ○ Model-Driven ○ Portal · Power Automate ○ Flows ○ Robotic Process Automation · Power BI · Power Virtual Agents · Dataverse · Integration with Microsoft Teams · Cross platform integration · Soon to arrive features! So if you are someone who has heard about Power Platform and would like to get a better technical understanding on what the services have to offer, then you do not want to miss this workshop!

Tuesday, September 27th 2022, 9:00 am

  • Daniel Glenn

    Microsoft MVP
  • John White

    Microsoft MVP

WRK401 - Everything you wanted to know about Power BI (but were afraid to ask!)

Power BI is the gold standard for cloud based report delivery. It’s very approachable – you can get up and running with it in minutes, at the same time, it’s 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, in order to understand what to use when. Join John White (MVP) and Jason Himmelstein (MVP) for this all-day tutorial which will help to guide you through building a complete analytical solution, using all the features of Power BI. We will start from nothing, and create queries that import and integrate data from many different sources. You will also learn how to refresh data using the on-premises data gateway and the personal gateway to connect to existing on-premises data from a variety of sources. In addition, you will see an overview of the many other additional features available in Power BI. At the end of this seminar you will be ready to not only start using Power BI for your projects, but you will also understand which approach is best for different situations. Bring your questions, and we’ll do our best to answer them.

Wednesday, September 28th 2022, 9:50 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

CM101 - Unlocking SharePoint's Content with SharePoint Syntex and Power BI

In today's world, the ability to convert unstructured data from files like document scans and photos into actionable, structured data is key to unlocking a lot of organizational data. Office 365 Content Services provides some functionality that does this for you automatically. Most are not aware of this service's functionality nor it's long term importance. In this session, we'll take you through what SharePoint Content Services has to offer from a functionality and data perspective, what use cases are supported by this data, and how to mine the data using Power BI and Flow.

Wednesday, September 28th 2022, 9:50 am

  • Daniel Glenn

    Microsoft MVP

BI101 - Power BI Sharing - Your Options for Keeping Everyone Informed

Every organization is a data organization and you must collaborate on data to stay on track. Sharing insights from within Power BI will give you an advantage and help steer your organization in the right direction. However there are some pitfalls with sharing - if you don’t know your options and set proper governance, you could be on your way to a data breach or giving your private information to the competition. In this session, you will get a short introduction to Power BI and understand where data resides, why and how you should share with your colleagues and outside partners, and get a strategy for setting governance for your data. You will walk away with the outline of a governance plan, an understanding of your sharing options, and the sharing settings you should immediately turn off.

Wednesday, September 28th 2022, 11:30 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI102 - Your guide to understanding Power BI

Struggling to understand what Power BI choices are the right ones to make? Confused by the licensing so much that trying to make heads or tails of how to get your project started is a step too far to think of taking? Join us for this introduction to the wonderful world of Power BI. We will begin with understanding the real world decisions around licensing, discuss & demo the options for doing reporting, and finish with dashboards & sharing. If you are beginning your journey into the Power BI world, this is the session for you. We will set you up for success throughout the rest of the conference and help you look to drive your business using data.

Wednesday, September 28th 2022, 1:40 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI103 - Data Mining Office 365 & SharePoint with Power BI

See how to use Power BI to mine the data you have in SharePoint and Office 365. We’ll pull data from lists, libraries, triggered activities using Flow and from Search and create beautiful reports and dashboards easily from it. We’ll also show you how this can be automated and saves you time from copying and pasting data into different places.

Wednesday, September 28th 2022, 3:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI104 - Sharing PowerBI Reports with the World - 5 Things to Know

The Power BI Publish to Web feature is a powerful tool for sharing your reports with a wider audience. However, it brings with it a number of difficulties, challenges, and dangers. Before you use this capability, you should know when it is appropriate, what is possible, and how to design for it properly. This session will explore what the Publish to web feature is all about, and how you can take advantage of it effectively, and most importantly… safely.

Thursday, September 29th 2022, 8:30 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI201 - Managing Goal Status and OKRs using Power BI Goals and SharePoint

Greatly improve the speed of your decision making by using Power BI Goals and SharePoint together to get relevant information easily. This session will introduce the new Power BI Goals functionality, discuss what are Goals and Objective and Key Results(OKR) metrics, show you how to set up your metrics using data from SharePoint for automatic updating.

Thursday, September 29th 2022, 10:20 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI202 - Power BI Premium – When Do I Need It?

Power BI Premium is a way to get past many limitations of the shared Power BI service. However, with great power comes great responsibility. This session will outline exactly what Power BI Premium is, what features it unlocks and what limitations it changes. We will also call out situations where Premium may not be appropriate, and the steps that you need to take to ensure that you get the maximum value from it. If you’re considering a move to Power BI Premium, you’ll want to attend this session.

Thursday, September 29th 2022, 3:50 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI204 - There's No Time Like the Present - real time and low latency data in Power BI

Power BI has many options for keeping your data up to date, but what happens when scheduled refreshes simply aren't enough? What do you do when real time or near real time reporting on your data is necessary? Fortunately, Power BI has you covered here as well. From real-time datasets, to Direct Query and the Aggregations feature, there are more than a few options for accomplishing this goal, but they all do come with a few tradeoffs. This demonstration laden session will examine all of the techniques available to Power BI for reporting on your data in real time, highlight some of the things to watch out for, and how to design for them. If you need your data more up to date than what refresh schedules can provide, then this session is for you.

Friday, September 30th 2022, 9:00 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI301 - 5 Reasons you want Paginated Reports in your life

You're already familiar with Power BI and the Power BI Desktop PBIX files. These tools are great for analytical reporting, but when it comes to things like printing, and subscriptions, well, it falls a little short. That's where Paginated reports come in. Paginated reports draw upon the decades of experience in operational reporting from SQL Server Reporting Services, but they work in the Power BI service, enabling many new scenarios and opportunities. This demo-rich session will explain what paginated reports are all about, and demonstrate 5 reasons that you'll want to start using paginated reports immediately.

Friday, September 30th 2022, 10:20 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI302 - SharePoint, Teams and Power BI Integration Strategies

This session will highlight the rich functionality that you can bring to your business needs with the integration that is available between Power BI and Office 365 functionality. We'll discuss why you may want to integrate functionality and how to license for it. Demos will be: • Integrating Yammer, Forms, and Word into Power BI • Integrating Power BI into Office 365 Communications site, Sway, and into a Teams channel.

Friday, September 30th 2022, 12:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI303 - Deep Dive on Power BI and SharePoint

This demo rich session will explore many of the nuances involved with using a combination of Power BI and SharePoint. 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 and SharePoint, this session will show you how.