Dallas, Texas

Business Intelligence Track

Monday, August 8th 2022, 9:00 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

WRK106 - 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.

Tuesday, August 9th 2022, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

WRK401 - 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.

Wednesday, August 10th 2022, 9:50 am

  • Liz Sundet

    Program Manager at Microsoft

BI101 - Getting started learning Power BI

You've heard people say Power BI is awesome. You've seen lots of reports and think, wow, I wish I could produce that. Or, maybe you're just curious what all the fuss is about. Come learn where to get started with PowerBI from the vocabulary to how to connect data together. We will cover the basics as well as creating dynamic reports that will be sure to impress any executive.

Wednesday, August 10th 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, August 10th 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, August 10th 2022, 1:40 pm

  • Geetha Sivasailam

    Microsoft MVP

PWR103 - Power BI + Power Apps + Power Automate = Better Together

Want to amplify actionable data insights and accelerate better decision making? Then this session is for you where we'll look at how organizations can benefit from the exciting possibilities of using Power BI, Power Apps and Power Automate together. We will walk through best practices, things you should know to take full advantage of the tools and real-life examples. Learn how you can seamlessly combine data visuals on Power BI dashboards with an added layer of apps and cloud flows to enable write-back capabilities and integration with numerous back end services.

Wednesday, August 10th 2022, 3:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI104 - 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.

Thursday, August 11th 2022, 9:00 am

  • Luc Labelle

    Microsoft MVP and MCT

BI201 - Build smarter Power Platform solutions using Artificial Intelligence

Embed AI capabilities in your Power Apps, Microsoft Flow and Power BI solutions and let Artificial Intelligence do the work for you. Join us in this session and learn how to leverage AI capabilities from Power Platform solutions. We will demonstrate how AI can help you and your organization save time and money by augmenting simple applications and processes. In this session we will work with simple use cases, based on real business requirements that all attendee can relate to.

Thursday, August 11th 2022, 1:20 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI203 - Best practices for using Power BI and Paginated Reports

Now that Paginated Reported (what we used to call SSRS reports) are available in the Power BI service, numerous questions arise as to when to use which report type. Each type has a different design goal, with different strengths and weaknesses and it is important to know what they are. The fact that both now exist in the Power BI service and well as on premises leads to some interesting opportunities for synergy. This session will dive deep on how both types of reports work, and what's needed to get the most out of them. It will also demonstrate cases that call for either type, and identify when the use of both is appropriate. If you are a Power BI user that wants to do reporting AND analytics, this is a session for you.

Thursday, August 11th 2022, 2:40 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI204 - 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.

Thursday, August 11th 2022, 4:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI205 - 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, August 12th 2022, 9:00 am

  • Luc Labelle

    Microsoft MVP and MCT

BI301 - Self-service data preparation with Dataflows

As data volume continues to grow, so does the challenge of wrangling that data into well-formed, actionable information. Most organisations want data that’s ready for analytics, to populate visuals, reports, and dashboards, so that they can quickly turn volumes of data into actionable insights. Join us in this session and learn how to use Dataflow to ingest, transform, integrate, and enrich your data by defining data source connections, ETL logic and refresh schedules.

Friday, August 12th 2022, 10:20 am

  • Daniel Glenn

    Microsoft MVP

BI302 - 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.

Friday, August 12th 2022, 12:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

BI303 - 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.

Friday, August 12th 2022, 1:50 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS and MBA

BI304 - Unlocking SharePoint’s Content Services data 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.