Chicago Power Platform World Tour

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

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.

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.

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.

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:)

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.

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.

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

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.

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.

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.