Chicago Power Platform World Tour: Full Schedule

9:00am CDT

Academy - Microsoft Flow: Using Workflows to Streamline Business Processes ($599)

Register to attend the class or follow the instructions below to include registration for the Power BI 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 BI World Tour, you will have the option to add on Academy classes during the registration process.

If you have already registered, it's not to 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.

Microsoft Flow: Using Workflows to Streamline Business Processes

Microsoft Flow helps non-developers work smarter by automating workflows across apps and services. The Flow in a Day Lab is a beginner level lab for you to get hands on experience with Microsoft Flow.

Course Learning Objectives:

Introduction to Microsoft Flow
Introduction to Business Process Flows
Learn to build Flows
Flow Patterns
Sharing Flows
Debugging Flows
6 Hands on labs

Target Audience: Power Users and Developers who want to use workflows to automate streamline business process

Course Level: Beginner

Please bring a laptop with Microsoft Office Installed (Office 365 E3 tenant)
* Labs and demos will require a browser

Speakers

Craig Jahnke

Technical Architect, Concurrency, Inc

Craig helps clients develop strategies for implementing SharePoint and Office 365 solutions that allow their employees to best share information and data. He speaks at user groups, organizes SharePoint Saturday Chicago Suburbs, and loves to talk with others about technology and how... Read More →

Monday April 8, 2019 9:00am - 5:00pm CDT
Rock River I & II

Academy session (separate registration required)

9:00am CDT

Academy - Power Query, Data Modeling and DAX Practical Exercises ($599)

Register to attend the class or follow the instructions below to include registration for the Power BI 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 to 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 Query, Data Modelling and DAX practical exercises
Power Query and DAX are the important components of Power BI. They help you clean and analyze huge amounts of data.

During this full-day workshop, Mike Carlo & Seth Bauer (Microsoft Data Platform MVP & Owners of PowerBI.Tips) will teach through practical exercises and real life scenarios.

Participants are provided with the slides, exercises, and solutions for this workshop.

Learning Objectives:
- Power Query: Deep Dive and Best practices (morning)
- Data Modelling: the why and how ? Understanding the Power BI engine - Best practices and optimization (morning - afternoon)
- DAX: Calculated Columns, Measures, Time-Intelligence Calculations (afternoon). Best practices and optimization.

Audience: Business Analyst, Data Analyst, IT analyst.

Level: Beginner to Intermediate. Advanced users are also welcome, especially for the best practices.

Prerequisites: A very basic knowledge of Power BI. Bring in your laptops with Power BI Desktop installed (Latest Version Preferred).

Preparation: Bring Laptops, with Latest Version of Power BI installed.

Speakers

Seth Bauer

Managing Architect, Concurrency

Mike Carlo

Owner, PowerBI.Tips

I'm very passionate about data and analytics. I've spent a massive amount of time learning Power BI. Through this learning process I felt that others may also be interested. Thus, I created a website, a knowledge repository for all things PowerBI, ( powerbi.tips ). This site is uniquely... Read More →

Monday April 8, 2019 9:00am - 5:00pm CDT
Ohio River I & II

Academy session (separate registration required)

1:00pm CDT

Academy - Power BI, Teams, and SharePoint: Better Together? ($349)

Register to attend the class or follow the instructions below to include registration for the Power BI 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 to 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 BI, Teams, and SharePoint: Better Together?

Power BI, Teams and SharePoint are all based on Office 365 groups and can be used individually or together. Using them in concert requires care and planning if you want to avoid a governance nightmare. This 1/2 day course will explore the technical underpinnings of Workspaces, SharePoint Sites and Teams. We will look at different administrative options (but be aware that this class is not designed for administrators).
We will explore using SharePoint as a content source for Power BI, and Power BI as a content source for Teams and SharePoint.
Finally, we will discuss questions around the governance of Teams, Workspaces and SharePoint sites. The class is not designed to deliver 'thou shall' and 'thou shall not' principles. Rather, we hope that it will provide a forum for interested users to discuss and think through how to have a working environment that maximizes the strengths of all three tools, while minimizing administrative overhead.

Understand and administer O365 groups
Use SharePoint content in Power BI
Use Power BI content in Teams and SharePoint
Leverage Teams and Workspaces as a complementary collaborative platform
Think through governance issues related to all three applications, as they affect each other

Target Audience:
Power users of SharePoint/Teams and Power BI
Power BI, Teams, or SharePoint administrators
Data governance professionals

Course Level:
Intermediate

Pre-requisite:
Having used these three platforms will be helpful for participants as we won't be exploring basic features of these platforms.

Speakers

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 →

Monday April 8, 2019 1:00pm - 5:00pm CDT
Mississippi River I & II

