Loading…

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

Wednesday, September 11
 

8:00am

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

Wednesday September 11, 2019 8:00am - 9:00am
TBA

9:00am

Conference Kickoff: Introductions & Networking
Wednesday September 11, 2019 9:00am - 9:30am
206 C&D

9:30am

General Session/Keynote
Speakers

Wednesday September 11, 2019 9:30am - 10:30am
206 C&D

10:30am

Networking Break/Expo
Wednesday September 11, 2019 10:30am - 10:45am
TBA

10:45am

Getting you and your team started with Power BI Desktop
We will be using Power BI to design a Dashboard over financial data, this Dashboard will help management analyze Sales pattern with the help of different visuals.
The session will cover up Data Source parametrization, basic Data Modelling, Quick Measures, Custom Formatting, Themes & Visuals, Utilize Bookmarks & Tooltips, What If Analysis, Optimize Web & Phone layout, Share & Collaborate.
You will learn how you can turn raw data into actionable insights using Power BI

Speakers

Wednesday September 11, 2019 10:45am - 11:45am
205 A

10:45am

There's No Time Like the Present - Real Time data in Power BI
Real time and near real time data scenarios in Power BI

Speakers

Wednesday September 11, 2019 10:45am - 11:45am
206 C

10:45am

Starting Your Power Platform Journey
The journey to digitize, automate and surface actionable insights is a challenge many companies face. Constraints in budget, resources and timelines often slow this journey to a halt - if they begin at all. However, Microsoft continues to evolve the Power Platform (PowerApps, Flow, PowerBI) to help you along your journey and create solutions to transform the way people work in an incredible efficient manner.


Wednesday September 11, 2019 10:45am - 11:45am
205 B

10:45am

Around the World in 60 minutes - How to create Enterprise-wide Multilingual PowerApps
Supporting multiple languages for corporations is a necessity in multilingual countries, such as Canada, Belgium, Italy, and others. The same applies to organizations having a workforce that is distributed across the globe. One common challenge in building solutions to support multilingualism is the creation and maintenance of such solutions as they evolve and more languages are added.

In this session, we will implement a PowerApps framework for supporting multiple languages. Elements that will be covered include static labels, list entries, caching, and more.

Speakers
avatar for Haniel Croitoru

Haniel Croitoru

Enterprise Architect, Protiviti
Senior Office 365 and SharePoint Consultant and Office 365 MVP with over 15 years of experience in public and private sector and various verticals. Since 2003 I have been focusing on SharePoint, delivering solutions and contributing as a SharePoint consultant, project manager, business... Read More →


Wednesday September 11, 2019 10:45am - 11:45am
205 C

11:45am

Networking Break/Expo
Wednesday September 11, 2019 11:45am - 12:00pm
TBA

12:00pm

Solution Showcase: AI Builder in Flows – how to leverage AI in your automated processes Presented by XRM Vision
In this session you will be presented with a series if steps that demonstrate how AI Builder can help automate a process that would normally require a human action.

Highlights features covered:
  • Microsoft Flow
  • AI Builder - Text Classification
  • Aquaforest PDF Converter
Use case covered:

Automatically distribute invoices and purchase orders that have been deposited in OneDrive folder to the right department.

Speakers
avatar for Éric Sauvé @ZePowerDiver

Éric Sauvé @ZePowerDiver

Dynamics 365 & Power Apps Solution Architect, XRM Vision
I'm a passionate about the Power Platform with a strong background in Dynamics 365 (CRM / CE). Involved in the community via social medias, blogs, forums etc under handle @ZePowerDiver. I love to share what I've learn and also learn more and more every day, be part of my journey... Read More →



Wednesday September 11, 2019 12:00pm - 12:30pm
206 C

12:30pm

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

Wednesday September 11, 2019 12:30pm - 1:30pm
206 A & B

1:30pm

Data Visualization 101-Best Practices from the Real World
Power BI is powerful tool for data visualization & Business Intelligence. With great power comes many pitfalls, especially for new or business users.

In this session you will learn how to avoid the most common pitfalls and to maximize your insights.
We will explore the tips, tricks and best practices of the masters of visualizations including Edward Tufte, Stephen Few & dive into the latest IBCS (International Business Communication Standards).

You will leave with some great concepts that you will have a practical knowledge of how to implement in Power BI to wow your boss.

Speakers
avatar for Darren Goonawardana

Darren Goonawardana

