Priya Nair

Data Operations Lead

Priya runs data operations for a mid-size logistics company and writes about the unglamorous work of keeping 400 recurring spreadsheets accurate. She is the reason the Data Validator has cross-column rules.

Data validation
Process design
Power Query
Team workflows

linkedin.com

Articles by Priya

TutorialsJuly 8, 20253 min read

How to merge hundreds of workbooks without writing a macro

Monthly branch reports, regional exports, one file per client. Here is how to consolidate them reliably, including the header-mismatch problem nobody warns you about.

PNPriya NairData Operations Lead

Data qualityMay 13, 20252 min read

A repeatable process for cleaning messy CSV exports

The same six problems appear in every system export. Fixing them in a fixed order takes ten minutes and never has to be reinvented.

PNPriya NairData Operations Lead