Academy session (separate registration required)

8:00am CDT

Registration & Breakfast

Tuesday April 9, 2019 8:00am - 9:00am CDT
Ballroom Foyer/Pre-Function Area

Registration

9:00am CDT

Conference Kickoff: Introductions & Networking

Tuesday April 9, 2019 9:00am - 9:30am CDT
Salon A,B,C,D

Networking

9:30am CDT

General Session/Keynote

Speakers

Matthew Bolanos

Design Researcher, Microsoft

Manas Maheshwari

Sr. Program Manager, Microsoft

Tuesday April 9, 2019 9:30am - 10:30am CDT
Salon A,B,C,D

General Session

10:30am CDT

Networking Break

Tuesday April 9, 2019 10:30am - 10:45am CDT
Ballroom Foyer/Pre-Function Area

Networking

10:45am CDT

Power Platform 101 for New/Business Users

This live demo and interactive session will give any novice the information and inspiration to start using Power Platform for any business application in your organization.

Everything you need to know about Power BI, Power App & Flow- What is it & what is it good for?
How Power Platform can be utilized for a wide variety of application including, Sales, HR, Finance, Operations…
Practical demos of how a business user can build and get value from Power Platform quickly and easily

Speakers

Darren Goonawardana

Director, Managility Business Intelligence Solutions

Planning & Analytics with Power BIEnterprise Performance Management - Budgeting, Forecasting, FP&A

Tuesday April 9, 2019 10:45am - 11:45am CDT
Salon A,B,C,D

New Business User, Basic

10:45am CDT

Let's Talk About Your Data Model: Data Modeling Techniques for Power BI

With examples of real problems and (attempted) solutions, this presentation will examine dimensional modeling techniques which simplify and speed up measure evaluation. A fast-paced look at some common and uncommon reporting scenarios, including:

- All manner of date calculations and comparisons
- Slowly changing dimensions
- Events in progress
- Conditional evaluation of measures

By the end of this talk, you should have a stronger understanding of the right questions to ask that will make your BI solution simpler for end users and more performant at run-time.

Attendees are expected to have built a solution in Power BI before.

Don't miss this presentation rated one of the best of the 2018 World Tour.

Speakers

Greg Baldini

Owner, Baldini Un Limited

Tuesday April 9, 2019 10:45am - 11:45am CDT
Salon E,F,G

Power User, Intermediate

10:45am CDT

Get Started Using PowerApps and Flow

Wanting to start using PowerApps and Flow but not sure where to start you have come to the right place

Items Covered:
What does a PowerApps and Flow look like(examples of)
Creating a PowerApp
What about the data(data sources)
My first PowerApp and lessons learned
Getting into the Flow (adding logic)
Resources at your finger tips and a lot are Free
Is there a cost (licensing to be aware with Power Apps)
What next (suggested next steps to get started yourself)

Speakers

Craig Jahnke

Technical Architect, Concurrency, Inc

Mark Zerr

Technical Analyst, New Sunshine, LLC

Tuesday April 9, 2019 10:45am - 11:45am CDT
Ohio River I & II

PowerApps & Flow, Basic

10:45am CDT

Deconstructing Power BI

Do you know Power BI? More often than not, the vast majority say yes when they've only begun to scratch the surface. This session will delve into the underlying structures of Power BI and raise your awareness of all the different components that you are using.
Mixed in will be a slew of tips related to things to avoid and how to make the best choices for optimal performance.

Speakers

Seth Bauer

Managing Architect, Concurrency

Tuesday April 9, 2019 10:45am - 11:45am CDT
Rock River I & II

Technical, Intermediate

11:45am CDT

Networking Break

Tuesday April 9, 2019 11:45am - 12:00pm CDT
Ballroom Foyer/Pre-Function Area

Networking

12:00pm CDT

Solution Showcase: AI That Reads? How ThoughtTrace Uses AI to Reveal Critical Information from Unstructured Contract Data to Maximize Insights into Your Business Presented by ThoughtTrace

See a Power BI dashboard showing how AI and ML technology is closing the unstructured-to-actionable-data gap with ALI™ Data Insights from ThoughtTrace. During the session, we will have a live demonstration of how critical data can be surfaced in contracts and supplier agreements in just minutes, allowing human intelligence to focus on critical elements for analysis. This technology enables companies to integrate newfound data with their own internal data and systems to gain additional insights. Capabilities include: detailed visualizations that provide holistic insight into a range of use cases, report templates which can be used as a baseline to build custom reports, and the ability to integrate SQL data into existing systems.

Speakers

Catalina Herrera

Director of Education and Enablement, ThoughtTrace

Tuesday April 9, 2019 12:00pm - 12:30pm CDT
Rock River I & II

