Washington, D.C.

Power BI 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

  • Prashant G Bhoyar

    Microsoft MVP & MCT

Hands-On: Azure For Power Platform Developers Masterclass

In this hands-on workshop, we will cover how to use Azure for custom development in Microsoft Platform, Power Automate, Power Apps, Power Virtual Agents, Dataverse, and Power BI. We will cover: - Microsoft Azure Key Concepts - How does Power Platform use Azure? - How can fusion teams take advantage of Microsoft Azure and Microsoft Power Platform? - Authentication and Authorization in Azure - Azure + Power Automate - Azure + Power Automate - Azure + Power Apps - Azure + Power Virtual Agents - Azure + Power BI - Azure + Dataverse - What are Azure Functions? - What are Logic Apps? - What is Azure Bot Service? - How to create an enterprise-grade app using Azure and Microsoft Power Platform? At the end of the workshop, attendees will have a working knowledge of Azure and how to use it to implement the customizations in the Microsoft Power Platform. Access to Azure, Microsoft Power Platform ( Power Apps, Power Automate, Power Virtual Agents, and Power BI ) will be provided to create the customization. The target audience of this hands-on workshop is Developers, Power Users, and IT Pros who want to get into development. Please note: Attendees will need to bring their laptops with internet access and modern browsers like Microsoft Edge, Google Chrome, Firefox, Safari. The tablets will not work. You Will Learn : 1. Authentication and Authorization in Azure? 2. How does fusion teams can take advantages of Microsoft Azure and Microsoft Power Platform? 3. How to create enterprise grade app using Azure and Microsoft Power Platform

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

  • Prashant G Bhoyar

    Microsoft MVP & MCT

Power Platform Governance 101

In this half-day workshop, we will cover the key principles of Power Platform Governance. Effective governance policies play a big role in the successful roll-out of the Power Platform across the organization and running it on a scale. The governance policies will include Power Automate, Power Apps, Power Virtual Agents, Power Pages, Dataverse, and Power BI. In this demo-driven workshop, we will cover, 1. Power Platform Governance Overview 2. Center of Excellence ( CoE ) Starter Kit 3. Automation Kit 4. Data Loss Prevention policies 5. User Management 6. Permission manager 7. License and capacity management 8. Security and Control 9. Managed Environments 10. Best Practices

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

  • Craig Harris

    Senior Technical Specialists at Microsoft Federal
  • Jamie Willis-Rose

    Senior Technical Specialists at Microsoft Federal

Leveraging Low Code to Respond to Federal Regulations with Agility

There are new federal regulations and executive orders all the time and it can be hard for an agency to keep their IT infrastructure in compliance. In our session we will discuss how the Microsoft Power Platform can better position agencies to be nimble and respond quickly to the ever-changing landscape. We'll show responding to a rapidly changing regulation landscape using multiple personas, both IT and Business decision makers, and speak to the key points of interest that drive both. We'll show how these personas can leverage the Power Platform to both meet the changing regulations and show measured progress along the way. We'll include demos of various Power Platform products to highlight the progress of the agency and demonstrate increased velocity by leveraging low-code tools.

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