Premium Only Content

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.
-
1:02:23
In The Litter Box w/ Jewels & Catturd
20 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
39.2K22 -
LIVE
Game On!
1 hour agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
58 watching -
LIVE
John Crump Live
4 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
153 watching -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
271 watching -
1:00:56
The Tom Renz Show
8 hours agoThe War On DOGE Is ALSO A War On The Economy
4.95K5 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $0.84 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
11.3K1 -
1:56:29
The Quartering
5 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
66.8K28 -
37:08
Standpoint with Gabe Groisman
22 hours agoDOGE The UK?! With Liz Truss
26.5K12 -
56:39
SLS - Street League Skateboarding
6 days agoHIGHEST SCORING KNOCKOUT ROUND OF ALL TIME! Felipe Gustavo, Dashawn Jordan, Filipe Mota & more...
21.7K1 -
14:26
Breaking Points
1 day agoWOKE VS BASED?: Saagar And Ryan Play A Game
24.2K6