Welcome to the October 16th 1800 HRS PST/2100 HRS EST, 2024 HYBRID meeting!
We are once again meeting in person in Vancouver, WA at the downtown Umpqua Bank in their Community Room!
We meet 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.
Please register at Meetup:
https://www.meetup.com/oregonsql/events/303934230
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/9:00 PM EST
Schedule: (may be fluid due to discussions and Q/A):
6:00 – 6:30 PM – Snacks/Announcements/Networking
6:30 PM – Presentation
8:30 PM – Happy Hour/Networking (Shanahans in Vancouver)
Presentation:
Title: Reporting and Modeling with a Lot of Data Using Power BI and Fabric
Abstract:
Power BI is not just for self-service reporting. It is a highly scalable data analytics platform that can handle large volumes of data at scale to create analytical and operational reports. Fabric takes Power BI next-level with Direct Lake and Gen2 Dataflows. This session will demonstrate Power BI for the enterprise and help you plan and design solutions with interactive, fast data refresh, and even real-time reporting for the entire business. Take a journey and learn to use the Power BI with Fabric to achieve the best of both worlds: performance and scale.
Can we use Power BI 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 Direct Lake, and 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.
Bio:
Paul is a Director & Competency Lead for 3Cloud Solutions, a 15-year Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs at SqlServerBI.blog 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/co-author of 15 titles. He holds several certifications for the Data Platform and BI.