Solution Showcase

12:00pm CDT

Solution Showcase: Give Your Data the Audience It Deserves Presented by Metric Insights

Despite the investments that companies are making in BI, most business users are overwhelmed with information and often don’t know where to go to find the data that’s important to them. This causes low engagement with BI. Metric Insights’ Push Intelligence Platform integrates with your existing business intelligence tools, databases and operating systems and helps engage users with the right content at the right time via a consolidated portal, anomaly detection, distribution & alerting, and integration with Microsoft Teams. The presentation will uncover the root causes of the engagement problem and introduce Metric Insights as a solution that integrates with your Microsoft stack to drive increased user engagement with data.

Speakers

Louis Bedard

Director of Sales Engineering, Metric Insights

Over 20 years of Sales consulting experience working with Business Intelligence solutions. Worked in enterprise software sales to help companies with their Business Analytics strategy.

Tuesday April 9, 2019 12:00pm - 12:30pm CDT
Salon A,B,C,D

Solution Showcase

12:00pm CDT

Solution Showcase: Take Your BI Solution to the Next Level: A Summary of Data Strategy and Reporting Solution Components Presented by RSM US LLP

Interactive and dynamic reporting has changed the way that we see data. But more goes into a Business Intelligence solution than just the visualization tool. By understanding these components such as data warehousing, predictive analytics, data governance, data quality, and data strategy, you can comprehend the big picture of a BI solution that will allow you to increase understanding of your data and use that knowledge to impact change in your organization. This presentation will give a quick look into some of these areas that will bring your organization to a new level of business intelligence.

Speakers

Shawn Gilronan

Director, Business Intelligence & Analytics, RSM US LLP

Kathleen Buelt

Business Intelligence Consultant, RSM US LLP

Tuesday April 9, 2019 12:00pm - 12:30pm CDT
Salon E,F,G

Solution Showcase

12:00pm CDT

Solution Showcase: Tap into Advanced Analytics using the Power Platform Presented by SPR Consulting

We will take you through a use case that illustrates the use of analytics and machine learning (using Python and R) that can be used by business users to leverage advanced analytics to enhance their decision making process across their organization. We will show how citizen developers can use the Power platform (Power BI, PowerApps, and Flow) to access analytics, create simple thresholds, workflows, and notifications based on real time data to inform key stakeholders of changing business conditions and to proactively respond to these changes.

Speakers

Ray Johnson

Chief Data Scientist, SPR Consulting

Will Robinson

Senior Principal Architect, SPR Consulting

Tuesday April 9, 2019 12:00pm - 12:30pm CDT
Ohio River I & II

Solution Showcase

12:30pm CDT

Networking Lunch

Tuesday April 9, 2019 12:30pm - 1:30pm CDT
Atrium

Networking

1:30pm CDT

Making the Switch from Excel to Power BI

Benefits of having Dashboards and KPI's for Company metrics. Sharing Dashboards. Levels of Sharing. Permissions. Bookmarks. How to Publish a Dashboard. Creating Reports for separate divisions of the company.

Speakers

Craig Johnson

Director, Minnpar

Tuesday April 9, 2019 1:30pm - 2:30pm CDT
Salon A,B,C,D

New Business User, Basic

1:30pm CDT

Drive Digital Transformation with the Microsoft Power Platform

Stay ahead of the curve and drive innovation in your organization by digitizing business processes, without a single line of code. Introducing, Microsoft Power Platform!

Join us in this session to learn how to create applications, automate business processes and monitor your organization’s performances using Power Apps, Microsoft Flow and Power BI. We will perform a step-by-step demo showing how to create a mobile application, an approval flow and a Dashboard to track requests from a SharePoint list. In this session, we will work with a simple use case, based on real business requirements that all attendee can relate to.

Speakers

Luc Labelle

Consultant, Kabesa

Tuesday April 9, 2019 1:30pm - 2:30pm CDT
Salon E,F,G

Power User, Basic

1:30pm CDT

Better Business Apps with PowerApps and Flow

Do you want to better automate and streamline your business processes? Have you worked with PowerApps, Microsoft Flow, or Power BI, but you're not sure how to use them? You've come to the right place!
In this session we will explore how to build out a basic canvas app based on SharePoint lists and three key technologies that integrate with SharePoint Online: PowerApps, Microsoft Flow, and Power BI. These technologies work together, making it easy to measure your business, act on the results, and automate your workflows.

Speakers

Vivek Patel

Founder, Insight2Actions Inc.

Founder at Insight2Actions Inc and Director North America at Stridely Solutions Focus Area:-Power BI, PowerApps, FlowLinkedIn:- https://www.linkedin.com/in/insight2action/Vivek Patel is a Microsoft MVP (Data Platform), Founder at Insight2Actions Inc., User group Community leader-Toronto... Read More →

