Washington, D.C.

Business Intelligence Track

Monday, June 12th 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

Tuesday, June 13th 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.

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

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

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.

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, 12:40 pm

  • Yarin Negri

    Director of Marketing at CardioLog Analytics

Driving Adoption in SharePoint/Microsoft 365

Driving adoption helps companies to grow the value of their SharePoint/Microsoft 365 resources and get the most out of their investment in it. In this session, we will share our experience of how smart tools can empower teams to use your SharePoint/M365 to its full potential. And how adding smart measurement and analytics allows knowing exactly how to increase portal engagement, drive productivity, and provide insights on user collaboration and engagement.

Thursday, June 15th 2023, 1:20 pm

  • Jason Himmelstein

    Principal Program Manager at Microsoft
  • John White

    Microsoft MVP

Application Insights, Log Analytics, Kusto and Power BI, Oh My!

Log Analytics is increasingly becoming the storage mechanism of choice for telemetry data. At its core is Azure Data Explorer (ADX) or "Kusto", and the KQL language for analysis, which can also be used independently. Power BI is of course the standard for data analysis and reporting in the Microsoft ecosystem. It's easy enough for Power BI to report on Log Analytics and ADX data, but the devil is in the details. When should you use native KQL Queries? When should you use Direct Query? What about Hybrid tables and aggregations? This session will dive deeply into the nuances of reporting on both Log Analytics and ADX data with Power BI.

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.

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

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

X Close

Keep Up to Date on
365 EduCon DC