SEP 2023 - Using Power BI with a Lot of Data by Paul Turley (@Paul_Turley)
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.
Session Materials
https://sqlserverbi.blog/wp-content/uploads/2023/01/Using-Power-BI-with-a-Lot-of-Data-2023-1.pdf
https://sqlserverbi.blog/wp-content/uploads/2023/01/PowerBILotsOfData_PTurley_Samples.zip
Speaker Bio
Paul is a Director & Competency Lead 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.
13
views
JUL 2023 - The Fabric Of Our Lives by Chris Hyde (@ChrisHyde325)
Abstract
Announced at Microsoft Build 2023, Microsoft Fabric is the new Software-as-a-Service (SaaS) offering for data analytics solutions. Based on the data lakehouse paradigm and incorporating the latest updates to Data Factory, Synapse, and Power BI, Fabric is positioned as the one-stop shop for both professional and citizen data analytics workloads.
Please join us as we explore this exciting next step in the evolution of the Microsoft Data Platform for analytics.
Speaker Bio
Chris Hyde is a Microsoft Data Platform MVP based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the IDERA ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
16
views