Tuesday April 9, 2019 1:30pm - 2:30pm CDT
Ohio River I & II

PowerApps & Flow

1:30pm CDT

Power BI Dataset Performance Tuning

Most PowerBI 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 PowerBI 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.

Speakers

Armando Lacerda

Senior BI & Azure Architect, DesignMind

Tuesday April 9, 2019 1:30pm - 2:30pm CDT
Rock River I & II

Technical, Intermediate

2:30pm CDT

Networking Break

Tuesday April 9, 2019 2:30pm - 2:45pm CDT
Ballroom Foyer/Pre-Function Area

Networking

2:45pm CDT

Practical Tips for a Successful Power BI Deployment

Power BI deployments are more likely to succeed with a detailed strategy in place. They sometimes struggle for several common but preventable reasons. What are some factors that increase your odds of success?

Perhaps your company is getting started with Power BI and needs a plan. Perhaps you already have Power BI widely deployed across your organization but have encountered several problems along the way. Perhaps you build reports and deploy apps, but no one views your content.

In this session, you will learn practical ways to approach key areas such as corporate sponsorship, communication, training, data quality, usability, security, performance, and more. Avoid pitfalls and learn what it takes to build a governance and deployment strategy that increases your Power BI adoption rate.

Speakers

David Eldersveld

Senior Consultant (Data & Analytics), BlueGranite

Tuesday April 9, 2019 2:45pm - 3:45pm CDT
Salon A,B,C,D

New Business User, Intermediate

2:45pm CDT

A "M"ind Bending Experience: Power Query for Power BI and Beyond

Session:
Power Query is quickly becoming the number one skill your employees NEED TO HAVE working in a modern workplace. Join Alex Powers as he demystifies the Power Query M Language, writing your own custom solutions and how to approach the language in a way that makes sense to both technical and non-technical users.

Format:
Learning to Read the M Language
Power Query for Power BI
Power Query for Microsoft Flow
Power Query for the Power BI service (DataFlows)

Speakers

Alex Powers

Owner Operator, t's Not About The Cell LLC

Tuesday April 9, 2019 2:45pm - 3:45pm CDT
Salon E,F,G

Power User, Intermediate

2:45pm CDT

PowerApps Roadmap and Recent Updates

Speakers

Manas Maheshwari

Sr. Program Manager, Microsoft

Matthew Bolanos

Design Researcher, Microsoft

Tuesday April 9, 2019 2:45pm - 3:45pm CDT
Ohio River I & II

PowerApps & Flow

2:45pm CDT

Building Modern Data Warehouse and BI Solution in Microsoft Cloud

Data warehouse and BI market is evolving rapidly with the appearance of new cloud born technologies. We might assume, that moving an existing Microsoft based DWH to the cloud is an easy step, but when we dig a little bit deeper, we will see, there are many-many new technological choices and aspects on how to modernize an existing dwh/bi system in the cloud. Not to mention if we start everything from scratch in a new project designed specifically to the cloud to utilize cloud flexibility and innovation as much as possible.
Which ETL tool should I use? Data factory v2 with SSIS and BIML, or Azure Databricks powered Dataflows? Or Power BI Dataflow? Which is the right decision to run OLAP workloads? Azure AS? Or simply Power BI? When do I need Azure SQL DWH?
In the last couple years I helped many customers to modernize their DWH landscape partially or fully in the cloud and during my presentation I will share my findings and recipes for the most common situation I met. You will have fun:)

Speakers

Gergely Csom

Head of Enterprise Analytics, Principal Consultant, Abylon

Tuesday April 9, 2019 2:45pm - 3:45pm CDT
Rock River I & II

Technical, Intermediate

3:45pm CDT

Networking Break

Tuesday April 9, 2019 3:45pm - 4:00pm CDT
Ballroom Foyer/Pre-Function Area

Networking

4:00pm CDT

Visualization Best Practices

To make sure our Power BI reports are adopted by end users, we must make sure their are in an easily understood and pleasing format.

In this presentation I will go over the Power BI visualizations Dos and Don'ts

Speakers

Samantha Boie

Data Analytics Functional Lead, SWS Technology Partners

Tuesday April 9, 2019 4:00pm - 5:00pm CDT
Salon A,B,C,D

New Business User, Intermediate

4:00pm CDT

Exploring Maps in Power BI

A well-crafted map draws viewers in with a blend of visual appeal and understandable content. As with any visual, you should put careful thought into how you represent locations in Power BI so that your users gain more insight into the data. Simply making maps is not enough if users cannot comprehend them.

