Washington, D.C.

Business Intelligence Track

Monday, June 12th 2023, 9:00 am

  • Treb Gatte

    Microsoft MVP

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.

Monday, June 12th 2023, 9:00 am

  • Daniel Christian

    Microsoft MVP & MCT
  • Scott Shearer

    Microsoft MVP & MCT

Power BI For The Absolute Beginner

Have you only heard of Power BI in passing or have always been the end-user but now are ready to learn and invest in this tool to bridge the gap between data and decision making? Then this is a must attend workshop for you. Join Daniel Christian and Scott Shearer who are both Microsoft MVPs and MCTs as they take you on a journey into the Microsoft Power BI world. This full day workshop will first introduce you into the past and present of Power BI and then dive into demos. Daniel and Scott will walk you through how to use commonly used data sources such as Dataverse, SharePoint and SQL to build reports that help visualize your data and create amazing experiences for the end users. They also focus on the deep integration across the Power Platform family i.e. from the report kick-off a Power Automate flow or add a Power Apps canvas app to edit data. In this workshop, you'll be introduced to: • Power BI Licensing • Using the Power BI Desktop App • Using the Power BI Service • How to create reports and dashboards • DAX fundamentals • Integration with Power Apps and Power Automate • Learning resources • And more (time permitting...) Please note that this is not a hands-on workshop but attendees are welcome to follow along.

Tuesday, June 13th 2023, 9:00 am

  • Daniel Christian

    Microsoft MVP & MCT

Microsoft Power Platform in a Day

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! Check out my workshop preview: https://youtu.be/DhArVJvKZVc

Tuesday, June 13th 2023, 9:00 am

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

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 (Principal Program Manager @ Microsoft) 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 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. Check out our workshop preview: https://youtu.be/YrgXIwSii6Q

Wednesday, June 14th 2023, 9:50 am

  • Scott Shearer

    Microsoft MVP & MCT

Beginners Guide to Power BI

This session will provide you with the knowledge that you need to quickly become productive using Power BI. You will be introduced to: - Power BI licensing - Power BI Components - Using the Power BI Desktop app - Using the Power BI Service - How to create reports and dashboards - Learning Resources Don't have a Power BI license? You can start using Power BI for free! Attend this demo-rich session and get started with Power BI!

Wednesday, June 14th 2023, 11:30 am

  • Daniel Glenn

    Microsoft MVP

Build your first Power BI dashboard

Creating compelling reports is an important skill in our data-centric world. Have you seen a nice-looking report or dashboard and wondered how you can get started creating one? Are you interested in learning how to create a Power BI dashboard, from simple data to actionable intelligence? Then this session is for you! In this session, we will talk about the building blocks of Power BI, look at different types of data you can use, and define what makes a good dashboard. You will learn when to use Power BI Desktop and when you need the Power BI service. We will also discuss how you can safely share Power BI insights inside and outside of your organization. You will leave this session with the resources you need to get started in your journey with Power BI.

Wednesday, June 14th 2023, 1:40 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

Exploring the Future of Microsoft Analytics

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, June 14th 2023, 3:30 pm

  • John Kerski

    Microsoft PMP

Querying Power BI REST APIs within a Power BI Dataset

Would you like to build a Power BI dataset that could inventory your workspaces, reports, datasets, and refresh schedule? Would you'd like to query another dataset to import into your dataset? In this session I'll show you how to leverage an open-source custom connector that connects to Power BI's REST APIs to do just that.

Thursday, June 15th 2023, 9:00 am

  • Treb Gatte

    Microsoft MVP

Introduction to Power BI Metrics

Metrics and scorecards are a new Power BI feature that enables us to capture and focus on what we are working toward rather than what we are working on. If you are new to Power BI, Metrics are an excellent place to start well. In this presentation, you'll learn - What are Power BI Metrics and how are they intended to be used - See some examples of real-world scorecards - See how to set up a scorecard demo

Thursday, June 15th 2023, 10:40 am

  • Scott Shearer

    Microsoft MVP & MCT

Using Power Automate with Power BI

Did you know that there are at least 25 Power BI actions and triggers available in Power Automate? In this session you'll see: - How to launch a Flow from a button in Power BI - How to export a report from Power BI using a Flow - How to refresh a dataset using a Flow - Power Automate integration with Power BI Metrics - And more... All of the above will be presented via live demonstrations. If you are a Power BI user and are not yet leveraging Power Automate, this session is for you.

Thursday, June 15th 2023, 1:20 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

There's No Time Like the Present - Real Time Reporting with 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 and hybrid tables, there are more than a few options for accomplishing this goal, but they all do come with a few tradeoffs. This session will examine all of the techniques available to Power BI for reporting on your data in cached mode, near real time, and real time. It will 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.

Thursday, June 15th 2023, 2:40 pm

  • Daniel Glenn

    Microsoft MVP

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.

Thursday, June 15th 2023, 4:30 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

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.

Friday, June 16th 2023, 10:20 am

  • John Kerski

    Microsoft PMP

DataOps 101 - A Better Way to Develop and Deliver Data Analytics

Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.

Friday, June 16th 2023, 12:30 pm

  • Treb Gatte

    Microsoft MVP

Convert email/contracts/invoices to actionable data with Microsoft Syntex, Power Automate, Power BI

This session covers the document understanding functionality of Microsoft Syntex used to process email, contracts, and other unstructured data. We'll also demo the new layout model to process invoices. According to Forrester, today’s organizations have 72% of their critical information locked away in their Content Estate, scattered amongst PDFs and other unstructured, hard to analyze file formats. Until now, the process to curate this information into analyzable data has been manual, time-consuming, and expensive. Today, industry leaders are using AI to combine their content information with structured data from the Data Estate to synthesize new business insights and drive innovation faster. Learn how you can use Microsoft’s new applied AI technology to enable this competitive advantage for your company. Using Microsoft Syntex, Power Automate, and Power BI, you see how to ingest email and convert it to actionable data at scale. You’ll see how to: • Create a document understanding model to locate the relevant patterns withing the document • Attach that model to a SharePoint library • Have Microsoft Syntex extract the data from the documents automatically • Use the new Power BI integration with SharePoint, using your structured data for a holistic analysis. • Use the new Power Automate integration with SharePoint, to automatically trigger business processes