Prachit Parikh | Business Analysis Notes

Practical business analysis by Prachit Parikh: requirements and user stories, SQL data validation, data mapping for system migrations, UAT planning, defect triage and Power BI reporting. Templates, checklists and real examples you can use on your next project.

2 posts

SQL data profiling: 8 queries I run on a brand-new table before anyone writes a test

Someone points you at a table. It showed up in staging last week, it has a sensible name, and the request is short: "Can we build the weekly report off this?" Nobody has written requirements against i

Nov 5, 202627 min read4 views

Nov 2, 2026
Nov 2, 20267 min read9 views
Data mapping document template: how I map a system migration field by field
Most data migrations don't fail on the big stuff. They fail on a field nobody thought about: a status code with no mapping, a date stored as text in the old system, a customer type that got split into
7 min read9 views

Latest articles

SQL data profiling: 8 queries I run on a brand-new table before anyone writes a test

Data mapping document template: how I map a system migration field by field