Leanpub Header

Skip to main content

Analytics on Google's Terms

Cloud-Native Analytical Practice with BigQuery and Looker — Aligned with Google Cloud Associate Data Practitioner

Analytics on Google's Terms
This book is 100% completeLast updated on 2026-11-21

A query can be correct and unaffordable, a metric can mean two things in two tools, and a permission can outlive its purpose. Analytics on Google's Terms prepares you for the Google Cloud Associate Data Practitioner exam and teaches the three questions, who pays, who defines and who can see, that decide whether an organisation can trust the way you use BigQuery, Looker and Data Studio.

Minimum price

$15.00

$20.00

You pay

Author earns

$

Also available for 1 book credit with a Reader Membership

PDF
EPUB
About

About

About the Book

Passing the Associate Data Practitioner proves you can operate Google Cloud's data services. This book prepares you for it, and teaches the three questions of cost, meaning and access that decide whether an organisation can trust the way you operate them.

A query can be correct and unaffordable. A metric can be defined carefully in one tool and differently in the report beside it. A contractor's access can outlive the contract. BigQuery decides what a question costs, Looker decides what a number means, and sharing settings decide who may see it, so every service is studied by asking who pays, who defines and who can see.

The exam guide has four sections:

  • Data Preparation and Ingestion (about 30%)
  • Data Analysis and Presentation (about 27%)
  • Data Pipeline Orchestration (about 18%)
  • Data Management (about 25%)

Beyond the guide, the book teaches how BigQuery reads data and bills for it, how to read and safely adjust LookML, and what the credential leaves untested: owning a definition, controlling cost under load, and deploying a prediction.

What is inside

  • Six Parts and 15 chapters; all eleven exam objectives taught and mapped in Appendix A
  • 15 Decision Labs, 4 Analyst's Corners and 15 Analytical Tools, with exercises in every chapter
  • 16 figures and 49 tables
  • 150 chapter quiz questions with answer keys that tag the exam section and objective
  • Two practice exams of 60 questions each, written for a two-hour sitting, with a score analysis by exam section
  • Eight appendices, a 132-entry glossary, notes and 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 hands-on Google Cloud experience is assumed. It is not for complete beginners, and it treats pipelines and storage at analyst depth. It makes no claim about employment outcomes, and because Google publishes no passing score, no practice result here predicts a pass.

Book 5 of 9 in Analytics Beyond the Credential (Certification Tier, CT-5), from GuruTech Consulting International. An independent study work, not authorised, sponsored or endorsed by Google.

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 actually use. He holds a BSc (Honours) in Accounting from the University of Buea.

Author

About the Author

fru kingsly

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

  • 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 Credential and the Platform
    • Part Introduction
    • Chapter 1 — What the Associate Data Practitioner Validates
    • Chapter 2 — The Google Cloud Estate the Analyst Works Inside
    • Part Conclusion
  • Part II — BigQuery: The Engine and the Economics of the Query
    • Part Introduction
    • Chapter 3 — BigQuery Architecture: How the Engine Reads Data
    • Chapter 4 — Cost Economics as an Analytical Discipline
    • Part Conclusion
  • Part III — Analysis in BigQuery: From Query to Model
    • Part Introduction
    • Chapter 5 — The BigQuery SQL Dialect and Analysis Where the Data Lives
    • Chapter 6 — Machine Learning Inside BigQuery
    • Part Conclusion
  • Part IV — Data in Motion: Ingestion, Preparation, and Orchestration
    • Part Introduction
    • Chapter 7 — Where Data Lives and How It Arrives
    • Chapter 8 — Preparing Data: Quality, Cleaning, and the Transformation Pattern
    • Chapter 9 — Scheduling, Automating, and Monitoring Pipelines
    • Part Conclusion
  • Part V — Looker, Data Studio, and the Governed Semantic Layer
    • Part Introduction
    • Chapter 10 — Looker as a Semantic Layer: Reading and Adjusting LookML
    • Chapter 11 — The Semantic Layer as a Governance Instrument
    • Chapter 12 — Data Studio and the Visualisation Boundary
    • Part Conclusion
  • Part VI — Data Management and the Limits of the Credential
    • Part Introduction
    • Chapter 13 — Access Control, Sharing, and the Analyst's Security Boundary
    • Chapter 14 — Protecting, Retaining, and Recovering Data
    • Chapter 15 — What the Credential Leaves Untested
    • Part Conclusion
  • Conclusion
  • Appendices
    • Appendix A — Associate Data Practitioner Exam Guide Cross-Reference
    • Appendix B — Core-Series Concept Crosswalk
    • Appendix C — Study Plan
    • Appendix D — Google Cloud Data Service Selection Reference
    • Appendix E — BigQuery Patterns Reference
    • Appendix F — LookML Reading Reference
    • Appendix G — Practice Exam 1 (60 Questions)
    • Appendix H — Practice Exam 2 (60 Questions)
  • Glossary
  • Notes and References
  • Additional Resources
  • Index

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.

Learn more about writing on Leanpub