Chicago, IL

Advanced

Monday, July 26th 2021, 9:00 am

  • Brian Alderman

    Microsoft MVP, MCT, Author, Speaker

WRK102 - Becoming a SharePoint Online Admin Expert

SharePoint Online in Office 365 has many components and in this full day workshop we are going to learn about these different components and how to manage them so SharePoint Online is properly configured, secure, and optimized. We will discuss, explore, and roll up our sleeves and configure SharePoint Online configuration settings, create and configure site collections, configure user profile settings, create a structured taxonomy using the term store, and configure the search service to ensure your users are able to quickly find the information they need. When you leave, you’ll have all the skills necessary to configure and manage the different SharePoint Online components using both the SharePoint Online Admin Center, and PowerShell.

Wednesday, July 28th 2021, 2:00 pm

  • Liz Sundet

    Program Manager - SharePoint/OneDrive

SPT103 - Deploying Microsoft Viva Connections

Viva Connections is the gateway to the other Microsoft Viva products that works to engage your employees where they are doing their work, within Microsoft Teams. Come and learn about the Microsoft Viva suite of products, learn the pre-requisites to deploying Viva Connections and finally walk through demos of the product as it stands today. You will also learn about the roadmap features that are coming out over the summer of 2021 and what to expect and where to get started with card extensions to develop dashboards. This workshop will include something for everyone from IT Pros to Developers to Corporate Communications.

Wednesday, July 28th 2021, 3:20 pm

  • Brian Alderman

    Microsoft MVP, MCT, Author, Speaker

ADM104 - Configuring SQL Server for Optimal SharePoint Performance

Performing a default installation of SQL Server that will be hosting your SharePoint content can have a huge impact on your SharePoint deployment's performance. The SQL Server default installation has more than six settings that can negatively impact the performance of SharePoint if they aren't addressed either during the installation of SQL Server, or shortly after the installation of SQL Server. The SQL Server deployment options, or configuration options, that need to be addressed include: • Type of SQL Server instance • SQL Server instance settings • System database settings In this session, we are going to discuss, explore, and configure these SQL Server settings to ensure your SharePoint deployment is running efficiently and your organization is not losing productivity because of a poorly configured SQL Server instance.

Wednesday, July 28th 2021, 4:40 pm

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

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

Wednesday, July 28th 2021, 4:40 pm

  • Daniel Glenn

    Collaboration Practice Lead @ InfoWorks, Inc., Microsoft MVP

OFF105 - Use Your On-premises Data with Power Apps, Power BI, and Power Automate (Flow)

Microsoft Power BI, Power Automate (Flow) 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. 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. You will walk-away from this session with the knowledge you need to immediately start using your on-premises data with Microsoft 365.

Thursday, July 29th 2021, 4:20 pm

  • Liz Sundet

    Program Manager - SharePoint/OneDrive

INT205 - Tools and Techniques to create an accessible and inclusive intranet in Office 365

Around 1 in 12 men and 1 in 200 women have some type of color deficiency in their eyesight. Don't find out the hard way when you present an "awesome looking" yet colorful spreadsheet to your CIO and he tells you "I'm colorblind". Are you creating your sites, dashboards and documents that both look good and are accessible to all of your users? Even if you're not color blind or have low vision, there are color choices that just hurt the eyes. Learn how to use the tools available in the UI Fabric Theme Designer and check for accessibility in your color selection for SharePoint Themes and Designs as well as other tools for documents, PowerBI, and other areas of Office 365 to create an inclusive intranet that works for everyone.

Thursday, July 29th 2021, 4:20 pm

  • Jason Himmelstein

    Microsoft MVP & Microsoft Regional Director
  • John White

    MVP, Scuba Diver and Business Intelligence guy. CTO with tyGraph

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

Thursday, July 29th 2021, 4:20 pm

  • Prashant G Bhoyar

    Microsoft AI MVP, Solution Architect at Withum

FLO205 - Advanced Power Automate

