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
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.
• 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
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
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!
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.
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.
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.