Business Intelligence

Monday, September 26th 2022, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

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

Monday, September 26th 2022, 9:00 am

  • Prashant G Bhoyar

    Microsoft AI MVP, MCT, Cloud Solution Architect at AIS

WRK102 - Building Intelligent Enterprise-Grade Virtual Agents ( Bots ) using Power Platform & Azure

Microsoft's CEO Satya Nadella has said: "Human Language is the new UI layer, bots are like new application". As more and more bots are getting popular in homes and enterprises, the demand for custom bots is increasing at a rapid pace. The Microsoft Bot Framework is a comprehensive offering that we can use to build and deploy high-quality bots for our users to enjoy wherever they are talking. Power Virtual Agents a SaaS offering from Microsoft empowers teams to easily create powerful bots using a guided, no-code graphical interface without the need for data scientists or developers. Microsoft Cognitive Services let you build apps with powerful algorithms to see, hear, speak, understand and interpret our needs using natural methods of communication, with just a few lines of code. Easily add intelligent features – such as emotion and sentiment detection, vision and speech recognition, language understanding, knowledge, and search – into your app, across devices and platforms such as iOS, Android, and Windows, keep improving, and are easy to set up. In this hands-on workshop, we will cover how to build the no-code intelligent help desk bots using Power Virtual Agents, Microsoft Bot Framework, and Cognitive Services. The help desk bot will be able to answer questions related to employee benefits, open healthcare enrollment, etc. Access to SharePoint online site, Microsoft Team, and Azure will be provided to create the Bots. The target audience of this hands-on workshop is Power Users, IT Pros, and Developers. The contents of this workshop are applicable to SharePoint Online as well as SharePoint On-Prem as well. You will learn: • What are Power Virtual Agents? • What is Microsoft Bot Framework? • What is Microsoft Bot Framework Composer? • What is Azure Bot Service? • How to create bots using Microsoft Bot Framework? • What are Cognitive Services? • How to leverage Bot Framework and Cognitive Services to implement enterprise-grade bots? Please note: Attendees will need to bring their own laptop with internet access and modern browsers like Microsoft Edge, Google Chrome, Firefox, Safari. The tablets will not work.

Wednesday, September 28th 2022, 10:50 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

CM101 - Unlocking SharePoint's Content with SharePoint Syntex and 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.

Wednesday, September 28th 2022, 10:50 am

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI101 - 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, September 28th 2022, 1:00 pm

  • Daniel Glenn

    Microsoft MVP, Senior Director of Hybrid Office and U.S. Delivery at Creospark

BI102 - 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, September 28th 2022, 2:20 pm

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

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.

Wednesday, September 28th 2022, 4:00 pm

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI104 - Sharing PowerBI Reports with the World - 5 Things to Know

The Power BI Publish to Web feature is a powerful tool for sharing your reports with a wider audience. However, it brings with it a number of difficulties, challenges, and dangers. Before you use this capability, you should know when it is appropriate, what is possible, and how to design for it properly. This session will explore what the Publish to web feature is all about, and how you can take advantage of it effectively, and most importantly… safely.

Thursday, September 29th 2022, 9:00 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

BI201 - Managing Goal Status and OKRs using Power BI Goals and SharePoint

Greatly improve the speed of your decision making by using Power BI Goals and SharePoint together to get relevant information easily. This session will introduce the new Power BI Goals functionality, discuss what are Goals and Objective and Key Results(OKR) metrics, show you how to set up your metrics using data from SharePoint for automatic updating.

Thursday, September 29th 2022, 10:50 am

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Scuba Diver and Business Intelligence guy. CTO with tyGraph

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

Thursday, September 29th 2022, 3:30 pm

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI204 - 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, there are more than a few options for accomplishing this goal, but they all do come with a few tradeoffs. This demonstration laden session will examine all of the techniques available to Power BI for reporting on your data in real time, 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.

Friday, September 30th 2022, 9:00 am

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Scuba Diver and Business Intelligence guy. CTO with tyGraph

BI301 - 5 Reasons you want Paginated Reports in your life

You're already familiar with Power BI and the Power BI Desktop PBIX files. These tools are great for analytical reporting, but when it comes to things like printing, and subscriptions, well, it falls a little short. That's where Paginated reports come in. Paginated reports draw upon the decades of experience in operational reporting from SQL Server Reporting Services, but they work in the Power BI service, enabling many new scenarios and opportunities. This demo-rich session will explain what paginated reports are all about, and demonstrate 5 reasons that you'll want to start using paginated reports immediately.

Friday, September 30th 2022, 10:20 am

  • Treb Gatte

    Microsoft MVP, MCP, MCTS, MBA, CEO, Marquee Insights

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

Friday, September 30th 2022, 10:20 am

  • Daniel Glenn

    Microsoft MVP, Senior Director of Hybrid Office and U.S. Delivery at Creospark

PLT302 - Work With Your On-Premises Data From Anywhere

Microsoft Power BI, Power Automate, 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. The hybrid office is even more efficient when you can work with your date from anywhere! 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 Microsoft 365 to create rich business solutions for your employees working from anywhere. You will walk-away from this session with the knowledge you need to immediately start using your on-premises data with Microsoft 365.

Friday, September 30th 2022, 12:30 pm

  • Jason Himmelstein

    Microsoft Regional Director & Microsoft MVP
  • John White

    Scuba Diver and Business Intelligence guy. CTO with tyGraph

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.