Power Query Lesson 10: Project — A Monthly Refresh Pipeline
Build a complete refreshable pipeline: combine monthly files from a folder, clean and type them, merge product details, add FY columns, load to the…
Read article →Atul Vij
Is This Shopping Website Safe? 7 Checks Before You Pay
Is This Shopping Website Safe? 7 Checks Before You Pay
Seven quick checks before paying on an unfamiliar shopping site: the real domain, too-good prices, contact details, reviews, return policy, payment options and site…
Read article →Power Query Lesson 9: Dates, Financial Year and a Calendar Table
Power Query Lesson 9: Dates, Financial Year and a Calendar Table
Work with dates in Power Query: extract year, month name and week, add Indian financial year and FY quarter columns, calculate days between dates,…
Read article →Power Query Lesson 8: Custom and Conditional Columns (a Little M)
Power Query Lesson 8: Custom and Conditional Columns (a Little M)
Add calculated columns in Power Query: Conditional Column for size bands, Custom Column formulas for GST and totals, Column From Examples, if-then-else in M,…
Read article →Power Query Lesson 7: Group By
Power Query Lesson 7: Group By
Summarise data inside Power Query with Group By: basic and advanced grouping, several aggregations (sum, count, count distinct), grouping by two columns, and when…
Read article →Project: Build a Policy Q&A Assistant for Your Team
Project: Build a Policy Q&A Assistant for Your Team
Put the course together: a small web app that answers questions from your policy documents with sources, refuses when unsure, logs usage and stays…
Read article →Guardrails, Cost Limits and Logging for AI Agents
Guardrails, Cost Limits and Logging for AI Agents
Make an agent safe to share: turn limits, a cost ceiling, read-only tools, approval for risky actions, prompt-injection awareness and a log you can…
Read article →Power Query Lesson 6: Append and Combine a Folder of Files
Power Query Lesson 6: Append and Combine a Folder of Files
Stack tables with Append Queries, then combine every file in a folder with From Folder: sample file transform, file name as a column, filtering…
Read article →Power Query Lesson 5: Merge Queries — Lookups Without VLOOKUP
Power Query Lesson 5: Merge Queries — Lookups Without VLOOKUP
Bring product names and categories into an orders table with Merge Queries: matching columns, join kinds (left outer, inner, anti), expanding columns, and finding…
Read article →An AI Agent That Searches Your Documents
An AI Agent That Searches Your Documents
Turn RAG into a tool: the agent decides when to search, can search more than once with better wording, and combines document answers with…
Read article →Power Query Lesson 4: Unpivot and Pivot
Power Query Lesson 4: Unpivot and Pivot
Turn a cross-tab with months across the top into a proper data table with Unpivot Other Columns, pivot data back into columns, and know…
Read article →Better Retrieval: Chunk Size, Scores and a “Don’t Know” Threshold
Better Retrieval: Chunk Size, Scores and a “Don’t Know” Threshold
Measure retrieval instead of guessing: build a small test set, compare chunk sizes, and add a score threshold so the assistant refuses when your…
Read article →