Leanpub Header

Skip to main content

Applied & Advanced Analytics

Judgment, Scale, and Accountability for the Senior Analyst

Applied & Advanced Analytics
This book is 100% completeLast updated on 2026-11-21

Many analyses are correct and still change nothing, because the analyst treated the output as the end of the job. Applied & Advanced Analytics teaches the senior practice that closes that gap: owning a problem through its full lifecycle, applying experimentation, inference, regression and machine learning with discipline, and staying answerable for what the work causes.

Minimum price

$19.00

$29.00

You pay

Author earns

$

Also available for 1 book credit with a Reader Membership

PDF
EPUB
About

About

About the Book

A correct analysis is not the same as a consequential one. This book teaches the senior practice of owning the problem from first question to final review, and of remaining answerable for what the work causes.

Most analytical education stops at the output and assumes a correct result will carry itself into the decision. Applied & Advanced Analytics does not. It follows a real problem through every stage at which judgment is required, using the Diagnose → Decide → Defend → Deploy pattern as the spine. It begins with the lifecycle, treats the advanced methods as tools used inside it, and ends with ethics.

What is inside

  • Four Parts and 22 chapters (Chapters 22–43): the analytics lifecycle; presentation, design and practice; advanced analytics; advanced tools and responsibility
  • 22 Decision Labs, one per chapter, four case studies and a capstone project with its rubric
  • Experimental design and A/B testing, inferential statistics, regression and machine learning
  • Advanced Excel (dynamic arrays, Power Query, Power Pivot and DAX, automation), advanced visualisation, advanced SQL, and data ethics and privacy
  • 110 reflection and discussion questions, with the author's positions in Appendix B
  • 64 figures and 36 tables
  • Seven appendices, including a field toolkit of eighteen tools, SQL and DAX pattern references, and a capstone briefs library
  • A 127-entry glossary, notes and references, and an index

Who it is for

Analysts who already have the working competence Book I builds: comfortable use of spreadsheets and SQL, a command of descriptive analysis, and the ability to choose a chart and present a result. You may have gained that from Book I or from professional practice. It also suits analytics leads, and instructors of a one-semester graduate or professional course. It is not for readers new to analytics, who should begin with Book I, and it is not a complete product manual for any one tool.

Book II of II in The Professional Data Analytics Series, from GuruTech Consulting International. An independent work, not tied to any certification and not affiliated with or endorsed by Microsoft, Google, Amazon, Snowflake or any other vendor it names.

About the author: FRU Kingsly, founder of GuruTech Consulting International, 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 VI — Analytics Lifecycle
    • Part Introduction
    • Chapter 22 — Overview of the Analytics Lifecycle
    • Chapter 23 — Defining the Problem
    • Chapter 24 — Collecting & Preprocessing Data
    • Chapter 25 — Analysing Data
    • Chapter 26 — Identifying & Refining Insights
    • Chapter 27 — Strategic Communication for Analytics
    • Chapter 28 — Presenting Analytics Insights
    • Chapter 29 — Evaluating Outcomes & Iterating
    • Part Conclusion
  • Part VII — Presentation, Design & Practice
    • Part Introduction
    • Chapter 30 — Real-World Case Studies
    • Chapter 31 — Capstone Analytics Project
    • Chapter 32 — Advancing Your Analytics Career
    • Part Conclusion
  • Part VIII — Advanced Analytics
    • Part Introduction
    • Chapter 33 — Experimental Design & A/B Testing
    • Chapter 34 — Inferential Statistics for Analytics
    • Chapter 35 — Regression Analysis for Analytics
    • Chapter 36 — Machine Learning for Analytics
    • Part Conclusion
  • Part IX — Advanced Tools & Responsibility
    • Part Introduction
    • Chapter 37 — Advanced Excel: Dynamic Functions & Arrays
    • Chapter 38 — Advanced Excel: Power Query & Pipelines
    • Chapter 39 — Advanced Excel: Power Pivot & DAX
    • Chapter 40 — Advanced Excel: Automation Strategies
    • Chapter 41 — Advanced Visualisation & Analytics Design
    • Chapter 42 — Advanced SQL for Analytics
    • Chapter 43 — Data Ethics & Privacy
    • Part Conclusion
  • Conclusion
  • Appendices
    • Appendix A — The Senior Analyst's Field Toolkit
    • Appendix B — Reflection and Discussion Questions: Author's Positions
    • Appendix C — Cross-Series Reference & Decision Lab Index
    • Appendix D — Advanced SQL Pattern Reference
    • Appendix E — Advanced DAX Pattern Reference
    • Appendix F — Capstone Briefs Library
    • Appendix G — A Reading Path for the Long Career
  • Glossary
  • Notes and References
  • 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