Loading…
Phoenix Power Platform World Tour
Attending this event?

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Tuesday, December 3
 

9:00am

Academy Training - PowerApps and MS Flow Essentials Training ($599)
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


Speakers
RS

Rem Saparco

Co-founder, Fidelity Factory Inc


Tuesday December 3, 2019 9:00am - 5:00pm
TBA
 
Wednesday, December 4
 

8:00am

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

Wednesday December 4, 2019 8:00am - 9:00am
TBA

9:00am

Conference Kickoff: Introductions & Networking
Wednesday December 4, 2019 9:00am - 9:30am
TBA

9:30am

General Session/Keynote
Speakers
avatar for Sameer Chabungbam

Sameer Chabungbam

Principal Program Manager Lead, Microsoft
Sameer leads the connector platform for the Microsoft Power Platform, where he is helping a lot of partners deliver their connectors for Power Apps, Power Automate and Power BI. He has been working with Microsoft for more than 13 years in various teams.


Wednesday December 4, 2019 9:30am - 10:30am
Canyon D

10:30am

Networking Break/Expo
Wednesday December 4, 2019 10:30am - 10:45am
TBA

10:45am

Power BI: Analyze in Excel
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.

Speakers
avatar for Mike Bate

Mike Bate

Principal Consultant, Jenton Global LLC
Mike Bate is founder and principal consultant at Jenton Global, an analytics consultancy specializing in Power BI. He has done extensive modeling and analytics work for international companies in the US and Canada including Microsoft, American Airlines, Experian, Visa, Pimco, Husky... Read More →



Wednesday December 4, 2019 10:45am - 11:45am
Canyon A

10:45am

Using PowerApps Canvas Apps and MS Flow to Support Business Processes
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

Speakers
RS

Rem Saparco

Co-founder, Fidelity Factory Inc


Wednesday December 4, 2019 10:45am - 11:45am
Canyon C

10:45am

Back to the Past! Travel with me on an adventure back in time… in your Power BI report!
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!


Speakers
avatar for Mark Baich

Mark Baich

President, Certified Power BI consultant, Baich Consulting
Senior Power BI consulting opportunities, all aspects of Power BI development and management. Open to making connections on LinkedIn at www.linkedin.com/in/MarkBaich


Wednesday December 4, 2019 10:45am - 11:45am
Canyon B

11:45am

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

Wednesday December 4, 2019 11:45am - 1:00pm
Canyon D

1:00pm

Introduction to the Concepts of Data Modeling
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! 

Speakers
avatar for Jessica Jolly

Jessica Jolly

Owner, ALT-Enter, LLC
I am a Microsoft Certified Trainer with an MCSE in Data Analytics, with a practice focused on Power BI specifically, and the Power Platform more generally. Before starting my own business, ALT-Enter, LLC, I worked for Unilever, a global consumer products company, for 27 years, in... Read More →


Wednesday December 4, 2019 1:00pm - 2:00pm
Canyon A

1:00pm

1:00pm

 Working With Data in the Power Platform
Speakers
avatar for Sameer Chabungbam

Sameer Chabungbam

Principal Program Manager Lead, Microsoft
Sameer leads the connector platform for the Microsoft Power Platform, where he is helping a lot of partners deliver their connectors for Power Apps, Power Automate and Power BI. He has been working with Microsoft for more than 13 years in various teams.


Wednesday December 4, 2019 1:00pm - 2:00pm
Canyon B

2:00pm

Networking Break/Expo




Wednesday December 4, 2019 2:00pm - 2:15pm
TBA

2:15pm

Developing a Center of Excellence
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!

Speakers
avatar for Michael Perillo

Michael Perillo

User Group Leader, Phoenix Power BI User Group


Wednesday December 4, 2019 2:15pm - 3:15pm
Canyon A

2:15pm

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

Speakers
RS

Rem Saparco

Co-founder, Fidelity Factory Inc


Wednesday December 4, 2019 2:15pm - 3:15pm
Canyon C

2:15pm

Application Lifecycle Management for Power BI using Azure DevOps
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.

Speakers
avatar for Shankar Narayanan

Shankar Narayanan

BI Solutions Specialist, Visual BI Solutions
Shankar Narayanan SGS is a Technology specialist with extensive knowledge and vast experience in R&D, Designing and Implementing BI Solutions, Cloud Computing, Application Architecture and Deployment. He loves to talk about BI Solutions in Azure and DevOps and can be reached @ ww... Read More →



Wednesday December 4, 2019 2:15pm - 3:15pm
Canyon B

3:15pm

Networking Break/Expo



Wednesday December 4, 2019 3:15pm - 3:30pm
TBA

3:30pm

Teams, Power BI, Modern Sharepoint
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.

Speakers
avatar for Jessica Jolly

Jessica Jolly

