Monday Workshops

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.

Monday, September 26th 2022, 9:00 am

  • Paul Papanek Stork

    Don't Pa..Panic Consulting, Owner

WRK103 - Advanced Power Apps and Power Automate: Workarounds for Common Problems

Spend any amount of time in the Power Platform forums and you will begin to see very similar questions asked over and over again. In this workshop, we will look at some of the most common issues Citizen Developers encounter when trying to develop applications and workflows in the Power Platform. We'll examine each type of problem, analyze why they occur, and provide workarounds that you can use when you encounter them. The workshop will be divided into two parts. In the first we'll concentrate on Power Apps and in the second we'll look at Power Automate. Here is a general list of the overall topics we will cover: Part One: Power Apps • Managing Delegation Warnings • Working with Dates and Times • Conditional Formatting of data • Passing Data to and Retrieving Results from a Flow Part Two: Power Automate • Using Loops and Parallel Branches • Working with Large Data Sources • Using Conditions and Switches effectively • Implementing Error Checking/Correction

Monday, September 26th 2022, 9:00 am

  • Scott Shearer

    SharePoint, Flow and Microsoft 365 Evangelist and Microsoft MVP
  • William Huneycutt

    ASPE Training | Upskill Tech

WRK105 - Hands-On Flow Workshop

Microsoft Flow is the successor to SharePoint Designer workflow and the future of process automation for SharePoint. While Flow is much more than a SharePoint-only tool, this session will focus on providing you with the skills to get started right away with SharePoint automation using Microsoft Flow. In this demo-rich workshop, you’ll learn by doing with hands-on labs. What we'll cover during the session: • Overview and how your organization can get started • Flow concepts (e.g. triggers, actions, conditions, expressions) and how they’re applicable • Flow design using templates and blank canvas • Flow creation for common SharePoint business requirements, e.g. document approval • How to administer Flow in your organization ***ATTENDEES MUST BRING THEIR OWN DEVICE. DEVICES WITHOUT EXTERNAL KEYBOARDS ARE NOT RECOMMENDED .***

Tuesday, September 27th 2022, 9:00 am

  • Daniel Christian

    Microsoft Business Application MVP

WRK505 - Let's build a chat bot together

This beginner-level workshop gives you hands-on experience designing and developing your first Power Virtual Agent chatbot. We start off by first taking a closer look at all the features available and then build two bots, a static bot with all the data manually entered and then a dynamic bot which pulls the data using Power Automate flows. Then we switch over to Microsoft Teams and see all the features available there and how to use them to build chatbots are not additional cost.

Tuesday, September 27th 2022, 1:30 pm

  • Daniel Christian

    Microsoft Business Application MVP

WRK605 - Power Apps: App Design Patterns

This is a beginner to intermediate level class meant for makers who have built a few apps using the out-of-box forms and are now interested in improving the UI and UX design patterns to make the app more user-friendly and reduce end-user mistakes. In the second half we'll look at building some Power Automate flows using buttons. We'll build an elegant canvas app to submit, edit and delete data. Our primary focus will be on the design features such as: • Screens: How many to build and for what reasons? • Navigation: Should I use buttons only or a gallery or a component? • Forms: Should I build my own form or should I use the Edit form? • Design: Branding ideas and responsive design scenarios • Data source suggestions Performance improvements suggestions.