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

PowerApps and MS Flow Essentials Training

***This is an onsite course in Phoenix, AX - the course will run from 9:00am-5:00pm Arizona time

Learn how to design, build and deploy PowerApps Canvas Apps and Microsoft Flow Automations in this one day training session.

Our Essentials course goes beyond what is covered in basic 100 level sessions. All of the content in this course has been created by our expert instructors. This course will prepare you to build intermediate to advanced PowerApps and MS Flow solutions for personal productivity or to tackle task / department level solutions.

One Day: MS Flow and PowerApps
Taking the knowledge and experience gained over the course of implementing many Microsoft Flow and PowerApps solutions, our instructors have created this unique program that covers the essential topics for both of these products.

A half day will be dedicated to building PowerApps Canvas Apps and half day dedicated to Microsoft Flow. Our instructors created PowerApps labs and training materials that cover important concepts that go beyond basic data capture and presentation (further details below). The Microsoft Flow labs and materials have been sourced from Microsoft’s Flow in a Day program - these labs demonstrate core Flow patterns and scenarios for initiating and automating workflows.

Instructor Lead, Lab Based Training
Our instructors have delivered over 10 App in a Day sessions in conjunction with Microsoft. Attendees will receive quality presentations, demonstrations and lab material in this one day session presented by experienced members of the industry.

Attendees will be immersed in an intensive (and fun) day long session where they will build PowerApps and Microsoft Flow solution that include intermediate and advanced concepts, patterns and methods.
Training OverviewBelow is a list of the lab modules which will be covered in this one day training session.


PowerApps Labs (Morning)

• Lab: PowerApps Mobile Expense Claim Submissions App
  • Build an App that captures expense claim data (with images) and stores it in SharePoint

MS Flow Labs (Afternoon)

• Lab 1: Flow Buttons and Writing Data
• Lab 2: Approvals and Routing
• Lab 3: Notifications and Conditions
• Lab 4: Scheduled Triggers, Looping Through Data, Variables
• Lab 5: Looking up Users, Dynamically Assigning Approvals
• Lab 6: Building Advanced Conditions, Comparing Dates

What you will Need:
Here’s what you’ll need for the day of the session:

• We will provide you with an electronic copy of the lab manuals, resources and environments to work in
• You will need a laptop to complete the labs with
• You may want to bring a tablet to display the lab manual on during the session

Lab Scenarios

Mobile app - Expense Capture App

• Connecting to Datasources
• Displaying Datasets
• Icons
• Capturing Form Data
• Grouping Controls
• Camera integration
• Rules and Conditions
• Working with Collections
• Variables
• Submit Data
• Lookup Users
• Generate Email
• Offline / Online - Handling Disconnected Scenarios
• Alerts
• Sharing PowerApps
• Versioning / Restoring
• Analyics

Microsoft Flow - Various Scenarios

• Conditional logic
• Switch case
• Email
• Approval
• Time out and escalation
• Schedule trigger
• SharePoint trigger
• Troubleshooting
• Error Handling
• Analytics

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

In this session, we will walk through the reporting capabilities made possible through Analyze in Excel, an oft-overlooked but invaluable feature of Power BI. The session will answer the questions: What is Analyze in Excel? Why use Analyze in Excel? How can I use Analyze in Excel? Learn why leveraging this tool actually expands the role of Power BI in an organization, rather than diminishing it.

In this session, we will explore how PowerApps and Microsoft Flow can be used to affect change in your business processes.

In this session, we will address the following:
- A brief overview of the PowerApps and MS Flow. Identify their strengths as a business process tool.
- Identify the specific roles that these solutions may play in your businesses process solutions
- Walkthrough a PowerApps and MS Flow solution
- Demonstrate the solution

I would like to present this session - along with Rem Saparco

What do you do when a user asks to see a report backdated in time? If the current month is August 2019 but they want to see the report backdated to June 2018, how do you accomplish this in Power BI?

This session will show you a technique where users select a single Year-Month as the report end date, and your report visuals backdate automatically without having to change DAX measures. This technique can be applied to most date (month) based visuals including showing the Last X Months (rolling 12 months), Year-to-Date sums, Calendar Year-to-Date Month totals, and Multi-Year totals.

This technique is advanced as it uses a combination of DAX, new tables linked to a Calendar table and relationships needed between the tables.

Come and learn this solution! Your users will thank you!

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

Many users of Power BI come to the tool from Excel which means that they are not familiar with one of the key concepts of PBI: data modeling. This session will introduce data modeling using analogies with Excel. We will investigate star schemas, dimensions and fact tables. We will discuss the dos and dont's of data modeling, always referring to common sense guidelines. Participants with no experience in data modeling but lots of experience in Excel are the perfect audience for this session. It is deliberately conducted in layman's terms.
And if you want to continue your data modeling journey, there is an advanced data modeling session you can attend the very next day! 

This session will provide you with a blueprint on how to build and maintain a successful Center of Excellence (COE). No matter what size your team or your analytics maturity model you'll find components of this presentation will have a positive impact in your organization's analytics culture. 

Would you like to improve data quality and data governance? Do you want to learn about best practices, community development, platform support, platform training, gamification? Are you curious how to transform users into data super heros? We'll talk about all these strategies and provide examples how to increase engagement, tool adoption, innovation and much more. 

If you're passionate about data and want to have fun in the process then this session is for you. No technical expertise required - SERIOUSLY!

Sean Panter and Rem Saparco will be walking you through the process of building a Custom Connector for use within PowerApps or MS Flow.

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.

Power BI works well with both Teams and Modern Sharepoint. You can showcase a particular report or dashboard within a Teams tab or embedded within Sharepoint. This session will talk about how these three tools work together. It is designed for participants who are brand new to any of these tools.

Data is everywhere and, increasingly, seems as though there is nothing we don't measure. If we discover something we aren't currently measuring, we quickly figure out how to, and usually, the results end up online.
Much of this data ends up being public in one way or another, especially if it is data collected by government agencies. We want to discuss and showcase some of the implications of this, and demonstrate how Data Science and something as seemingly innocuous as historical weather data can be used to grab useful and meaningful data for business analytics. With a little creativity, pretty much any data can end up being a potent resource for modern business at any scale.

Do you love Power Query? Are you ready to take your skills to the next level? Learning to write M code is easier than you think! Writing M code can reduce maintenance and create a more dynamic solution for you and your users. In this session you will learn: 1. Where you can write M code in PowerQuery. 2. The different types of objects you can use as variables in your code. 3. Different ways you can leverage variables to create a dynamic solution.

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!

 We have created a full audit system in Power Apps used in conjunction with PowerBI

This session will demystify DAX Filter Context, which determines what portion of your data model a calculation has access to and how you can ensure you have the right data and an accurate result. We'll start with some groundwork on the key concepts involved with DAX, the data formula language used by Power BI and Excel's PowerPivot, including the difference between Row and Filter context, and when you use CALCULATE. We'll spend the bulk of the session with examples of how filters are working, how to modify filters to act on subsets of supersets of your data, and how you can use virtual tables and variables to modify your context. If time allows, we can slip in some DAX editor hotkeys everyone can use whenever they edit DAX to save themselves time and aggravation!

Data has become the strategic asset used to transform business to uncover new insights

IDC Projects that this data exploration of data will result in 40 zeta bytes by 2020

To drive the business forward, the enterprise needs to integrate,adapt their enterprise data warehouse to evolve into modern data warehouse

As a product or service owner, you need to be able to talk to more than just the 1s and 0s of your product or service. You need to be able to talk about your product or service in a way that your potential clients and investors can easily relate to, can quickly visualize how it will change their lives and are enthusiastic to buy or invest.  Being able to tell the right story for your potential clients and investors is the key to getting them to take action.  Unfortunately, most of us aren't sure how to craft a story about our product or service that isn't just all about the data, aren't sure how to structure our talk to inspire our audience to action and aren't sure how to stop from overwhelming our audience.  After this talk, you will have a storytelling structure and formula that makes clients want to buy and investors want to invest even if you have never sold before.

This session will discuss and demonstrate ways where power users can use PowerApps, Power Automate (Flow), and SharePoint to build solutions that are applicable to everyone’s business and make you a Power Platform superstar.

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.

Please plan to bring your own laptop, this is part one of the hands on lab.
While you may already familiar with Power BI, PowerApps and perhaps Microsoft Flow; you may not know that Microsoft is bringing these tools together into a unified brand called: the Microsoft Power platform. In this HANDS ON introduction to these products AND how you can use these products together to create very sophisticated “no code/low code” solutions for Business Analysts and citizen developers. In this Hands On Lab, we will build an Event Management Solutions and covers the following technologies PowerApps, Common Data Service(CDS), Business Card Reader, Power Automate, and Powerapps Portals.

Prerequisites

1. Access to a PowerApps Environment - If you don’t have access to a PowerApps Environment, sign up for a trial prior to beginning of the session. Instructions are provided in the Session Materials
2. Provision a trial PowerApps Portal prior to beginning of Part 2 – Instructions available in the Session Materials
3. An electronic copy of the lab will be provided, you might want to bring a tablet to display the lab during the session

Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper.

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures or KPIs in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.

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

Part 2, please plan to bring your own laptop.
While you may already familiar with Power BI, PowerApps and perhaps Microsoft Flow; you may not know that Microsoft is bringing these tools together into a unified brand called: the Microsoft Power platform. In this HANDS ON introduction to these products AND how you can use these products together to create very sophisticated “no code/low code” solutions for Business Analysts and citizen developers. In this Hands On Lab, we will build an Event Management Solutions and covers the following technologies PowerApps, Common Data Service(CDS), Business Card Reader, Power Automate, and Powerapps Portals.

Prerequisites

1. Access to a PowerApps Environment - If you don’t have access to a PowerApps Environment, sign up for a trial prior to beginning of the session. Instructions are provided in the Session Materials
2. Provision a trial PowerApps Portal prior to beginning of Part 2 – Instructions available in the Session Materials
3. An electronic copy of the lab will be provided, you might want to bring a tablet to display the lab during the session

Are you a developer or analyst, creating Power BI reports that will be shared across teams or even your entire organization? Moving from "quick and dirty" deployments to production ready solutions intended for larger audiences means that you should already be thinking about performance, standardization and (most importantly) your end users.

In this session we will take a good look at some of the considerations and best practices when developing Power BI models, reports and dashboards to help you bridge the gap and make your solutions enterprise ready.

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!