Home > ETL Best Practices > A business case for standardization

A business case for standardization

If you are a SQL developer, not much an analyst, you would probably not pay attention to why users need to standardize certain data elements. But that is not my point. My point is actually opposite. As SQL developers, we need to pay close attentions to what our users are saying.

Here is an example. In our enterprise asset management master database, we need to standardize on operating systems for all IT computer assets. Here is the business case for that – auditing, licensing.

From an analyst:

…standardized so for example all Windows 2003 Server OS’s would show as Windows 2003 Server and not MS-Windows 2003 Server or Microsoft-Windows 2003 Server.

From an IT Engineer:

Just for clarification, the specific wording is not as important as it is that the entries are all consistent…. It probably is appropriate to make sure you store the edition information somewhere since licensing audits will need that later…we are all too familiar with the licensing needs for the data.

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: