Anaheim-Orange County Power Platform World Tour

Register to attend the class or follow the instructions below to include registration for the Power Platform World Tour.

Please Note: Academy workshops are training sessions that will build your skills through hands-on, deep dive education. Our Academy Courses do require a separate registration. If you are registering for the Power Platform World Tour, you will have the option to add on Academy classes during the registration process.

If you have already registered, it's not too late to add on a class!

To edit your registration, please click here and follow these steps:
This will bring you to the Registration page – you will see a message stating "You are currently Registered." Click on Edit Registration (right side of screen).
When you see your registration, click Edit.
On the next screen, click Add Activities.
Check the box next to the class title you're interested in.
Follow the prompts to complete the process of adding this class to your registration.

Power Automate in a Day - Let’s Flow
Learn all about Microsoft Power Automate in this one-day training session

The course content has been created to cover important aspects of Microsoft Power Automate

Course Agenda:

9:00 – 10:00: Session - Microsoft Power Automate Introduction

10:00 – 12:00: Power Automate Hands-on labs (Beginner and Intermediate level labs)

12:00 – 1:30: Lunch and Learn (Session: Microsoft Power Automate Approvals Deep Dive)

1:30 – 3:30: Power Automate Hands-on labs (Beginner and Intermediate level labs)

3:30 – 5:00: Session - Microsoft Power Automate Expressions & Best Practices

Microsoft Power Automate:

Hands on Labs:

1) Microsoft Forms & Power Automate (Automated Flows, AI - Sentiment Analysis)

We will be using Power Automate to analyze data received from Microsoft Forms.
The Form will be a feedback request form.
The feedback received will be sent for sentiment analysis (AI – Azure) via Power Automate to interpret the sentiment of the feedback and accordingly notify admins

2) Microsoft Teams & Power Automate (Manual Flows, Adaptive Cards and Power Automate Bot)

We will be using Power Automate to post a channel message (adaptive card) to Microsoft Teams.

3) SharePoint & Power Automate (Power Automate Approvals)