Director, Managility Business Intelligence Solutions
Planning & Analytics with Power BIEnterprise Performance Management - Budgeting, Forecasting, FP&A


Wednesday September 11, 2019 1:30pm - 2:30pm
205 A

1:30pm

How to maximize the use of Flow, SQL, and Power BI with JSON
Microsoft Flow speaks the language of JSON (JavaScript Object Notation) - it's the proverbial glue that lets it talk to SharePoint, Outlook, Excel, SQL server, and a myriad of other services. We'll take a look at simple ways to really harness the full horsepower of Flow, when playing with JSON. This hands-on session will introduce JSON and how it can be harnessed to do some very handy (and powerful) stuff with the Power Platform! We'll cover how to generate, handle, and generally play with JSON in Flow, PowerApps, and Power BI. As an example, we'll cover some specific examples:

How to slide, dice, and play with JSON in Microsoft Flow;
Use Flow to sync hundreds or thousands of records in Azure SQL in mere seconds;
Use JSON for dead-simple Power BI reporting;


Wednesday September 11, 2019 1:30pm - 2:30pm
206 C

1:30pm

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 September 11, 2019 1:30pm - 2:30pm
205 B

1:30pm

Build an End to End Solution Using the Microsoft Flow Mobile App to Empower Teamwork in your Organization
Learn how to use the rich toolkits provided by Microsoft such as the Microsoft Flow Mobile App to empower teamwork in your organization. Join us for an end to end demo on how you can easily use these toolkits including MS Flow Mobile App, SharePoint Online Lists, PowerApps and Microsoft Teams apps, to solve your business automation challenges.

Speakers
avatar for Noorez Khamis

Noorez Khamis

VP Technology, Creospark
Microsoft Office 365 MVP with experience in Power Platform, Teams and SharePoint


Wednesday September 11, 2019 1:30pm - 2:30pm
205 C

2:30pm

Networking Break/Expo
Wednesday September 11, 2019 2:30pm - 2:45pm
TBA

2:45pm

Data Modeling and DAX Practices
• Definitions of measures, calculated columns and calculated tables
• Use cases of basic DAX function – Aggregators, Iterators
• Fundamentals of row and filter context
• Solving modelling problems using DAX vs Power Query

Speakers

Wednesday September 11, 2019 2:45pm - 3:45pm
205 A

2:45pm

Machine Learning and Predictive Modeling in Power BI
Machine learning is a data science technique to use massive historical data to forecast future behaviors, outcomes, and trends without being explicitly programmed. This session will introduce how to incorporate Machine Learning predictive models into Power BI to gain better predictions and insights about the future.

The ability to visualize and invoke insights from these models, in your reports and dashboards and other analytics, can help disseminate these insights to the business users who need it the most. This makes collaboration among business analysts and data scientists easier and faster than ever before.

Speakers
avatar for Ashraf Ghonaim

Ashraf Ghonaim

Strategic Management and Analytics Consultant, City of Toronto
Ashraf Ghonaim is a Strategic Management Consultant at the City of Toronto. He holds a Computer Engineering degree and an MBA degree in Strategic Management with special emphasis on IT-Business Strategic Alignment using Balanced Scorecard. He is also a certified Balanced Scorecard... Read More →


Wednesday September 11, 2019 2:45pm - 3:45pm
206 C

2:45pm

Introduction with Canvas vs Model-Driven with CDS
Speakers
avatar for Nicolas Georgeault

Nicolas Georgeault

Owner - MVP - Office 365 Specialist, MuBrain Inc.
"For 30 years we have been building systems that enable human intelligence to collaborate and build collective intelligence together. It is now time to combine also the know-how of artificial intelligence."With more than 20 years of experience in knowledge management and in the design... Read More →


Wednesday September 11, 2019 2:45pm - 3:45pm
205 B

2:45pm

Augment your Power Platform solutions with Cognitive services
Embed AI capabilities in your PowerApps, Microsoft Flow and Power BI solutions and let Artificial Intelligence do the work for you.

Join us in this session to learn how to leverage the Cognitive Services from the Power Platform. We will demonstrate how Artificial Intelligence can help you and your organization save time and money by augmenting simple applications. In this session will work with simple use cases, based on real business requirements that all attendee can relate to.

Speakers
avatar for Luc Labelle

Luc Labelle

Consultant, Kabesa


Wednesday September 11, 2019 2:45pm - 3:45pm
205 C