With a Business Intelligence tool like Power BI, you do not have access to every bell and whistle that a professional GIS program offers. For a general business audience, however, Power BI has several ways to easily craft maps that work well for common use. Let's see what it can do!

Speakers

David Eldersveld

Senior Consultant (Data & Analytics), BlueGranite

Tuesday April 9, 2019 4:00pm - 5:00pm CDT
Salon E,F,G

Power User, Intermediate

4:00pm CDT

Leveraging Image Processing AI for Out-in-the-Field PowerApps (Telephone Pole Inspections)

In this 1 hour presentation/demo attendees will see how Azure's Cognitive Services and/or Machine Learning Services can be used together with PowerApps and SharePoint and Flow to quickly create an innovative AI-powered PowerApps which could be used by Field Engineers to quickly inspect and assess (and REPORT) the condition of various telephone and power distribution poles in a region suffering from (say) a severe weather phenomenon such a tornado or hurricane.

Attendees would also see how PowerApps can tap directly into the camera features of common mobile "smart" phones to capture images, pass them up into a SharePoint Picture library, then see how Flow can be used to pass those images (in REAL-TIME) into Azure Cognitive Services (or a custom Machine Learning Predictive Model) and have human-readable assessments describing that pole's condition as "Green" (ok), "Yellow" (watch closely) , "Orange" (needs attention ASAP) and "Red" (need attention IMMEDIATELY), so that field engineers can work quickly, and their central command can ALSO work quickly to accurately assess and triage a region impacted by a severe event.

Again, this presentation will also demonstrate how SharePoint, PowerApps and Flow can empower PowerUsers in an organization to quickly create enterprise-class solutions with MVC patterns at their foundation.

Speakers

Mark Vogt

Group Manager - Advanced Analytics Group, Avanade

Tuesday April 9, 2019 4:00pm - 5:00pm CDT
Ohio River I & II

PowerApps & Flow, Advanced

4:00pm CDT

In Depth Walkthrough of M from Gil Raviv's Book :"Collect, Combine and Transform Data Using Power Query"

Join the author of the book "Collect, Combine and Transform Data Using Power Query in Excel and Power BI" for an in depth walkthrough of M through excerpts from his book. Get a chance to win a free digital copy of the book, or gain a special 40% discount if you attend in-person.

This demo-packed session will take you through common data preparation scenarios and how to harness M in Power Query to resolve them.

Speakers

Gil Raviv

Director of Analytics, Avanade

Gil Raviv is an Author, Microsoft MVP, and a director on Avanade‘s Analytics team. As a former Senior Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query as the next-generation Get-Data and data-wrangling technology in Excel 2016... Read More →

Tuesday April 9, 2019 4:00pm - 5:00pm CDT
Rock River I & II

Technical, Advanced

5:00pm CDT

Welcome Reception

Tuesday April 9, 2019 5:00pm - 6:00pm CDT
Ballroom Foyer/Pre-Function Area

Networking

8:00am CDT

Registration & Breakfast

Wednesday April 10, 2019 8:00am - 9:00am CDT
Ballroom Foyer/Pre-Function Area

Registration

9:00am CDT

Top Tips and Tricks from PowerBI. Tips