We will be creating an Invoice Approval Process using Power Automate and SharePoint
`
4) File Archiving using Power Automate (Scheduled Flows)

We will use Power Automate to archive SharePoint files older than x days to an archived repository

5) Generate a PDF file using Power Automate (Pdf builder)

We will utilize Power Automate to create a pdf file from data generated with PowerApps

In addition to the above, we will go over some of the important features for Microsoft Power Automate
• Approvals
• Expressions
• Conditions
• Best Practices
• Demos and much more …


 Learning Objectives:
Microsoft Power Automate deep dive
• Learn about Microsoft Power Automate – connectors, actions, triggers, conditions etc.
• Power Automate Approval Scenarios (Sequential, Parallel, Quorum, Escalations, Reminders, etc.)
• Power Automate Expressions (Understand the Power Automate expression language syntax)
• Best Practices

Target Audience:
This training is designed for a Power User who is keen to understand Microsoft Power Automate

This is also suitable for a developer who is learning what these low-code solutions can do and how Microsoft Power Automate solutions can rapidly assist with task automation scenarios

Level: Beginner & Inter mediate

Computer Requirements:
Please bring a laptop to this course to conduct the labs and exercises with the following requirements:

• Please have the Google Chrome Browser installed
• We will provide you with an electronic copy of the lab manuals, resources and environments to work in prior to the day of the workshop
• You may want to bring a tablet to display the lab manual on during the session
• A sandbox environment will be provided with test user accounts that students can use to complete all the labs on their laptops
• Please be aware that if you are unable to join a sandbox tenant on your laptop (which can happen if the company laptop is locked down) or want to work in your own tenant – then you can do most of the labs in your company environment
     

Get your registration pass for the event, grab some breakfast and visit with the sponsors in the expo area!

"In this session, we'll use our experience in Microsoft Excel to better understand Power BI. If you've hit the limit of what tables, PivotTables, and charts can do for you, you're in the right place.

We'll go over how to use Power BI transformations to perform common data tasks, such as:

* Cleaning and trimming data without a formula

* Re-format an entire column at once

* Merging multiple record sets

* Splitting columns

* Multi-column VLOOKUP

By the end of this session, you'll realize that we've barely scratched the surface, but what lies beneath is exciting and powerful."

In this session we’ll go over the need for data extraction, cleansing, transforming and persisting data to be used in Power BI, and a method to “stamp it” for approval. The Power BI toolset can be used at the Enterprise level as well as the “Self-Service BI” level. Microsoft identified a need to have something “in-between” as well. Many Power BI analysts were creating valuable datasets for their organizations that could only be used and accessed through their workspaces and apps. With the use of Data Flows, Shared datasets and Certified datasets, an organization can take advantage of analysts’ data enrichment processes. This new-found power necessitates the ability for the organization to determine which datasets are for Enterprise use. By allowing Power BI administrators to “tag” datasets as Certified, a Power BI analyst can use someone else’s dataset with full confidence that it’s been vetted by the organization.
The session will be both a presentation of the conceptual background for having Dataflows and Certified Datasets, as well as demonstrate Dataflows and the Certification process.

The PowerApps product team is always delivering new features and in this session Charles Sterling will take a look at the recently released new and exciting features and finish with look at what the team will be delivering in the coming months. Key among these future investments being covered in this session: PowerApps Productivity enhancements, Enterprise-grade performance and scalability and a unified application platform.
High-productivity app development platform: To enable users of varying skills sets to consistently and efficiently build stunning performant apps with investments in modern experiences, reusable custom controls and best practices support via the enhanced Solution checker.
Enterprise-grade performance and scalability: To provide organizations with a platform that scales with their needs: from simple to sophisticated apps with enhanced tools that provide performance and stability checks, deeper visibility into usage and resource consumption and enhanced support for admins.
Unified application platform: To provide a consistent experience for building apps and extending Office 365 and Dynamics 365. Investments include enhancements on Unified Interface, support for embedding canvas apps in model-driven apps and native support of the Common Data Service for Apps.

Agenda:
Setting up your Canvas Power App for Component Use
Demo – Build a Header Component
Demo – Build a Navigation Component
Demo – Build a Gauge Control Component
Best practices
Limitations
Learning Materials

By participating as a sponsor, it will give your company the ability to highlight your services, solutions, or expertise and connect with the right audience to gain exposure while building your brand recognition!  Please view the sponsorship opportunities here: Sponsorship Prospectus.

Contact bob.buresh@dynamiccommunites.com with any questions about sponsorships.

 Launching ValQ to become one of the most downloaded visualizations in Power BI history did not happen overnight. Come learn about the ValQ journey as Chandler Stevens will share the ups and downs of developing, testing, marketing and launching a Power BI solution while partnering with Microsoft. In his session, Jay will do a few live demos explaining Budgeting, Forecasting, Simulations, What-if analysis in ValQ and showcase few of the intuitive advanced custom visuals of xViz designed exclusively for Power BI users.

Grab your lunch, network with fellow attendees and visit with the sponsors in the expo area!

In this session we will discuss about what Power BI is from a reporting and analysis stand point. We will also explore into how it can impact your organization by
enabling you to gain visibility into business critical KPIs and enable you to make better decisions quickly.

• An Overview of Power BI
• Connecting to data, composing Reports and Dashboard using Power based on your specific need and by persona
• Discuss the different types of Dashboards
• Key relevant features and shortcuts
• Delve into the self-serve capabilities.
• Licensing Power BI, Free, Pro and Premium
• Best Practices across various stages of Power BI implementation
• How to govern, increase adoption and secure Power BI
• Explore Power Platform eco-system and how Power BI fits

Power BI offers many different time intelligence functions, but it is sometimes difficult to understand when and how to use them. In this session we will learn not only how to create month-to-date, quarter-to-date and year-to-date measures and analytics, but we will learn how to create comparison reports, rolling period reports and allow the users to interact with slicers and filters.

Learning Objectives:
- Understand the time intelligence functions in DAX
- Creating and working with a date dimension
- Using relative time
- Slicing and filtering by time

In some business situations, there is a need to auto-create records based on a variable trigger. Learn how, with Flow and XRM, you can create Parent records containing a variable input to a Flow process which will auto-create records when triggered. We will walk through 3 real-world examples at varying degrees of complexity - a basic, an intermediate level and a fairly complex scenario.

The increasing adoption of SaaS services is producing a growing need for integrations through web services and web APIs. Microsoft Flow is redefining how we think about application integrations by allowing Citizen Developers to rapidly produce powerful, low cost integration solutions, including web services, that previously would have required complex software or custom development.

In this session, you'll learn how to create custom web services and interact with web service APIs with a few mouse clicks in Microsoft Flow. Demos will show how to create a custom web services that retrieve data, receive and save data, and Flows that call web service APIs of SaaS providers to analyze and process data.

Demos will range from simple zero-code samples that any Citizen Developer can create, to advanced scenarios utilizing Azure Functions and JSON parsing.

By participating as a sponsor, it will give your company the ability to highlight your services, solutions, or expertise and connect with the right audience to gain exposure while building your brand recognition!  Please view the sponsorship opportunities here: Sponsorship Prospectus.

Contact bob.buresh@dynamiccommunites.com with any questions about sponsorships.

You spent days on discovery and got all the business requirements, additional time on finding each of
the data sources and countless hours on cleansing and ETL/ELT to get the data into Power BI. Now you
need to model the data so that the aggregations are accurate, the slicers and filters are fast, and so the
power users can build their own reports on your model. This session will cover the importance of Data
Modeling in Power BI, focusing primarily the Star Schema, Fact Tables and Dimensions. We will also
discuss the pros and cons of additional dimension tables (snowflaking). Getting the modeling right is
critical for fast and accurate reports and data consistency throughout your organization.

Power Query is a powerful extract, transform, and load tool. This presentation will show you how you can improve your queries by getting a relational database server, like SQL Server, to do a lot of the processing for you by maximizing a feature call Query Folding. We will also discuss some more advanced concepts like working with nested tables, and also work directly with some M Code. We'll walk through a few examples to show you how versatile Power Query can be and how you can leverage its capabilities for your reports.

Agenda:
What is Delegation in Power Apps
Walk through of Delegation with respect to SharePoint as a data source
Delegation demos with SharePoint
Best practices
Limitations
Learning Materials

By participating as a sponsor, it will give your company the ability to highlight your services, solutions, or expertise and connect with the right audience to gain exposure while building your brand recognition!  Please view the sponsorship opportunities here: Sponsorship Prospectus.

Contact bob.buresh@dynamiccommunites.com with any questions about sponsorships.

In this session we will learn about how to use Power BI visuals, shortcuts, drillthroughs and other features to weave a story that resonates well with the end users.
We will also discuss about how information can be organized within reports and dashboards. Establishing navigational elements with the newest features Power BI features.

Most Power BI reports rely on a small dataset. And due to a lighting fast data engine most data model mistakes are shadowed by the speed of the service. When the dataset gets bigger then best data modeling practices are required. The trick here is Power BI data engine is not relational and therefore most data modeling techniques either don’t apply or don’t deliver. In this session we will go over how to model and measure performance for larger Power BI datasets.

What’s the hardest part of Power Apps and Power Automate (the tool formerly known as Flow)? It’s coming up with the first use case. After the first one, the ideas will just “FLOW” out of your brain.
Attend this session and see use cases for both these amazing Power Platform products that will save you time and save you money.
Belinda will show example after example of business automation using the Power Platform. She’ll also share with you the how for each of these. Any one of these might just be “the idea” that earns you a bonus for saving your company money! Attend this session and be (virtually) fitted for your superhero uniform.

Unwind from a busy day of learning with some snacks & beverages and network with fellow attendees and the sponsors in the expo area!

If you have not already registered, get your registration pass for the event, grab some breakfast and visit with the sponsors in the expo area!

This presentation will serve as a case study that focusses on how an electrical construction company utilized the entire Power Platform to transform the way they do business. We will discuss how they embraced Power BI to better understand all aspects of their business, utilized Power Apps to improve data collection processes, and flow to trigger emails for important events. The format will be lecturing what we did to empower the construction company, as well as focusing in on some of the solutions delivered. Q&A will be another key piece to the conversation.

At the end of this presentation attendees will understand how not only a construction company has gained tremendous value from the Power Platform, but how their company can improve their companies processes through the Power Platform as well.

Bring your PowerApps to life with effective UX & UI design best practices. This session will go through design tips to improve the look and feel of your apps, as well as how you can enhance the user experience to make your apps user friendly and adaptable.

By participating as a sponsor, it will give your company the ability to highlight your services, solutions, or expertise and connect with the right audience to gain exposure while building your brand recognition!  Please view the sponsorship opportunities here: Sponsorship Prospectus.

Contact bob.buresh@dynamiccommunites.com with any questions about sponsorships.

Power BI dashboards should simplify the data analysis process for busy business managers and workers who do not necessarily have the time or inclination to dig deeply into data. The purpose of charts, graphs, gauges and alerts are to make BI data easy to grasp. However, building dashboards can be a daunting assignment for BI teams, in no small part because the intended user base often consists of corporate executives and the heads of business units. In addition, they can be a demanding audience.

A dashboard is a visual display of the most important information needed to achieve one or more objectives consolidated on a single computer screen so user can monitor the information at a glance, but how do you make all of this information easy to understand? In addition, more importantly how to do you make it compelling to use?

In this session, we will look at some key best practices that will make it easier to deliver your message to our audience and make your dashboard compelling to use.

As a new user, it can be intimidating to ask for help - not knowing where to begin, thinking your scenario is too specific, or worrying if it's something silly like the "parking brake is still on"...but there are steps you can take to troubleshoot the issues yourself, as well as a wealth of information waiting to be mined.

We’ll walk through 5 steps to problem-solving in Flow, and also cover some specific and common issues faced by new users, and how to resolve them.

Format: Presentation and Demo with Q & A

Have you ever wanted to add some complex functionality to a PowerApp with a little bit of code?

Learn how to add advanced application features and functionality to PowerApps by leveraging Azure Functions. See examples of PowerApps that utilize Azure Functions to provide complex logic, encryption, multi-level user authorization, advanced data access, and web API processing.
--Understand Azure Functions and the value they can offer to PowerApps
--See examples of how PowerApps can use Azure Functions to provide advanced application features
--Learn how to create an Azure Function that can be used by PowerApps
--Learn how to connect PowerApps to Azure Functions using Microsoft Flow

Programming experience is not required, but Azure Functions .NET code will be demonstrated during the session.

By participating as a sponsor, it will give your company the ability to highlight your services, solutions, or expertise and connect with the right audience to gain exposure while building your brand recognition!  Please view the sponsorship opportunities here: Sponsorship Prospectus.

Contact bob.buresh@dynamiccommunites.com with any questions about sponsorships.

This session is about DevOps and how Application Lifecycle Management is done in Power BI using DevOps. It talks about the different methods, best practices and success stories with demo.

In order to leverage and Optimize your investments in the Power Platform tools, one of the first steps is the licenses you require for your current future needs.
In this session you will learn about the various licensing options for Power BI, Power Apps (revised licensing) and Power Automate (revised licensing). Pros and cons for each of the offering.

Grab your lunch, network with fellow attendees and visit with the sponsors in the expo area!

Now that you’ve created Columns, Measures and Tables (DAX 101) and you’ve used DAX for some Time Intelligence (DAX 102) functions, you may be wondering “Is my DAX as fast and efficient as it could or should be?”
In this session, we’ll take DAX a little further in the following areas:

• Row Context
• FILTER
• ALL
• CALCULATE
• Variables
• And More…

We’ll also review some resources that can make your DAX writing experience easier.
If you are NOT a programmer, Belinda considers herself a “Citizen Developer” so you’ll be just fine. Of Course, programmers are always welcomed, especially since we’re talking code!

A very unknown feature in Power BI is the ability to create near real time report or dashboard with live data, not using direct query datasets. In this session Armando Lacerda will run multiple demos to explain and explorer what can be done with streaming datasets. You will learn the possibilities and limitations, the applications and exclusions. You will also learn the bases of the lambda architecture to keep the live, streaming data for historical analysis using CDM and Flow.

First five-minutes will be Sponsors drawing for the winners of their booth raffles!
Following will be a Q & A session with a panel of Experts!