3:45pm

Networking Break/Expo
Wednesday September 11, 2019 3:45pm - 4:00pm
TBA

4:00pm

Storytelling in Power BI
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 →


Wednesday September 11, 2019 4:00pm - 5:00pm
205 A

4:00pm

Power Platform for Finance - A Game Changer
Power BI, Power Apps & Flow is a powerful combination that is changing the way finance professionals work.
Are you spending too much time and effort on menial non-value add tasks?
Want to change your finance function from cost center to strategic value creator?

During this session you will learn how to integrate Power BI, Power Apps & Flow to address common Finance requirements for Analytics, Forecasting, Modeling, Collaboration & Approvals.

This will be a mix of education and live demonstrations

We will also cover
• Principles of effective information design: best visuals and common mistakes to avoid
• Best practice for building financial models in Power BI
• Tips & tricks to build professional finance reports
• Variance and other typical calculations required for business users
• How to effectively display KPI’s and variances
• Data entry, planning & forecasting
• Workflows & Approvals

Speakers
avatar for Darren Goonawardana

Darren Goonawardana

Director, Managility Business Intelligence Solutions
Planning & Analytics with Power BIEnterprise Performance Management - Budgeting, Forecasting, FP&A


Wednesday September 11, 2019 4:00pm - 5:00pm
205 B

4:00pm

Planning Properly for a Successful Implementations of Flow, PowerApps & PowerBI
With all of the excitement around the Power Platform that includes Flow, PowerApps & PowerBI companies are diving in and that is GREAT! However, diving in means moving too quickly without proper planning. Planning is the #1 most important thing to ensure introducing not only a new process into your organization but the overall impression of the application being used that delivers that process.

This session will help you with starting your new process implementation the right way. Which means starting from the very beginning and not in the middle. If done properly they ROI of the process is higher as creation\build of the process can be done once, with minimal UAT time and then a successful deployment. Your success will be measured on the fact the organization is utilizing the new process and if done right you will be a Rockstar with huge success.

Speakers
avatar for Stacy-Deere Strole

Stacy-Deere Strole

Microsoft MVP | Owner Focal Point Solutions, Focal Point Solutions
Stacy Deere-Strole is the Owner of Focal Point Solutions LLC, a Cincinnati, OH based company that provides SharePoint Solutions for the Enterprise in the mid-to-large market. With nearly 18 years of experience in the IT Industry, she also co-authored two books called SharePoint 2013... Read More →


Wednesday September 11, 2019 4:00pm - 5:00pm
205 C

5:00pm

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

Wednesday September 11, 2019 5:00pm - 6:00pm
206 A & B
 
Thursday, September 12
 

8:00am

Registration/Breakfast/Expo
If you have not already registered, get your registration pass for the event, grab some breakfast and visit with the sponsors in the expo area!

Thursday September 12, 2019 8:00am - 9:00am
TBA

9:00am

Using the Power Platform to empower Financial accountability
Hôpital Montfort has been improving business practices with Office 365 since the Power Platform's predecessors : Infopath, SharePoint Workflows, and Power Pivot for Excel Web Services. Today Power BI, Flow, and PowerApps is leveraged in every corner of the Hospital from HR, Finance, Health and Safety, Training, and even informing Medical practice! This session looks at key success factors to organisational deployments of the Power Platform based on 3 key strategic pillars : Quality, Sustainability, and Usability.

We'll be diving into each of those pillars with demos and examples using one of one our older and most complete solutions : How Montfort leveraged the Power Platform to empower financial accountability - think of Flow, PowerApps, and Power BI working together for financial reporting at every level.

The technical demos will show you what's possible with RLS, Flow & SQL, PowerApps components, Power BI Admin Capabilities, Custom Graph Connectors - and even more!


Thursday September 12, 2019 9:00am - 10:00am
205 A

9:00am

Visual Guidance for Power BI
How do we make our report answer a business question in a glance?
Implementing UI/UX rules and best practices when designing a PowerBI report. What are the best and worst reports and how the "fun factor" is not always the best choice to answer a real business need.
We will explore what should you consider when you create visual guidance and governance for your organizational PowerBI reports. Which key components are important when choosing colors, working with visuals and keeping your reports designed according to UI and UX standards? How are mobile reports different than the desktop?

Speakers
avatar for Yana Berkovich

Yana Berkovich

Microsoft



Thursday September 12, 2019 9:00am - 10:00am
206 C