In this session, we will demonstrate the top tips and tricks from the PowerBI.Tips ( https://powerbi.tips ) website. Presentation pulls from our latest grab bag of materials and tools (Theme Generator, Layouts, and some new tools) to showcase interesting and fun demo's that you won't want to miss. Skill level required for this session range from beginning to advanced users. You won't want to miss this opportunity!

Speakers

Mike Carlo

Owner, PowerBI.Tips

Wednesday April 10, 2019 9:00am - 10:00am CDT
Salon A,B,C,D

New Business User, Basic

9:00am CDT

Be A Power Platform Jedi - A Walkthrough of Power BI, PowerApps, Microsoft Flow and Cognitive Services Capabilities Through Star Wars Data

In this demo-packed session we will load, analyze and process Star Wars data into streamlined business processes that combine the Power Platform and AI to generate actionable insights. Join this session to learn the art of the possible and gain the Force of a Power Platform Jedi.

Speakers

Gil Raviv

Director of Analytics, Avanade

Wednesday April 10, 2019 9:00am - 10:00am CDT
Salon E,F,G

Power User, Advanced

9:00am CDT

Data Exceptions, Company Alerts Using Power BI and Flow Triggers

Session - How can you set up ways to keep your data clean and the whole company engaged with sales goals. Go through a few topics on how you can easily use flow to create simple alerts and notifications to the company or group of people.
Join this session to have a conversation and learn how to create integrated flows with Power BI reports. We will have a step-by-step conversation showing how to create a simple Power BI report, create a Power BI alert, set up the flow and connect to email, Teams and/or Slack.

Format:
- Questions
- Go through ways you can connect a data source and Power BI
- Create a simple Power BI reports for users to go through and clean up data exceptions
- Create flows that send out weekly reports as reminders for exceptions reports
- Create a simple sales goal tracker and how to use them to let the company you did well for the day, week, month, etc.
- Step up Power BI alerts for when you hit your goal
- Use Flow to send an email or post messages to slack and/or teams.”

Speakers

Andrew Woelfel

Business Intelligence Analyst II, Big Ass Fans

Wednesday April 10, 2019 9:00am - 10:00am CDT
Ohio River I & II

PowerApps & Flow, Basic

9:00am CDT

Manipulating Power BI Data with the PowerApps Visual

Take action on Power BI data and view the results instantly! This session will demonstrate a use case for how the PowerApps visual for Power BI can be used to manipulate data right inside Power BI reports. A demonstration will show how a PowerApp can be embedded inside of Power BI. The embedded PowerApp will write data to a back-end SQL Server table that by using a Composite model will allow us to view the results immediately inside of Power BI!

We'll also cover the PowerApps Visual V2 refresh feature that allows data directly inside the Power BI model to be updated.

Speakers

Jon Dobrzeniecki

Senior Data Analytics Consultant, Insight

Wednesday April 10, 2019 9:00am - 10:00am CDT
Rock River I & II

Technical, Advanced

10:00am CDT

Networking Break

Wednesday April 10, 2019 10:00am - 10:15am CDT
Ballroom Foyer/Pre-Function Area

Networking

10:15am CDT

Beginning DAX

Moving from Excel to thinking in Dax. Calculate, related and most common used Dax Functions. How to start with simple Dax Measures. Areas to create Dax Measures. Difference between Dax Measures and Calculated Columns. Quality Control and learning Filters and Dax Context.

Speakers

Greg Baldini

Owner, Baldini Un Limited

Wednesday April 10, 2019 10:15am - 11:15am CDT
Salon A,B,C,D

New Business User, Basic

10:15am CDT

Power Tools for Power BI

You have advanced skills in Power BI Desktop and utilize every feature to be a Power BI Pro, but did you know there is a world of community built power tools to enhance and expand your toolset?
This session is all about using 3rd party tools and how they can help your workflow and make you a true Power User with Power Tools! From being able to better test & document your Queries in Power Query and the M Language, to how to get data on your Data Models to optimize it and clean unneeded columns and tables, these tools will make your reports faster, your functions clearer, and boost your experience and process using Power BI!

Tools we will be covering and how to use:

M / Power Query

Notepad ++ for M
Using Excel to test Power Query
PowerQuery.io

DAX

DAX Studio
Notepad ++ for DAX
DAX Formatter
DAX.guide

Design

Custom Visual Gallery
Color Theme Generator
Layouts by PowerBI.tips
R Esquirrer

Advanced & MAJOR TOOLS

Vertipaq Analyzer
Power BI Helper
Power BI Documenter
Tabular Editor
Lingo

Speakers

Tommy Puglia

Senior Manager, Business Intelligence, CompTIA

Tommy Puglia is passionate about Power BI & how Data Analysis can impact decisions. Using Power BI since it was known as "Power BI Designer", he consumes whatever he can to constantly learn and apply BI for Marketing & Sales. He is also a leader of the Tampa Power BI User Group... Read More →

Wednesday April 10, 2019 10:15am - 11:15am CDT
Salon E,F,G

Power User, Advanced

10:15am CDT

Create Your First Application with PowerApps

Create and share applications with Power Apps, in a few clicks, without a single line of code.

Join us in this session to learn how to create and share applications with PowerApps. We will perform a step-by-step demo showing how to connect to a data source, build a the New, Edit and View forms, customize the layouts and share it to the organization. In this session, we will work with a simple use case, based on real business requirements that all attendee can relate to.

Speakers

Luc Labelle

Consultant, Kabesa

Wednesday April 10, 2019 10:15am - 11:15am CDT
Ohio River I & II

PowerApps & Flow, Intermediate

10:15am CDT

Practical Deep Dive Into Data Science with Power BI

A technical walk through of integrating Azure Machine Learning with Power BI

Speakers

Ryan Erdmann

Wednesday April 10, 2019 10:15am - 11:15am CDT
Rock River I & II

Technical, Intermediate

11:15am CDT

Networking Break

Wednesday April 10, 2019 11:15am - 11:30am CDT
Ballroom Foyer/Pre-Function Area

Networking

11:30am CDT

Solution Showcase: A Strategy Enterprise BI Practice and How Aptude Can Boost Your Organization Presented by Aptude

Your organization may be rapidly implementing Enterprise BI Solutions, but what happens when you run across issues that your internal team simply cannot resolve? What kinds of problems have companies encountered in the past and what are the best solutions to solve them? Our team will discuss how and when to anticipate different kinds of problems in the enterprise level and whether or not it should be handled internally, or if it’s better to bring in a consulting firm like us. We will present several recent case studies that detail the methods we utilized to solve unexpected roadblocks when implementing Power platform, AI and Azure services.

Speakers

Guy De Rosa

Senior VP – Information Technology, Aptude

Erich DeJesus

Chief Architect-Power Platform, Aptude

Vishal Parwar

Chief Architect-Analytics, Aptude

Wednesday April 10, 2019 11:30am - 12:00pm CDT
Salon E,F,G

Solution Showcase

11:30am CDT

Solution Showcase: Creating Effective Dashboards: Techniques to Create a Compelling Analytical Journey Presented by Ironedge Group

We are conditioned to respond to information from an early age. The way we are trained to read and perceive colors influences the way in which we consume information. In this session, we will discuss the process of transforming a business need into an analytical process while utilizing color, location, size and native Power BI functionality to create compelling dashboards.

Speakers

George Sturrock

Director of Business Intelligence, Ironedge Group

Wednesday April 10, 2019 11:30am - 12:00pm CDT
Rock River I & II

Solution Showcase

11:30am CDT

Solution Showcase: Enhance Field Service Implementations with PowerApps, QnA Maker and Custom Vision Presented by HCL Power Objects

Many field service users are required to carry product manuals to have immediate access to vital information regarding product/service repairs and replacements. In several cases, they are also required to identify broken parts. See how PowerApps, QnA Maker chat bot and Microsoft’s Custom Vision can digitize use cases like these, enhance users’ experience and make them a lot more quick and efficient on the road!

Speakers

Alex Fagundes

Director & Chief Architect, HCL PowerObjects

With tremendous knowledge and mad skills in application and infrastructure architecture and design, Alex’s roles include providing day-to-day technical direction and leadership for our development, cloud infrastructure, and support teams, as well as ensuring cybersecurity for PowerObjects.Alex... Read More →

Venkat Rao

Capability Director, HCL PowerObject

Wednesday April 10, 2019 11:30am - 12:00pm CDT
Ohio River I & II

Solution Showcase

12:00pm CDT

Networking Lunch

Wednesday April 10, 2019 12:00pm - 1:00pm CDT
Atrium

Networking

1:00pm CDT

Designing an Impactful KPI Scorecard in Power BI

Knowing the right visuals, DAX, and design to build out a professional scorecard report can be challenging. Learn about some great custom visuals in conjunction with DAX calculations to build out a quality scorecard template to use in your business. The scorecard talk will be broken down into three sections. Section One will cover the basics of the report layout & design, native card visuals, and supporting DAX. Section Two will cover custom visuals, KPI’s, and additional supporting DAX. The final Section Three will cover visualization practices and design principals to clean up the report for delivery to the client.

Speakers

Reid Havens

Founder & CEO, Havens Consulting Inc

Wednesday April 10, 2019 1:00pm - 2:00pm CDT
Salon A,B,C,D

New Business User, Intermediate

1:00pm CDT

Analytics with a Custom Built Connector

Abstract:
Explore the endless possibilities of leveraging Power BI on your data sources. We will see how a powerful data visualization tool connects with a powerful planning tool which lacks desired reporting, dashboard, and visualization capabilities. In this session, learn how PowerBI Custom Connectors capability can allow you to enhance your data visualization power. We will use the popular tool, Anaplan, and the supplied Anaplan API calls to create a series of custom connectors to bring data easily into PowerBI.
Session Outline:
• Custom Connector Basics
• API Basics
• The Anaplan API and Anaplan environment at a high level
• Basic steps of how to create custom connector
• Custom Connector Demo
• Utilizing power BI- Demo

Speakers

Mario Arias

Sr BI Consultant, TekLink International Inc.

Wednesday April 10, 2019 1:00pm - 2:00pm CDT
Salon E,F,G

Power User, Basic

1:00pm CDT

Best Practices for No-Code / Low-Code Development on Power Platform

It's time that we create some best practices for developing on the Power Platform! This session overviews some of the current favorites picked up from colleagues and experts around the world. When should we create new model-driven apps to serve different business functions? How should old time Dynamics lovers think about solutions when working in PowerApps? What's the best way to bring order to Flow in an enterprise environment? We'll explore questions like this, and learn from one another.

Speakers

Andrew Welch

Practice Director, Business Applications and Automation, Applied Information Sciences (AIS)

As the principal author of the Power Platform Adoption Framework, my primary focus in business applications is how large enterprise-grade organizations adopt the Microsoft Power Platform at scale. I lead the Business Applications and Automation Practice at Applied Information Sciences... Read More →

Wednesday April 10, 2019 1:00pm - 2:00pm CDT
Ohio River I & II

PowerApps & Flow, Intermediate

1:00pm CDT

Power BI Administration

Learn best practices for management and governance of Power BI including security considerations, monitoring, alerting, premium capacity with real-world demo and dive into the Power BI's admin capabilities.

Speakers

Nikil Prabhakar

Power BI Enthusiast, Obvience

Wednesday April 10, 2019 1:00pm - 2:00pm CDT
Rock River I & II

Technical, Intermediate

2:00pm CDT

Networking Break

Wednesday April 10, 2019 2:00pm - 2:15pm CDT
Ballroom Foyer/Pre-Function Area

Networking

2:15pm CDT

Let's Get High on Power BI

Are you relying heavily on Excel for your financial data? This session will help you begin the process of moving to Power BI to collect data and present it in a professional dashboard style of reporting. Tie into your system data sources and avoid the manual input requirements that can lead to errors and inconsistencies. You can spend your time analyzing your data and less time compiling data. Let us throw you a "bone" and entertain you with our innovative approach to financial reporting.

Objectives:

1. Build basic financial review elements within Power BI
2. Re-envision the way financial data is presented to leadership and stakeholders
3. Utilize real-time interactive data for your financial reporting allowing leadership to make more accurate and efficient decisions

Speakers

Barbara "Bo" Bowles

Explorer Pipeline

Rhonda Runde

Controller, Explorer Pipeline

Wednesday April 10, 2019 2:15pm - 3:15pm CDT
Salon A,B,C,D

New Business User, Basic

2:15pm CDT

Fixing the Adoption Dilemma - Techniques to make Analytics Use Pervasive

Dashboards, Reports, Charts and all ways to structure data for analysis is failing! Sound familiar? If so, the adoption dilemma is present and needs to be solved.

If users would rather get data dumped to them, rather than work with what they’ve been given, this session is for you!

We’ll give you techniques to solve the adoption dilemma and make analytics the hero of your organization without having to endure the pain of further purchasing, added frustration or the ongoing angst for something your organization simply does not have.
This session will talk to the culture of analytics and the ways you might marry the best work of those who prepare the data (often IT) with the work those should be doing to explore the data (everyone else)!

Attendees can expect to gain the following:
* Ways to culturally establish an air of analytics cooperation
* Means to identify when analytics burden the business process
* An ability to be a motivator and a mediator for analytics adoption

Speakers

Trey Johnson

Chief Evangelist, ZAP

Wednesday April 10, 2019 2:15pm - 3:15pm CDT
Salon E,F,G

Power User, Basic

2:15pm CDT

Transforming Data Into Reports Using the Power Platform

Do you need to make reports—based on user submitted data—available within your Office 365 environment? In this session, I will lead you on the journey from data entry to processing to reporting. We will take full advantage of the Power Platform (PowerApps, Microsoft Flow, and Power BI) and bring those together to deliver a complete solution that can reside in SharePoint or Microsoft Teams.

Speakers

Theresa Eller

Premier Field Engineer for SharePoint, Microsoft

Wednesday April 10, 2019 2:15pm - 3:15pm CDT
Ohio River I & II

PowerApps & Flow, Intermediate

2:15pm CDT

Power BI, PowerApps and Sharepoint - A Perfect Combination for Cloud Services

Power BI with its functionalities start moving Business Intelligence into the cloud. Embedding Power BI reports directly in SharePoint Online pages is now possible with no code required. SharePoint groups are ideally integrated with Power BI service which allows us to create App Workspaces within SharePoint itself.

Using a SharePoint lists we can manage information by gathering them in rows known as a list item. PowerApps is relatively new service offering very scalable and powerful custom business apps where data are connected across the web and mobile from the cloud. Both Power BI and PowerApps embeds its visuals in the SharePoint page. Those three products seem to be well known for BI data professionals as a daily basis reporting and sharing platforms.

However, how can we be more efficient and use them simultaneously as one integrated environment? At this session, not only we will explore the features, but we’ll look at how to best use them together.

Speakers

Jakub Barzyk

Sr. Business Intelligence Consultant, Webstep

Wednesday April 10, 2019 2:15pm - 3:15pm CDT
Rock River I & II

Technical, Intermediate

3:15pm CDT

Networking Break

Wednesday April 10, 2019 3:15pm - 3:30pm CDT
Ballroom Foyer/Pre-Function Area

Networking

3:30pm CDT

Panel Discussion

Wednesday April 10, 2019 3:30pm - 4:00pm CDT
Salon A,B,C,D

General Session