Paul Turley (Blog | LinkedIn) is a Solution Architect with P3 Adaptive and a 16-year Microsoft Data Platform MVP specializing in enterprise-scale BI reporting, data modeling, analytics, visualization, and modern data solution design. With deep expertise in Microsoft Fabric, Power BI, AI-enabled and enhanced solutions, and the broader data platform, he has been designing and developing analytics solutions since 1992.
He started his career with a healthcare startup in 1989 where he discovered his passion for analytic reporting, support and training.
He has delivered advanced analytics, BI, database, and reporting solutions across large and small organizations in many industries, with expertise spanning project lifecycle management, data modeling, SQL Server (since version 6.0), application integration, and enterprise BI using Microsoft Fabric, Power BI, Reporting Services, and Analysis Services.
Author of over 16 titles on Power BI, enterprise BI reporting, and SQL Server, he also develops training courseware and presents at Microsoft technology conferences, user groups, workshops, and industry events. A FastTrack Recognized Solution Architect and Microsoft Certified Professional since 1996, Paul holds multiple current and legacy certifications in Data Platform and BI.
Short Bio
Paul (Blog | LinkedIn) is a Solution Architect with P3 Adaptive and a Microsoft Data Platform MVP specializing in Microsoft Fabric data architecture, enterprise-scale BI reporting, data modeling, analytics, and AI-enabled solutions. With deep expertise in Microsoft Fabric, Power BI, and the broader data platform, he has been designing and developing analytics solutions since 1992 across organizations of all sizes and many industries. Author of over 16 titles on Power BI, enterprise BI reporting, and SQL Server, he develops training courseware and presents at Microsoft technology conferences, user groups, and industry events. A Microsoft Certified Professional since 1996, Paul holds multiple certifications in Data Platform and BI.
Profile pictures: Paul Headshot | Paul Caricature with Bear
 |  |
Paul has authored and co-authored several books and training courses including:
- Microsoft Power BI Data Analyst Associate Study Guide (O’Reilly Media)
- Microsoft Fabric workshop and modern data platform roadmap
- Mastering Power BI (1-4 day training course)
- Azure Analysis Services & SSAS Tabular 2017 Foundations (2-3 day training course)
- Mastering SQL Server 2016 Reporting Services (2-4 day training course)
- Professional SQL Server 2016 Reporting Services (Wrox Press)
- SQL Server Analysis Services 2012 Cube Development Cookbook (Packt Publishing)
- Professional SQL Server 2012 Reporting Services (Wrox Press)
- SQL Server MVP Deep Dives vol. 2 (Manning Press)
- Reporting Services Recipes for Expert Reports (Wrox Press)
- Beginning T-SQL for SQL Server 2005 and 2008 (Wrox Press)
- Beginning Transact-SQL for SQL Server 2000 and 2005 (Wrox Press)
- Professional SQL Server 2008 Reporting Services (Wrox Press)
- Professional SQL Server 2005 Reporting Services (Wrox Press)
- Professional SQL Server Reporting Services (2000) (Wrox Press)
- SQL Server 2005 Integration Services Step by Step (Microsoft Press)
- Beginning SQL Server 2005 Administration (Wrox Press)
- Professional SQL Server 2000 Data Warehousing with Analysis Services (Wrox Press)
- Professional Access 2000 Programming (Wrox Press)
That’s Great paul 3Cloud Solutions BI&A practice ,you did well job which is helping alot for database
Hello,
Any update about your new book, release date?
Thank you!
Love the report. Could you add total number of tracking for negative test and total test?
James, do you have a reliable source for the test data? If so, I encourage you to share and perhaps add that to a copy of the report and share through the GitHub repo
Hi Paul,
Need your valuable inputs for one the customer requirements to access the tabular model data as described below.
Could you please check and let us know if tabular model can support this Hierarchical access to data based on below levels. Any suggestions or approaches to implement this methodology.
Below is the organization Hierarchy structure.
Level Category Reports to Access to Data
1 Chief Manager NA View all reportee’s data
2 Regional Manager Chief Manager View Own and reportee’s data
3 unit Manager Regional Manager View Own and reportee’s data
4 Division Manager unit Manager View Own and reportee’s data
5 Manager Division Manager View Own and reportee’s data
6 Employee Manager View Own data only
Thanks
Paul: Thanks for writing this color theme blog for PI. Could you share the Excel hex values that you have used in these tabs? Thanks!
Please use the link to contact Ron through the Portland Power BI Meetup site.
Hi Paul, Do you know of a successful way to report from TFS online? I have been researching on Power BI web and SSRS as alternatives but they seem to have limitations.
Raft, I’m afraid I don’t have experience reporting out of TFS online but it seems reasonable that it could be done either through a live interface or extract.
Paul
Paul, My CIO is looking for someone to do a quick but Expert level SSIS project. Are you available for this sort of engagement?
Robert
I’m booked pretty solid for the next few months and I do more reporting and semantic model design than ETL work. We have a number of mentors at SolidQ who are SSIS rock stars. I’m happy to make an introduction.
Hello Paul,
Great Material . Books and Website . Could you tell me where can i get more info about Deployment Reports in a real scenario ? Something that You wrote.
Miguel – Peru – South America – Living in Toronto
We cover report and solution deployment pretty thoroughly in our books for each version of the product. Did you have questions about any specific scenarios? i.e. Native, SharePoint, custom app integration.
Hi Paul, great site. What’s the biggest challenge you’ve faced in the BI world? Not politically, but technically ;o)
I’m just starting really in the Microsoft BI world, having previously used a number of SAP products. I’m excited by what Microsoft is bringing to the table and can’t wait to learn!
Paul, I recently created a SSRS Performance Dashboard reports, which are intended to run in SSMS as Custom reports towards the Report Server database. If you would like to preview them, please visit http://sqlconcept.com/tools/ssrs-performance-dashboard/. There are some screenshots and product information.
I would be very happy if you could share your opinion about them.
Regards,
Feodor
Thanks for asking. Yes, that would be fine if you will provide a reference.
Paul we really loved your advice on “Let’s get physical, the Art of Report Design.
Paul are you okay if we use some of your points and graphics in our internal design document? We will reference you and your webite in the appendix.
Kind regards