9:00am

You've got an error in your Flow? Great, let's deal with it
You've just built your first "Hello, World!" flow. Now it's time to get serious. One thing you need to consider is your error handling... because errors happen whether you like it or not. At times you may be able to capture errors and correct them before they cause a problem, while other times you wont.
In this session, I'll be discussing techniques to identify errors, correct them in run-time, and report on them in various ways. If your Flows affect how your users work, then you shouldn't miss this session.

Speakers
avatar for Haniel Croitoru

Haniel Croitoru

Enterprise Architect, Protiviti
Senior Office 365 and SharePoint Consultant and Office 365 MVP with over 15 years of experience in public and private sector and various verticals. Since 2003 I have been focusing on SharePoint, delivering solutions and contributing as a SharePoint consultant, project manager, business... Read More →


Thursday September 12, 2019 9:00am - 10:00am
205 B

9:00am

Enterprise Management - how to Adopt and Govern your apps in the real world
Mature organizations realize that rigor, discipline, and best practices are needed to truly adopt the platform at scale.
The Power Platform Adoption Framework is the start-to-finish approach for adopting the platform at scale.
It helps enterprise organizations:
• Get to value quickly
• Educate, train, and grow their community of citizen developers and power users
• Create durable partnerships between business, IT, and the user group community
• Continuously improve ROI on the platform by identifying and migrating new workloads
• Blend agile app development with rigorous enterprise management and governance

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 →


Thursday September 12, 2019 9:00am - 10:00am
206 D

10:00am

Networking Break/Expo
Thursday September 12, 2019 10:00am - 10:15am
TBA

10:15am

A Tour of Power Query and M
In this session we'll see how Power Query, and the M formula language it runs on, can be used to connect to different data sources; and transform, restructure, and combine them into into a Data Model that can then be analyzed in Power Pivot or Power BI.

Speakers

Thursday September 12, 2019 10:15am - 11:15am
205 A

10:15am

Power BI Report Server Architecture and Best Practice
To improve the performance, sustainability, security and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere to best practices. Vishal will share how he manage tons of Power BI based dashboards that clients used every day to drive sales, operations, and marketing for enterprise users. This is session will be really focused on various of Power BI vertical – Power BI service, Power BI report server and Power BI premium. In this session, Vishal Will be covering Power BI Report Server Architecture and Best Practice. How we can get benefited by implementing and considering various following artifact -Power BI Project Life cycle, Agile Methodology, Naming Standards, Development, Server Size, Administration, Security, Demo.

Speakers
avatar for Vishal Pawar

Vishal Pawar

Principal BI Architect, Green House Data
I am currently working for Green House Data as Principal BI Architect, specializing in Power Platform, Business Intelligence, Artificial Intelligence, Big Data (Hadoop), Machine Learning, Azure Cloud, and Data Warehousing.Vishal has over ten years of experience focused on delivering... Read More →


Thursday September 12, 2019 10:15am - 11:15am
206 C

10:15am

10:15am

Error handling in Flow, with Monitoring activities using PowerShell and Power BI
This session includes different error handling methods in Microsoft flows.

Get the flow activities for each instances of flow using PowerShell script. We can get list of flow and its status, each flow run with its success/failure status etc. We run PowerShell and store run history records from all environment into our database so we can monitor overall tenant from one place not limited to 30 days.

From the data received from PowerShell, we will visualize it in Power BI that shows list of all flows, its running/success/failure status etc. Also we can use it to analyze over the different period of time.

Speakers

Thursday September 12, 2019 10:15am - 11:15am
206 D

11:15am

Networking Break/Expo
Thursday September 12, 2019 11:15am - 11:30am
TBA

11:30am

Solution Showcase: Customer Spotlight: How-to Automate Business Processes Using D365 + PowerApps Presented by Alithya
Ready to take your processes to the next level in automation?  Already using Dynamics 365?  Want to learn how others are using PowerApps?  Join us to see how PAR Technology is leveraging D365 + PowerApps to automate all the process  associated with new restaurant installation – this technology helps automate everything from: the scheduling, the subcontractors they use, the purchase orders and the approvals associated in addition to all the accounting.

Speakers
RC

Ryan Casey

Vice President, Consulting, Alithya


Thursday September 12, 2019 11:30am - 12:00pm
206 C

12:00pm

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

Thursday September 12, 2019 12:00pm - 1:00pm
TBA

