Welcome to the January 18th, 2023 HYBRID meeting!
We are finally meeting in person in Vancouver, WA at the downtown Columbia Bank in their Community Room!
You may have noticed a change in date, we are now meeting on the 3rd Wednesday of the month once again at 6:00 PM PST. We will have snacks and networking before the main meeting.
But… we will continue to operate monthly online meetings through the PNW collaborative facilitated by the Oregon Data Community. Due to this, you will be able to attend the meeting remotely and we are definitely open to remote speakers.
In order to encourage questions during the presentation, please use chat which will be monitored and/or use the raise hands option in Teams. Please be mindful of the other attendees and mute your mic!
We will be starting at 6:00 PM PST
Schedule (may be fluid due to discussions and Q/A):
6:00 – 6:30 PM – Snacks/Announcements/Networking
6:30 PM – Presentation
Our wonderful sponsors are providing gifts each month!
Title: Using Power BI with Lots of Data
Abstract: Can we use Power to deal with real-time data sources, very large tables, and transactional details? Yes, but it requires some planning and proper design. Out of the box, Power BI is super-fast with moderate data volumes and data schemas optimized for analytic reporting. How big is your data? Millions or billions of rows? Gigabytes or terabytes? – we can handle that.
Moving beyond the basics, learn to use DirectQuery alongside in-memory Import mode in composite models to access very large tables with real-time results; models and reports that combine interactive “dashboard-style” reports and drill-through to transactional details. Take a journey and learn to use the Power BI platform to achieve the best of both worlds: performance and scale.
Bio: Paul (Blog | LinkedIn | Twitter) is a Principal Consultant and Manager for 3Cloud Solutions, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter & user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox & Microsoft Press. Paul is a 2021 & 2022 FastTrack Recognized Solution Architect and holds several certifications related to the Microsoft Data Platform and Business Intelligence.