Leanpub Header

Skip to main content

The Associative Analyst

Associative Analysis You Can Defend — Aligned with the Qlik Sense Business Analyst and Data Architect Certifications

The Associative Analyst
This book is 100% completeLast updated on 2026-11-21

A Qlik application can show an answer that belongs to the model rather than to the business, and a fast, familiar screen gives no sign of it. The Associative Analyst prepares you for the Qlik Sense Business Analyst and Data Architect certifications and teaches you to prove what an application displays, and what a pass on either examination does and does not prove.

Minimum price

$20.00

$25.00

You pay

Author earns

$

Also available for 1 book credit with a Reader Membership

PDF
EPUB
About

About

About the Book

An associative application shows what a selection left out as clearly as what it kept, so a figure on the screen belongs to the business only if the model behind it can be stated and proved.

Most Qlik applications are built by one person and explored by many, and a key that fails to match or a forgotten default selection quietly changes what a number means. The book reads the nine domains of the two examinations as one workflow, from require to publish, and keeps one discipline in view throughout: the stated population, which says in one sentence who or what counts, under what rules and in what period.

  • QSBA: 50 questions, 90 minutes, 62 per cent to pass. Identify Requirements 30 per cent, Design Applications 24, Prepare and Load Data 14, Develop Applications 32.
  • QSDA: 45 questions, 120 minutes, 60 per cent to pass. Five domains, no published weights: Introductory Concepts in Data Modeling, Data Connectivity, Data Model Design, Data Transformations, Validation.

Beyond the examinations, the book teaches three capabilities neither one tests: proving a discovery, separating a finding from a modelling artefact under pressure, and owning the definitions an application depends on. Chapter 16 sets out what the credentials cannot certify.

What is inside

  • Six Parts and 16 chapters, each with a Decision Lab, an Analytical Tool, exercises and discussion questions
  • 20 figures and 55 tables
  • 160 chapter quiz questions with answer keys
  • Two original practice examinations of 50 questions each: Appendix G for the QSBA (90 minutes) and Appendix H for the QSDA (120 minutes)
  • Eight appendices, a 144-entry glossary, references and an index

Who it is for

A Qlik user who explores applications that others built, is comfortable with SQL querying, aggregation and joins, reasons about problem framing and metric design at the level GuruTech's Analytics Decision Series develops (or has equivalent experience), and has worked with a dashboard that others relied on. You need not have built a Qlik application. It is not for complete beginners in data work, and it does not cover tenant and server administration or platform engineering. It makes no claims about employment outcomes, salaries or pass rates.

The Associative Analyst is Book 6 of 9 in Analytics Beyond the Credential (Certification Tier, CT-6), from GuruTech Consulting International. It is an independent work, built to Qlik's published examination pages as read on 30 October 2026, and is not authorised, sponsored or endorsed by Qlik.

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

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 Associative Engine and the Two Credentials
    • Part Introduction
    • Chapter 1 — Two Credentials, One Associative Practitioner
    • Chapter 2 — The Tool That Shows What Your Question Excluded
    • Part Conclusion
  • Part II — Requirements Before the First Load
    • Part Introduction
    • Chapter 3 — Identifying Requirements: From Request to Specification
    • Chapter 4 — Sources, Connections, and the Guided Load
    • Part Conclusion
  • Part III — The Load Script and the Associative Model
    • Part Introduction
    • Chapter 5 — The Load Script as Transformation Argument
    • Chapter 6 — Combining Tables: Joins, Keep, Concatenation, and Mapping
    • Chapter 7 — The Associative Data Model and Its Failure Symptoms
    • Chapter 8 — QVDs, the Extract Layer, and Incremental Loading
    • Part Conclusion
  • Part IV — Validation, Expressions, and the Stated Population
    • Part Introduction
    • Chapter 9 — Validating the Model Before Trusting an Association
    • Chapter 10 — Expressions, Aggregation, and Chart Context
    • Chapter 11 — Set Analysis and Alternate States: From Selection to Stated Population
    • Part Conclusion
  • Part V — Governed Definitions and Guided Delivery
    • Part Introduction
    • Chapter 12 — Master Items and the Governance of Definitions
    • Chapter 13 — Guided Application Design
    • Chapter 14 — Publishing, Spaces, and Section Access
    • Part Conclusion
  • Part VI — Dual-credential Mastery and the Limits of the Credentials
    • Part Introduction
    • Chapter 15 — Dual-Credential Examination Mastery
    • Chapter 16 — What the Credentials Cannot Certify
    • Part Conclusion
  • Conclusion
  • Appendices
    • Appendix A — Qlik Sense Business Analyst Objective Cross-Reference
    • Appendix B — Qlik Sense Data Architect Objective Cross-Reference
    • Appendix C — Core-Series Concept Crosswalk
    • Appendix D — Study Plan
    • Appendix E — Load Script and Expression Quick Reference
    • Appendix F — Practice Environment and Sample Data
    • Appendix G — Practice Exam 1: Qlik Sense Business Analyst
    • Appendix H — Practice Exam 2: Qlik Sense Data Architect
  • 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