Northwest Power BI Days 2020-08-13
We are excited to host the first Northwest Power BI Days with up-and-coming speakers from Oregon and Washington! Come join us at our free, virtual event that is dedicated to your Power BI learning.
August 13th, 2020 from 12:00 PM – 6:00 PM. All times in PDT (UTC -7).
12:00 – 12:30 PM ; Gregory Petrossian (CSG Pro) & Reid Havens (Havens Consulting) – Free Power BI Resources and Communities in the Northwest
12:30 – 1:30 PM ; Robin Abramson (Pragmatic Works) – Bring your Reports to Life with Dynamic Visualizations
Do your reports capture your users’ interest and drive deeper understanding of the data through their own explorations? Do they spend time ‘switching it up’ to discover new insights on their own? If not, we’ll shake things up, let the users themselves drive the page content and give them the ability to see it in ways meaningful to their own needs. Dynamic visualizations provide an app-like experience that lets users explore and understand data for the actionable results we all want to provide! We’ll take a look at techniques to provide dynamic visualizations including dynamic measures, dynamic columns, dynamic pages and even dynamic trendlines. Together, we’ll scoff at bookmarks (for dynamic purposes, anyway!) and gleefully engage end-users in trying different comparisons, values and even dynamic trendlines.
Robin Abramson is a Senior Consultant with Pragmatic Works and an unabashed Power BI enthusiast. Her experience spans two decades as a data professional using the Microsoft platform. She served on the Board of Directors for PASS from 2001-2002, first Director of Member Products and Services and later as Director of Volunteer Services. She works with clients around the world, focusing on creating an app-like experience with Power BI.
1:30 – 2:30 PM ; Performance, Optimization, and Intelligent Error Handling in Power Query – Reid Havens (Havens Consulting)
There are two primary cornerstones to building optimized and low maintenance queries in Power BI. The first is making sure queries have been designed to refresh at optimal speeds. Primary topics for performance tuning include: removing columns and rows, applied step configuration and order precedence, query folding, managing variables, and tables vs lists for transformations. The other important cornerstone is intelligently identifying and handling errors as they occur during scheduled refreshes. Primary topics for error handling include: replacing vs removing errors, collecting error metadata, and configuring the refresh to either fail or refresh successfully when errors occur.
Reid is the Founder of Havens Consulting Inc. and Microsoft MVP. He has a formal background in technology and organizational management, having obtained separate Master’s Degrees in Organizational Development & Business Analytics. Reid has experience working with many of the Fortune 50, 100, & 500 companies. Additionally he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization.
2:30 – 3:00 PM ; Power Break and Networking
3:00 – 4:00 PM ; Power BI Mobile Apps: Optimize Your Reports for a Seamless Experience – Ben Vega (Umpqua Bank)
Power BI is delivering on their promise of “simple, fast, and intuitive experiences” through Power BI Mobile Apps. Content shared with your end users is already accessible through these apps, but what you have designed to be viewed on a desktop might not be as useful or intuitive on a tablet or phone. Navigating workspaces, reports and dashboards can be less evident on a mobile device while reports can become cluttered and illegible if not designed appropriately. Learn how to optimize your existing reports by utilizing new features in Power BI Mobile and unifying the development and distribution of organizational content across the Power BI platform for a seamless experience.
A self-proclaimed and proud data citizen, Ben Vega has been with Umpqua Bank for eight years working with line of business executives and stakeholders to develop reports in Power BI. Ben has his MCSA in BI Reporting and MCSE in Data Management and Analytics.
4:00 – 5:00 PM ; Seeing Inside DAX, Power BI’s Advanced Calculation Language – Brian Grant (CSG Pro)
Your organization has adopted Power BI, but no one has told you about this thing called DAX and why it is important. DAX is the language that unlocks advanced business calculations in Power BI; but it’s notoriously difficult to learn. One reason it’s so hard is that you can’t actually see what it’s doing. But what if you could? Imagine how much easier it would be if you could see the pieces moving around.
In this presentation Brian Grant will be your guide as we develop an understanding what DAX is and the power it can bring to your enterprise reporting. We’ll then look inside basic DAX code to see what’s happening under the hood. In doing so you will find that at its heart DAX is a shockingly simple machine that is completely learnable, even by mere mortals.
Brian Grant is a masterful Analytics Consultant at CSG Pro by day, and a Power BI legend by night. Brian’s passion for Power BI has led him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. He also has a passion for teaching and is constantly uploading new material to YouTube, blogging, and leading Power BI training sessions for clients.
5:00 – 6:00 PM ; The Classic Income Statement and Power BI, Better Together – Mark Walter (Industrial Finishes and Systems)
Business depends on the income statement as a measure of past and ongoing performance; however, in its paper form, it limits us from uncovering insights that may lie beneath. In this session we will learn how to mirror the familiar statement format in Power BI and add dynamic features that will improve engagement and help us tell a great data story.
Mark is an Accounting and Analytics Manager at Industrial Finishes and Systems, Inc. (IFS). Since 1958, IFS, has brought product and system solutions to Auto Body, Recreational Vehicle, Wood Product, and Aerospace industries. He is responsible for financial data modeling and data storytelling both internal and external to the organization. Outside of IFS, Mark enjoys speaking with local finance groups and blogging at StoryBI.com. Mark is an Oregon Certified Public Accountant with a Finance degree from Western Washington University.