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
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.
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.
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 EDT
205 C
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.
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 →
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.
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;
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.
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 EDT
205 B
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.
• 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
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.
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 EDT
206 C
"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 EDT
205 B
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.
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 EDT
205 A
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
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.
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 EDT
205 C
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!
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?
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.
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 EDT
205 B
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
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 EDT
206 D
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.
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.
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 EDT
206 C
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.
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.
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.
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.
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 EDT
205 B
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.
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.
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.
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 EDT
206 C
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 EDT
205 B
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.
