Notes library

Handbooks written for practitioners

Every guide is a self-contained reference: model design, DAX patterns, Power Query transformations and SQL Server setup — with the tables, code and pitfalls you actually hit at work.

Loading the library…

Data Connectivity in Power BI — Step-by-step patterns for connecting Power BI Desktop to Excel, CSV, folders, SQL Server and shared semantic models, with the best practices that keep refreshes reliable.

DAX Filter Functions Handbook — The filter and value functions in DAX are among the most powerful. They differ greatly from Excel functions. Lookup functions work with tables and relationships. Filtering functions let you manipulate data context to…

DAX Mastery Student Handbook — This handbook is written as if an experienced teacher is sitting beside you and explaining every concept slowly. You do not need any programming background. We start from absolute zero.

SOP — Install SQL Server 2022 Developer Edition & SSMS — A controlled, enterprise-grade procedure for installing Microsoft SQL Server 2022 Developer Edition and the accompanying SQL Server Management Studio on Windows workstations and servers for development, test, and…

Time Intelligence with DAX — Complete reference of DAX time intelligence functions with practical examples for Power BI.

Time Intelligence, Data Modeling & Power Query — A practical guide to building robust semantic models, mastering DAX time intelligence, and cleaning data effectively with Power Query.