Owner, ALT-Enter, LLC
I am a Microsoft Certified Trainer with an MCSE in Data Analytics, with a practice focused on Power BI specifically, and the Power Platform more generally. Before starting my own business, ALT-Enter, LLC, I worked for Unilever, a global consumer products company, for 27 years, in... Read More →


Wednesday December 4, 2019 3:30pm - 4:30pm
Canyon A

3:30pm

The Future of Applied Data in Business
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.

Speakers
avatar for David Tello

David Tello

Independent Researcher, Python Lover
I am a cross-disciplinary and business-oriented applied mathematician with a healthy analytical mindset and expertise in computational modeling, mathematical modeling, regression modeling, financial analysis, and problem-oriented modeling construction. I also possess three years of... Read More →


Wednesday December 4, 2019 3:30pm - 4:30pm
Canyon C

3:30pm

Playing with (M)agic: an introduction to writing M code in Power BI
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.

Speakers
avatar for Kristine Dyess

Kristine Dyess

Director, Client Services, PowerPivotPro
I'm originally from Pittsburgh, PA and relocated to Phoenix, AZ in 2000. I've held roles in Reporting, Analytics, Modeling, Strategy, Management, and Consulting. My Power BI journey started with PowerPivot In Excel (in 2013) and lead to becoming a Principal Consultant with PowerPivotPro... Read More →


Wednesday December 4, 2019 3:30pm - 4:30pm
Canyon B

4:30pm

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

Wednesday December 4, 2019 4:30pm - 5:30pm
Canyon D
 
Thursday, December 5
 

8:00am

Registration/Breakfast/Expo
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!

Thursday December 5, 2019 8:00am - 9:00am
TBA

9:00am

Member Showcase: Air Strike
 We have created a full audit system in Power Apps used in conjunction with PowerBI

Speakers

Thursday December 5, 2019 9:00am - 10:00am
Canyon A

9:00am

DAX and Filter Context - Seeing the right data
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!

Speakers

Thursday December 5, 2019 9:00am - 10:00am
Canyon C

9:00am

Modern data architecture for massive data processing

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


Speakers
avatar for Rakesh Jayaram

Rakesh Jayaram

Associate Director, IQVIA
AWS & Microsoft Certified - Architect BloggerData Enthusiast



Thursday December 5, 2019 9:00am - 10:00am
Canyon B

10:00am

Networking Break/Expo



Thursday December 5, 2019 10:00am - 10:15am
TBA

10:15am

How to Talk About Your Product or Service so that Clients Want to Buy and Investors Want to Invest
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.

Speakers

Thursday December 5, 2019 10:15am - 11:15am
Canyon A

10:15am

Building Highly visible solutions to address every day needs
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.

Speakers
avatar for David Dean

David Dean

Sr Microsoft 365 Infrastructure Engineer, Choice Hotels


Thursday December 5, 2019 10:15am - 11:15am
Canyon C

11:15am

Networking Break/Expo
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 hereSponsorship Prospectus.

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


Thursday December 5, 2019 11:15am - 11:30am
TBA

11:30am

PowerApps and Flow Hands On Lab: Part 1
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

Speakers
avatar for Edrei Mpanduki

Edrei Mpanduki

Functional Analyst, Sanitation Specialists
I've been working with Dynamics 365 CE since the days with Dynamics CRM 2011.I'm passionate about the Power Platform, especially how to Power Apps and Power Automate have taken our implementation of Dynamics 365 to a new level of goodness. You can connect with me on LinkedIn at... Read More →



Thursday December 5, 2019 11:30am - 12:30pm
Canyon C

11:30am

Advanced Power BI Modeling Techniques
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.

Speakers
avatar for Martin Schoombee

Martin Schoombee

Chief Data Wrangler, 28twelve consulting
I help customers make sense of their data.



Thursday December 5, 2019 11:30am - 12:30pm
Canyon B

12:30pm

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

Thursday December 5, 2019 12:30pm - 1:30pm
Canyon D

1:30pm

PowerApps and Flow Hands On Lab: Part 2
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

Speakers
avatar for Edrei Mpanduki

Edrei Mpanduki

Functional Analyst, Sanitation Specialists
I've been working with Dynamics 365 CE since the days with Dynamics CRM 2011.I'm passionate about the Power Platform, especially how to Power Apps and Power Automate have taken our implementation of Dynamics 365 to a new level of goodness. You can connect with me on LinkedIn at... Read More →



Thursday December 5, 2019 1:30pm - 2:30pm
Canyon C

1:30pm

Power BI Development Best Practices
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.

Speakers
avatar for Martin Schoombee

Martin Schoombee

Chief Data Wrangler, 28twelve consulting
I help customers make sense of their data.



Thursday December 5, 2019 1:30pm - 2:30pm
Canyon B

2:30pm

Networking Break/Expo



Thursday December 5, 2019 2:30pm - 2:45pm
TBA

2:45pm

Panel Discussion/Sponsors Raffle Drawings
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!

Thursday December 5, 2019 2:45pm - 3:30pm
Canyon D