This page contains materials from my conference and event presentations. Here you will find the slide decks, demo file packages, scripts and examples from conference sessions, user group presentations and classes that I have presented. You are welcome to use this material for your own learning or to share it without modification. Please do not remove my name or any reference material. If used for teaching or to repurpose in any way, please contact me for permission.
Power BI Cruise – Power BI Enterprise Solutions Hands-on Workshop
Since Internet connectivity isn’t an option on the cruise, you can either watch the presentation (and work-through the exercise later, on your own) or if you want to follow-along, you will need the following:
- Windows 10 or 11, at least 7 GB of free storage space on drive C:
- Download the workshop files, including the database backup file: ContosoDW-DEV.bacpac (~1GB)
- Download and install SQL Server Developer Edition (Ver 2012 or later)
- Download and install the latest version of SQL Server Management Studio (SSMS)
- Restore database using the Import Data Tier Application option (takes about 30 minutes)
Using Power BI with a Lot of Data
2023 | Presentation | Demos & Samples
Topics: futureproofing for scale & extensibility, CI/CD/DevOps, team development, and high-performance drill to-detail techniques.DAX Essentials for Beginners: DAX is Easy… Until it isn’t
Data Insights Summit, Sept 12 2022 | Presentation Recording | Demos & SamplesDoing Power BI The Right Way for Database Developers
2022 | PresentationMoving Informal Power BI Projects to Enterprise Scale
Seattle Modern Excel/Power BI group Aug 18 2021 | PresentationData Modeling Solutions for Challenging Data Modeling Problems
Silicon Valley PBI User Group | Recording
Power BI Summit April 19, 2021 | Presentation
Oregon SQL Saturday Oct 24, 2020 | Presentation
Pragmatic Works webinar April 21, 2020 | Presentation
Power BI Desktop files: Modelling presentation examples | Model with no relationshipsPower BI Best Practice Guide & Project Checklist (Power Platform World Tour 2019) | Presentation
Jan 2020 RevisionCan You Say Charticulator?
Pacific Northwest Power BI Symposium (2019) PresentationReporting Services 2016, The Force Awakens (PASS Summit 2016) | Presentation
DAX From the Trenches (Power BI Community Webinar May 31 2016) | Presentation | Sample PBIX | Recording
Power BI Hands-on Workshop (PASS BAC 2016 2 hour version) | Presentation
Power BI On Premises Enterprise Solutions/SSAS | Presentation
Reporting Services 2016 Solutions: The New Awesome | Presentation
Power BI Data Modeling and Calculations | Presentation
Upgrading to SQL Server 2014 and 2016 BI Features | Presentation
D&B Premium Data Options & Solution Scale | Presentation | Video
Transforming Reporting Requirements Into a Visual Masterpiece | Presentation
SolidQ BI Expert Panel – Keys to Successful BI Projects (presented at multiple events) | Presentation
NY, London, Paris, Munich… Everybody’s talkin’ ‘bout Mobile BI | Presentation
Tabular Models – Easier & Faster Than Cubes – Really? | Presentation
BI Visualization Choices: What, When & How | Presentation | Tool criteria Excel 2013 Power View report
Using a Custom Assembly to Extend Reports & Queries | Related Post | SSRS Custom Assembly Article
Dashboard Design – Making Reports Pop | Prezi online | Scorecard Demo Video
PowerPivot & Power View – High-octane Self-service Reporting | Prezi online | FAA PowerPivot model
Oh, So Tabular! | Prezi online
Visual Report Design – PASS Summit 2012 | Prezi online | Sample reports
Empower Users with Self-Service BI and Visualization – SQL Connections 2012
Power View and PowerPivot – SQL Connections 2012
Visual Report Design Bringing Sexy Back – SQL Connections 2012
Data_Visualization Choices – SQL Connections 2012
SharePoint BI Security Configuration – SharePoint Intelligence Conference – Dec 20 2011
Power View and PowerPivot – High Octane SS Reporting – SharePoint Intelligence Conference – Dec 20 2011
Dashboard Design – Making Reports Pop – SharePoint Intelligence Conference – Dec 20 2011
SharePoint BI Security Configuration – Power View roadshow (1st version)
Visual Report Design: Bringing Sexy Back
Recording
TechEd 2011
PASS Global Summit 2011
SQL Saturday 94, Salt Lake CityReport Design for SSAS Cubes & MDX
PASS Global Summit 2011MDX Essentials
SQL Saturday 92, PortlandWhat to Use and When – Microsoft BI Tool Choices
TechEd 2011
SQL Saturday 92, Portland
Paul,
I was in your class yesterday, Master Reporting Services Expressions. You showed a DB to hold all the information used for styling reports. (Template Data) I was wondering if you would share the script to create that DB? It would be very helpful to have something like that. Thanks a ton!
Hi Paul,
I attended both your sessions at the PASS Summit last month, and I was wondering if you could share the RDL files of two reports that I’m very interested in getting some ideas from on a case that I’m currently working on. The first one is the one where you display a color scheme (from your first presentation) and the other one is the report where you plot data on a map (from your second presentation).
Thanks in advance!
Erik
Hi Elizabeth. Just getting caught up; I just posted all my current decks on the Presentation page.
Hello! I was on the Eugene SQL Pass call last week and am very interesting in getting a copy of your “What to use and when: BI tools…” presentation as we (my fellow developers at work) are trying to persuade our Management to consider more of the Microsoft BI tools. Could you help a girl out?
Thanks!