Loading…

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

Monday, April 8
 

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
avatar for Craig Jahnke

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

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
avatar for Seth Bauer

Seth Bauer

Managing Architect, Concurrency
avatar for Mike Carlo

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

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
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 →


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

8:00am CDT

9:00am CDT

9:30am CDT

General Session/Keynote
Speakers
avatar for Matthew Bolanos

Matthew Bolanos

Design Researcher, Microsoft
avatar for Manas  Maheshwari

Manas Maheshwari

Sr. Program Manager, Microsoft


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

10:30am CDT

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

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
avatar for Darren Goonawardana

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

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
avatar for Greg Baldini

Greg Baldini

Owner, Baldini Un Limited


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

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
avatar for Craig Jahnke

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 →
avatar for Mark Zerr

Mark Zerr

Technical Analyst, New Sunshine, LLC


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

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
avatar for Seth Bauer

Seth Bauer

Managing Architect, Concurrency


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

11:45am CDT

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

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
avatar for Catalina Herrera

Catalina Herrera

Director of Education and Enablement, ThoughtTrace


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

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
avatar for Louis Bedard

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

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
avatar for Shawn Gilronan

Shawn Gilronan

Director, Business Intelligence & Analytics, RSM US LLP
avatar for Kathleen Buelt

Kathleen Buelt

Business Intelligence Consultant, RSM US LLP


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

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
avatar for Ray Johnson

Ray Johnson

Chief Data Scientist, SPR Consulting
avatar for Will Robinson

Will Robinson

Senior Principal Architect, SPR Consulting


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

12:30pm CDT

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

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
avatar for Craig Johnson

Craig Johnson

Director, Minnpar


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

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
avatar for Luc Labelle

Luc Labelle

Consultant, Kabesa


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

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
avatar for Vivek Patel

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

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
avatar for Armando Lacerda

Armando Lacerda

Senior BI & Azure Architect, DesignMind


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

2:30pm CDT

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

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
avatar for David Eldersveld

David Eldersveld

Senior Consultant (Data & Analytics), BlueGranite


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

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
avatar for Alex Powers

Alex Powers

Owner Operator, t's Not About The Cell LLC


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

2:45pm CDT

PowerApps Roadmap and Recent Updates
Speakers
avatar for Manas  Maheshwari

Manas Maheshwari

Sr. Program Manager, Microsoft
avatar for Matthew Bolanos

Matthew Bolanos

Design Researcher, Microsoft


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

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
avatar for Gergely Csom

Gergely Csom

Head of Enterprise Analytics, Principal Consultant, Abylon


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

3:45pm CDT

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

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
avatar for Samantha Boie

Samantha Boie

Data Analytics Functional Lead, SWS Technology Partners


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

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
avatar for David Eldersveld

David Eldersveld

Senior Consultant (Data & Analytics), BlueGranite


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

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
avatar for Mark Vogt

Mark Vogt

Group Manager - Advanced Analytics Group, Avanade


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

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
avatar for Gil Raviv

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

5:00pm CDT

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

8:00am CDT

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
avatar for Mike Carlo

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 →


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

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
avatar for Gil Raviv

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 →


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

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
avatar for Andrew Woelfel

Andrew Woelfel

Business Intelligence Analyst II, Big Ass Fans


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

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
avatar for Jon Dobrzeniecki

Jon Dobrzeniecki

Senior Data Analytics Consultant, Insight


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

10:00am CDT

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

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
avatar for Greg Baldini

Greg Baldini

Owner, Baldini Un Limited


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

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
avatar for Tommy Puglia

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

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
avatar for Luc Labelle

Luc Labelle

Consultant, Kabesa


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

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

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

11:15am CDT

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

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
GD

Guy De Rosa

Senior VP – Information Technology, Aptude
avatar for Erich DeJesus

Erich DeJesus

Chief Architect-Power Platform, Aptude
avatar for Vishal Parwar

Vishal Parwar

Chief Architect-Analytics, Aptude


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

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
GS

George Sturrock

Director of Business Intelligence, Ironedge Group


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

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
avatar for Alex Fagundes

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 →
VR

Venkat Rao

Capability Director, HCL PowerObject


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

12:00pm CDT

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

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
avatar for Reid Havens

Reid Havens

Founder & CEO, Havens Consulting Inc


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

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
avatar for Mario Arias

Mario Arias

Sr BI Consultant, TekLink International Inc.


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

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
avatar for Andrew Welch

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

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
avatar for Nikil Prabhakar

Nikil Prabhakar

Power BI Enthusiast, Obvience


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

2:00pm CDT

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

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
BB

Barbara "Bo" Bowles

Explorer Pipeline
avatar for Rhonda Runde

Rhonda Runde

Controller, Explorer Pipeline


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

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
avatar for Trey Johnson

Trey Johnson

Chief Evangelist, ZAP


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

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
avatar for Theresa Eller

Theresa Eller

Premier Field Engineer for SharePoint, Microsoft


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

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
avatar for Jakub Barzyk

Jakub Barzyk

Sr. Business Intelligence Consultant, Webstep


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

3:15pm CDT

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

3:30pm CDT

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