Monday, December 9th 2019, 9:00 am

  • Treb Gatte

    Microsoft MVP, MBA

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

NOTE: 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 what Power BI can do for you. Are you new to Power BI? Are you a SharePoint Administrator or SharePoint Power User? Are you tired of copying and pasting data from SharePoint to create reports and dashboards over and over again? We’ll take you through the basics of using Power BI with SharePoint data. You’ll say good bye to copy/paste once and for all. Whether you are using On-Premises SharePoint or SharePoint Online in Office 365, come to this workshop to learn essential skills every SharePoint user should know about Power BI.. Attendees will learn: • Learn the Power BI components: o Power BI Desktop o PowerBI.com o Power BI mobile applications o Learn how these components can be used with Office 365 and SharePoint • Receive an introduction into the core functions of Power BI o Data extraction from SharePoint o Loading and transformation using Power Query M o Extending your data with DAX • Report basics • Publishing and distribution basics 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 The class assumes no prior knowledge of Power BI and Data

Monday, December 9th 2019, 1:30 pm

  • Treb Gatte

    Microsoft MVP, 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

Tuesday, December 10th 2019, 9:00 am

  • Jason Himmelstein

    Microsoft MVP
  • John White

    Microsoft MVP

WRK403 - POWER BI: EVERYTHING YOU WANTED TO KNOW (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 workshop 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.

Wednesday, December 11th 2019, 9:40 am

  • Liz Sundet

    Premier Field Engineer 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, December 11th 2019, 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.

Wednesday, December 11th 2019, 1:30 pm

  • John White

    Microsoft MVP

BI103 - Taking the Next Step with Big Data and Power BI

You've come a long way with Power BI. You've tamed your Excel spreadmarts, you've got your SharePoint list reporting under control, and Power BI is doing a great job reporting on your SQL data, but you're interested in taking that next big step into the world of Big Data. The good news is that Power BI is your friend, but where do the various Big Data tools fit in this scenario, and where do you start? Join us for this hour long session as we go through the thinking behind the ongoing journey of tyGraph as it transitions to more Big Data technologies like Azure Data Factory, Spark, Databricks, etc.

Wednesday, December 11th 2019, 3:00 pm

  • Treb Gatte

    Microsoft MVP, MBA

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

Thursday, December 12th 2019, 10:30 am

  • Daniel Glenn

    Microsoft MVP

BI201 - Gaining insights with Power BI

Power BI is a powerful self-service analysis tool and is being adopted by organizations across the globe to quickly gain meaningful business insights. This session will cover the basics on creating compelling dashboards and guide you through the process of managing your company’s Power BI service, Power BI desktop, and mobile apps.

Thursday, December 12th 2019, 1:20 pm

  • Jason Himmelstein

    Microsoft MVP
  • John White

    Microsoft MVP

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

Power BI Dedicated Capacity (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, December 12th 2019, 2:40 pm

  • Treb Gatte

    Microsoft MVP, MBA

BI203 - Five Key Trends in Business Intelligence and How They Will Impact Your Organization

Is your organization ready for the third BI wave? There are five key trends in Business Intelligence that are dramatically changing the way we approach reporting. Join Treb as he takes you through each trend, the challenges resulting from the trend and recommended actions to take.

Thursday, December 12th 2019, 4:20 pm

  • Jason Himmelstein

    Microsoft MVP
  • John White

    Microsoft MVP

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

Friday, December 13th 2019, 9:00 am

  • Jason Himmelstein

    Microsoft MVP

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

Friday, December 13th 2019, 10:40 am

  • Treb Gatte

    Microsoft MVP, MBA

BI302 - Power BI Report Server: Self-Service BI and Enterprise Reporting On-Premises

Love Power BI but need an on-premises solution today? Meet Power BI Report Server -- self-service analytics and enterprise reporting, all in one on-premises solution. Design beautiful, interactive reports in Power BI Desktop, publish them to Power BI Report Server, and view and interact with them in your web browser or the Power BI app on your phone. And since Power BI Report Server includes the proven enterprise reporting capabilities of SQL Server Reporting Services, it can even run your existing Reporting Services reports too. Join us for an overview of Power BI Report Server and demos of its features in action.

Friday, December 13th 2019, 1:00 pm

  • John White

    Microsoft MVP

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

Friday, December 13th 2019, 2:20 pm

  • Daniel Glenn

    Microsoft MVP
  • Jason Himmelstein

    Microsoft MVP
  • John White

    Microsoft MVP
  • Knut Relbe-Moe

    Microsoft MVP, MCT
  • Liz Sundet

    Premier Field Engineer at Microsoft
  • Paul Stork

    Microsoft MVP, MCM, MBA
  • Sarah Haase

    Microsoft MVP, MLIS
  • Scott Shearer

    Microsoft MVP

SPT304 - Power Platform Panel

Power BI, PowerApps, and Microsoft Flow are designed to work together. Hear from the experts on the Power Platform and get your questions answered. Moderated by Scott Shearer. You can submit your questions to the panel ahead of time via the Q&A feature on the app.

Friday, December 13th 2019, 3:40 pm

  • Bob German

    Partner Technical Architect at Microsoft
  • Bobby Chang

    Office 365 Collaboration Technology Specialist at Microsoft, PMP
  • Craig Jahnke

    Premier Field Engineer at Microsoft
  • Frank Migacz

    Identity and Security Specialist at Microsoft
  • Liz Sundet

    Premier Field Engineer at Microsoft
  • Max Fritz

    Technology Solutions Professional at Microsoft

AMA - Ask Microsoft Anything

Join us for an interactive Q&A about SharePoint, OneDrive, Teams and Yammer. Bring your best questions. (You can submit your questions to the panel ahead of time via the Q&A feature on the app.)