1:00pm

What's New and Exciting With Power BI for the Business User
Congratulations! Your organization got PowerBI! This is exciting!
You want to start making data driven decisions and create those cool dashboards.
How your life can change even if the IT is not involved and your ticket is not prioritized?
How do you begin? What should you ask your IT for?
Using Microsoft HR and Marketing and Financial data sets, we will explore how HR, Marketing and Finance professionals can easily answer their business questions and get better results with their data and reports. Participants with PowerBI on their machines can follow the example.

Speakers
avatar for Yana Berkovich

Yana Berkovich

Microsoft



Thursday September 12, 2019 1:00pm - 2:00pm
205 A

1:00pm

Bridging Databricks to Power BI using CDM Folders
Join Simon Nuss as he explores the world of enterprise-scale big data.  During this presentation he will demonstrate how CDM Folders marry the scale-out compute of Apache Spark under Azure Databricks with the agility of Power BI.

Speakers

Thursday September 12, 2019 1:00pm - 2:00pm
206 C

1:00pm

PowerApps and Flow Hands On Lab
2hour- hands on lab

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 →


Thursday September 12, 2019 1:00pm - 2:00pm
205 B

1:00pm

The Power Platform to the power of DevOps
With power comes great responsibility. Learn how to harness the power of Azure DevOps to manage, deploy and maintain an unprecedented wave of Power Platform components that are developed across the enterprise by all citizen developers.

Automation across the entire asset development lifecycle is the solution. We will cover the path traveled by components from inception to full production, high-light potential automation touch points and automate testing and deployment processes, using real life examples.

Speakers

Thursday September 12, 2019 1:00pm - 2:00pm
206 D

2:00pm

Networking Break/Expo
Thursday September 12, 2019 2:00pm - 2:15pm
TBA

2:15pm

CAA-Quebec’s journey implementing Power BI
CAA Quebec (AAA Quebec Club) has embraced and acknowledged the endless possibilities of Power BI. I will explain the steps we followed over the last couple of years to get to where we are today, showing how upgrading to Premium has been an invaluable investment for our organization. A complete overview of how Power BI changed the way we transform, analyse and share data.

Speakers
avatar for Philippe Lahaie

Philippe Lahaie

BI Analyst, CAA-Quebec


Thursday September 12, 2019 2:15pm - 3:15pm
205 A

2:15pm

AI and Cognitive Services in Power BI
With the massive volumes of data generated today about every aspect of a business finding deep insights from the data can be challenging. This session will introduce how to incorporate the sophisticated pre-trained machine learning models into Power BI.

AI and Cognitive Services provide powerful ways to extract actionable insights from a variety of unstructured sources like documents, images, and social media feeds through Azure Services like Sentiment Analysis, Key Phrase Extraction, Language Detection, and Image Tagging.

Speakers
avatar for Ashraf Ghonaim

Ashraf Ghonaim

Strategic Management and Analytics Consultant, City of Toronto
Ashraf Ghonaim is a Strategic Management Consultant at the City of Toronto. He holds a Computer Engineering degree and an MBA degree in Strategic Management with special emphasis on IT-Business Strategic Alignment using Balanced Scorecard. He is also a certified Balanced Scorecard... Read More →


Thursday September 12, 2019 2:15pm - 3:15pm
206 C

2:15pm

PowerApps and Flow Hands On Lab Continued
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 →


Thursday September 12, 2019 2:15pm - 3:15pm
205 B

2:15pm

Introduction to the PowerApps Component Framework
The PowerApps component framework allows pro developers to use TypeScript to create custom UI components which can then be used by citizen developers in their Model-Driven PowerApps and eventually Canvas PowerApps as well! Join a member of the framework product team to dive into how to get started with the framework, some of the things you should follow as you create your component, how to deploy your code, and what new features you can expect in the coming months.

Speakers
avatar for Greg Hurlman

Greg Hurlman

Developer, PowerApps Engineering, Microsoft



Thursday September 12, 2019 2:15pm - 3:15pm
206 D

3:15pm

Networking Break/Expo
Thursday September 12, 2019 3:15pm - 3:30pm
TBA

3:30pm

Panel Discussion/Sponsors Raffle Drawings
First five-minutes will be Sponsors drawing for the winners of their booth raffles!
Following will be a Q & A session with a panel of Experts!

Thursday September 12, 2019 3:30pm - 4:00pm
206 D