- Half-Title Page
- Title Page
- Copyright Page
- Dedication
- Epigraph
- About the Series
- Author's Introduction
- Preface
- Who This Book Is For
- Acknowledgments
- About the Author
- How to Use This Book
- Series Architecture
- Table of Figures
- Table of Tables
- Introduction
- Part I — The Fabric Ecosystem and the Dual Certification Landscape
- Part Introduction
- Chapter 1 — Two Certifications, One Architecture, One Professional Obligation
- Chapter 2 — The Microsoft Fabric Platform
- Part Conclusion
- Part II — Data Preparation and the Transformation Layer
- Part Introduction
- Chapter 3 — Power Query: Connecting, Configuring, and Interrogating Data
- Chapter 4 — Power Query and M — Transformation as Analytical Argument
- Chapter 5 — Fabric Dataflow Gen2 and the Organisational Transformation Layer
- Chapter 6 — Lakehouses, Warehouses, and Direct Lake
- Chapter 7 — T-SQL and KQL — Query Fluency Across the Fabric Stack
- Part Conclusion
- Part III — Semantic Modelling and DAX
- Part Introduction
- Chapter 8 — Dimensional Modelling — The Architecture of Truth
- Chapter 9 — DAX Fundamentals — Measures, Context, and the Evaluation Engine
- Chapter 10 — Advanced DAX — Calculation Groups and Optimisation
- Part Conclusion
- Part IV — Report Design and Enterprise Delivery
- Part Introduction
- Chapter 11 — Designing Reports That Communicate the Argument
- Chapter 12 — Guiding the Reader — Interaction, Navigation, and Live Reports
- Chapter 13 — Finding Patterns and Assisting Analysis — Analytics Features, AI Visuals, and Copilot
- Chapter 14 — Power BI Service — Workspaces, Semantic Models, Apps, and Refresh
- Part Conclusion
- Part V — Governance, Security, and the Production Lifecycle
- Part Introduction
- Chapter 15 — Security Architecture Across the Fabric Stack
- Chapter 16 — Deployment Pipelines, Impact Analysis, Change Management, and Source Control
- Part Conclusion
- Part VI — Dual Certification Mastery and Professional Integration
- Part Introduction
- Chapter 17 — PL-300 Examination Mastery
- Chapter 18 — DP-600 Examination Mastery
- Chapter 19 — What the Platform Cannot Certify
- Part Conclusion
- Conclusion
- Appendices
- Appendix A0 — Certification Surface of Record
- Appendix A — PL-300 Exam Domain and Objective Cross-Reference
- Appendix B — DP-600 Exam Domain and Objective Cross-Reference
- Appendix C — DAX Pattern Library
- Appendix D — Fabric Architecture Decision Matrix
- Appendix E — Storage Mode and Connection Decision Matrix
- Appendix F — Row-Level Security Pattern Library
- Appendix G — Power Query M Cookbook
- Appendix H — Deployment Pipeline Checklist and Dual Certification Study Plan
- Appendix I — Core-Series Concept Crosswalk
- Appendix J — PL-300 Practice Examination A (50 Items)
- Appendix K — PL-300 Practice Examination B (50 Items)
- Appendix L — DP-600 Practice Examination A (50 Items)
- Appendix M — DP-600 Practice Examination B (50 Items)
- Appendix N — Gap Diagnostic and Reading-Plan Worksheet
- Appendix O — Volatile Surface and Update Log
- Glossary
- Notes and References
- Additional Resources
- Index
Power and Platform
Power BI and Fabric from Semantic Model to Enterprise Delivery — Aligned with PL-300 and DP-600
An analyst certified on only the delivery layer or only the engineering layer of Microsoft's analytics stack is structurally blind to the half that the other credential governs. Power and Platform prepares you for PL-300 and DP-600 as one workflow, and teaches you precisely what passing both examinations does and does not prove.
Minimum price
$30.00
$35.00
You pay
Author earns
About
About the Book
Passing PL-300 and DP-600 proves you can build a working solution on each side of the stack. This book prepares you for both as one workflow, so you can own the whole stack and know what the two credentials leave untested.
When a column is re-typed upstream, a measure keeps working while quietly making a different claim, and the analyst who owns only the delivery layer cannot see it. The book teaches the stack through one discipline, LAYER → POSITION → CLAIM → DEFENCE: locate the decision, read the position it encodes, name the claim it makes, and test whether it can be defended.
- PL-300 (Power BI Data Analyst): Prepare the data, Model the data, Visualize and analyze the data (25–30% each); Manage and secure Power BI (15–20%).
- DP-600 (Fabric Analytics Engineer Associate): Maintain a data analytics solution (25–30%), Prepare data (45–50%), Implement and manage semantic models (25–30%).
Beyond the outlines, it adds the failure modes behind each skill and a closing chapter on what neither credential can certify.
What is inside
- Six Parts and 19 chapters, each with a Transfer Ledger and exercises
- 17 Decision Labs, 6 Case Illustrations, 26 figures and 89 tables
- 190 chapter quiz questions with answer keys
- Four practice examinations, two per credential, of 50 items each, timed at 100 minutes by the book's design
- 16 appendices, including objective cross-references for both exams
- A 306-entry glossary, references and an index
Who it is for
A working analyst with roughly one to three years of practice, comfortable with SQL aggregation and joins, who has built a report or dashboard that others relied on. No earlier volume or prior PL-300 is required. It is not for complete beginners, or for engineers whose job is to build and operate the platform. It makes no claim about jobs, salaries or pass rates.
Book 3 of 9 in Analytics Beyond the Credential (Certification Tier, CT-3), from GuruTech Consulting International. An independent study work built to the PL-300 outline of 20 April 2026 and the DP-600 outline of 19 October 2026, and not authorised, sponsored or endorsed by Microsoft Corporation.
About the author: FRU Kingsly, founder of GuruTech Consulting, is a business intelligence and analytics professional and author with over a decade of experience designing decision-support systems that organisations use. He holds a BSc (Honours) in Accounting from the University of Buea.
Author
About the Author
FRU Kingsly is a data professional, analytics educator, and technology consultant specializing in data analytics, business intelligence, data engineering, and analytical communication. His work focuses on helping individuals and organizations develop the technical skills and analytical thinking required to transform raw data into trusted business insight.
Through consulting, technical training, and professional curriculum development, he has worked across areas including SQL, Power BI, data warehousing, cloud analytics, visualization, and enterprise reporting systems. His approach emphasizes that analytics is not only about tools, but also about judgment, clarity, structure, and responsible decision-making.
Contents
Table of Contents
Get the free sample chapters
Click the buttons to get the free sample in PDF or EPUB, or read the sample online here
The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.