Power Automate is the logical successor of SharePoint Designer Workflows. It helps us to create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data and to do much more. In this demo-driven session we will cover the advanced features of the Power Automate like Expressions, Advanced approval scenarios, nested flows, calling SharePoint REST APIs, and how can we use them to create sophisticated business solutions. You will learn: • Expressions in Power Automate • Advanced Approvals • How to consume SharePoint REST Endpoints using Power Automate? • How to leverage Power Automate to implement the real-life business solutions in Office 365/ SharePoint Online? • Power Automate Best Practices • How to convert Power Automate to Logic Apps?

Thursday, July 29th 2021, 4:20 pm

  • Mathias Neururer

    Solutions Engineer at FireStart

FLO206 - Building Enterprise Workflows with Teams, Outlook and SharePoint

This session will show how to design and build enterprise-grade workflows from zero to production in a step by step approach. You will learn how to design your process, build forms, connect your line of business applications, define your decision rules and events and build user-centric, task optimized touchpoints for your users in Teams, Outlook and SharePoint. The session will also provide practical insights, best practices and typical pitfalls when building a lasting workflow strategy for your organization.

Friday, July 30th 2021, 10:40 am

  • Richard Toland

    Principal Architect, Enterprise & Cloud Architecture Practice

DEV302 - SPFx or Custom Action, what's the difference and how do I know when to use each?

Be it through web parts, page layouts, or scoped custom actions, we've been able to inject client side JavaScript to SharePoint pages for quite some time. This session examines differences in use case, implementation scope, packaging and delivery of customizations made possible by 3 common CDN centric, JavaScript injection frameworks, SPFx and other flavors (a.k.a. ScriptBlock Custom Actions, Powershell/PnP Tools). We will also discuss when and where is appropriate for each.

Friday, July 30th 2021, 1:00 pm

  • Brian Alderman

    Microsoft MVP, MCT, Author, Speaker

ADM303 - Exploring Office 365 Migration Options and Tools

Congratulations, on your decision to move to Office 365. If your mind is running rampant on how to complete the migration, this session is for you. We will begin by exploring the steps necessary during the following migration phases: • Before the migration • Completing the migration • Managing the cloud-based content after migration As you can guess, you’re going to need to know what the best approach is to complete the migration, so we will also discuss what your migration options are, and what tools are available, including how to use the SharePoint Migration Assessment Tool with the SharePoint Migration Tool to help streamline and successfully complete your migration to Office 365.

Friday, July 30th 2021, 2:20 pm

  • Frank Migacz

    Cloud Architect at the Microsoft Technology Center

AZR304 - Non-human authentication and authorization

A deep dive into access keys, service accounts, service principles, client credential grants, device grants, personal access tokens, etc. Also, an overview of Basic Auth vs. NTLM vs. Kerberos and OAuth/OIDC/SAML.

Friday, July 30th 2021, 2:20 pm

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner - MVP, MBA, MCSM

FLO304 - Building Modern Approvals using Microsoft Power Automate: Advanced Concepts

The introduction of the Approvals Actions in Microsoft Power Automate has simplified the process of creating Approval Workflows. In this talk we’ll go beyond the process of building basic parallel or serial approval flows and look at advanced techniques that can be used to take them to the next level. We’ll demonstrate solutions for the following: • Applying custom formatting to the approval email • Recording approval results and comments • Setting SharePoint content Approval status • Forwarding an approval if the approver is out of the office • Escalating an approval that hasn’t been responded to • Sending periodic reminders about pending approvals • Building an approval workflow for an adjustable list of approvers

Friday, July 30th 2021, 2:20 pm

  • Alex Terentiev

    Office Development MVP. Custom Solutions Architect, Lead Developer at Sharepointalist Inc.

DEV305 - Developing React Templates Using SharePoint Framework Library Components

Templating is a pretty powerful approach to provide extensibility to a project/component/library. It can be used to deliver different behaviors and/or look and feel to different customers, or provide extendable open-source libraries. There are a lot of template libraries out there that can be used in your project. The problem with these libraries is that in most cases they provide you an ability to define "static" content (basically, HTML and CSS). And if you want to include some actionable content (e.g. handle events from outside the template, etc.) - it might be either tricky or impossible. This session showcases how you can implement fully functioning React Component templates for SharePoint Framework web parts using SPFx Library Components.