From the course: SQL for Exploratory Data Analysis Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Identifying business logic checks

Identifying business logic checks - PostgreSQL Tutorial

From the course: SQL for Exploratory Data Analysis Essential Training

Start my 1-month free trial

Identifying business logic checks

- One of the challenges with business logic checks is that they can be dificult to determine. Here is some guidelines to help identify where you might need to check business logic. Start with date columns. They should have ranges that are reasonable for the event or entity that is being described in the data. Also compare dates with each other. Do the differences seem reasonable? For example, order date and shipping date are likely to be fairly close together in an order record. Employee start dates and end dates should usually be far apart, but they may not be. This kind of difference can depend on the type of business. If dates are in the future, do they make sense for the type of data it is? A contract experation date could in the future, but an employee start date should not be. For numeric columns check that the range of values are within what you would expect. For example, are quantities in line for what you would expect for a normal business transaction? For example in clothing…

Contents