Paul Turley
Director and Competency Lead
Battle Ground, Washington, United States
Actions
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.
Links
Awards
Topics
Using Power BI with Lots of Data
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.
Moving from Power BI to Microsoft Fabric
Fabric is here but what does that mean if you are using Power BI? What do you need to know and what, if anything, will you need to change if you are a Power BI report designer, developer or BI solution architect? What parts of Fabric should you use now and how do you plan for the near-term future?
DAX is Easy ...until it isn't. DAX Basics for Beginners.
The DAX calculation language is powerful but can be puzzling, and is a mystery to many people. To get the most from Power BI, you must understand the mechanics of DAX so you can create measures and calculations. Using Excel to get started in familiar territory, this beginner-level session will cover the essential concepts and help you understand how to build your own DAX skills to use in Power BI.
Through simple, relevant demonstrations, we will cover:
- Calculated columns & measures
- Row and Filter Context
- Aggregator functions and Iterator functions
- Filter & Table functions
- Building financial measures
- Applying time-intelligence
- Reading, annotating & formatting your DAX
- Variable basics
Tales from the Trenches: Lessons from Big Power BI Projects
From our experience managing hundreds of small, medium and massive Power BI projects at 3Cloud, I will showcase:
- Successful design patterns that always work
- Silly things that clients want to do
- Lessons learned from mistakes in the past
- Planning for the future and improving successful outcomes
Reporting & Modeling with a Lot of Data Using Power BI and Fabric
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 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.
Paul Turley
Director and Competency Lead
Battle Ground, Washington, United States
Links
Actions
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top