Washington, D.C. [email protected]

Business Intelligence Track

Saturday, May 8th 2021, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA

WRK201 - 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. Level: Introductory

Saturday, May 8th 2021, 1:30 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA

WRK301 - Power BI for SharePoint Users Deep Dive

NOTE: The workshop assumes you have a working knowledge of Power BI and Data Concepts. This is intended as a hands on class. A PC with Power BI Desktop installed is required to get the most out of it. However, you are welcome to attend if you simply want an overview of advanced Power BI techniques. Now that you’ve attended my morning workshop and understand the basics of Power BI for SharePoint Users, we’ll go deeper into what you need to deliver professional looking reports and dashboards. This half day workshop will be spent on learning tips and techniques from the pros on delivering Power BI based apps that are easy to use and are maintainable. In this workshop users will learn: • 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 visualization best practices to ensure you can tell your digital story effectively • Learn best practices for maintaining content with your organization Who should take this course: If your company uses Office 365 or SharePoint 2013/2016 and you are either 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

Sunday, May 9th 2021, 9:00 am

  • Jason Himmelstein

    Microsoft MVP
  • John White

    Microsoft MVP

WRK403 - 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, 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, in order to understand what to use when. This tutorial will help to guide you in 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 the many other additional features available in Power BI. In particular, we cover the Power BI Service, Power BI Desktop, Connecting to data, modelling data, hybrid options, Licensing, on-Premises options, and we pay particular attention to using Power BI with SharePoint, both as a data source and a container. 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. This is a highly dynamic tutorial, and can go in any direction that you like.

Monday, May 10th 2021, 9:40 am

  • Liz Sundet

    Microsoft Premier Field Engineer for SharePoint 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.

Monday, May 10th 2021, 11:20 am

  • Jason Himmelstein

    Microsoft MVP
  • 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.

Monday, May 10th 2021, 1:30 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, 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.

Monday, May 10th 2021, 3:00 pm

  • Daniel Glenn

    Microsoft MVP

PWR104 - Use Your On-premises Data with Power Apps, Power BI, and Power Automate (Flow)

Microsoft Power BI, Power Automate (Flow) and Power Apps are powerful cloud tools that can take your on-premises data, stored in systems like SQL and SharePoint, to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy. In this session, we will discuss the benefits of using the cloud tools and how workflow, analytics, and business apps can utilize your on-premises data. We will setup a data gateway, connect to on-premises data sources, and discuss how to use that data in Office 365 to create rich business solutions. You will walk-away from this session with the knowledge you need to immediately start using your on-premises data with Office 365.

Monday, May 10th 2021, 3:00 pm

  • Jason Himmelstein

    Microsoft MVP
  • John White

    Microsoft MVP

BI104 - Hybrid Business Intelligence – Yes, You can do that

Is your organization staying on premises due to data concerns? Are you moving full speed ahead into the cloud, but longing for the maturity of your on-premises Business Intelligence platform? Hybrid Business Intelligence may be just what you are looking for. Microsoft has a rich stack of BI solutions for both on-prem and the cloud that all bring different strengths to the table. The good new is that with hybrid, you don’t need to sacrifice one for the other.   Join us for an overview of how to extend on premises BI technologies to the cloud and bring cloud solutions on-prem.  We'll be talking about a wide variety of tools including SQL Server Reporting Services, Power BI, Power BI Report Server, SharePoint (both on-premises and in the cloud), Flow and Power Apps.

Monday, May 10th 2021, 4:20 pm

  • David Feldman

    Microsoft MVP

BI105 - PowerBI Beyond the Basics

You are familiar with PowerBI desktop, you’ve pulled in some data from SharePoint, from SQL Server, or from excel and published it to the service. It’s pretty amazing, right? Now that you have the basics down, lets dive a bit deeper into all levels of the service. We’ll explore transforming your data and mashing up multiple sources in a PowerBI Desktop, we’ll integrate some onprem data, create drill downs, and explore some powerful data filtering techniques to help you take your PowerBI to the next level.

Tuesday, May 11th 2021, 10:30 am

  • Fabian Williams

    Microsoft MVP

AZR201 - Getting started with Machine Learning in Azure

We live in an era where data proliferates, and because of that we can use algorithms to help us both classify and predict future decisions based on past interactions. In this introductory session we will look at Azure Machine Learning (AzureML) both in the Azure Portal and locally in a development environment using both Visual Studio Code and Jupyter notebooks. We will cover data manipulation techniques using typical libraries such as NumPy and Pandas (dont know what those are... dont worry, you will) and we will see a few simple techniques that will open your eyes as to how you can use data in your own organization to bring machine learning in and have a better decision making process. Demos will showcase full end to end completed solutions walk throughs for both classification and predication scenarios.

Tuesday, May 11th 2021, 10:30 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA

BI201 - Unlocking SharePoint's Content Services Data with 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.

Tuesday, May 11th 2021, 1:20 pm

  • Jason Himmelstein

    Microsoft MVP

BI202 - Telling data stories with Power BI

Struggling to make your data tell the story that you know is hiding in there? Sick of staring at static spreadsheets and wishing that there was a way to visualize things so that the data could speak for itself? Are you tired of doing the same analytical motions over & over again instead of being able to use a repeatable process that will give you time back to do your actual job? Welcome to the wonderful world of Power BI where all of these things are achievable. In this session you will learn powerful ways of making your data come to life using Power BI Desktop & the Power BI Service. Whether your data is stored in a Microsofty way in Excel, SQL Server, SharePoint Online lists, CSV files on some old file server or in 3rd party data sources like SalesForce, Oracle, or SAP you will learn to unlock the data within & bring to life the stories hidden in the data.

Tuesday, May 11th 2021, 2:40 pm

  • John White

    Microsoft MVP

BI203 - A Place for Our Stuff - Introduction to Power BI Dataflows

Dataflows are doing to data warehousing what Power BI has been doing for several year to reporting - making it ubiquitous and accessible. This session will walk through what dataflows in Power BI are, why they matter, how they're built, and why they are important. We'll also talk a fair bit about some tips and trick when working with them using demonstrations to illustrate the points.

Wednesday, May 12th 2021, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA

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

Wednesday, May 12th 2021, 10:40 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.

Wednesday, May 12th 2021, 1:00 pm

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

Wednesday, May 12th 2021, 2:20 pm

  • Fabian Williams

    Microsoft MVP

AZR304 - Build an Azure Machine Learning Model: Test, Deploy and Consume

In this session we will use both local and cloud development techniques using Pyhon 3, Jupyter notebooks locally to prepare data, set up a Workplace in Azure and connect locally, set up compute and conduct experiments. At the end you will have an endpoint that has been trained on your own data and consumable as a web service to anyone.