Have data sets scattered all over the place? Here's how to pull them into a single, robust catalog with the pointblank R package and a Quarto document. Do you have data sets scattered all over the ...

A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types. Such information helps audit databases for ...

We are often reminded in press and analyst reports that more data has been created in the last year than in all previous years combined. Such articles often are written in a giddy tone based on the ...

Data matters to every business. So it follows that every business needs a data strategy. As a strategic business and technology advisor, not only have I written the book on data strategy (literally), ...

I was working with a cross-functional information technology and operational technology team from one of the world’s largest makers of home goods. We were discussing how to drive a digital ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An Excel ...