Using Power BI with a Lot of Data - Paul Turley

Futureproofing for scale & extensibility, CI/CD/DevOps, team development, and high-performance drill to-detail techniques.
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 DirectQuery alongside [1]memory Import mode, 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.
Paul Turley is a Competency Lead Director for the 3Cloud Solutions BI&A practice, 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.
www.sqlserverbi...
/ 930
/ paul_turley

[@bradj229]

Great presentation! Thanks for demo-ing real world examples vs only quickly verbally explaining examples.

[@Milhouse77BS]

This was great presentation as usual.

[@Nalaka-Wanniarachchi]

Nifty tricks, Paul turley rocks.

[@polsanisandeep1706]

Thank you paul, one of the valuable demo.

[@sudarshanreddy6969]

Thank you Paul