Well-formed Data – Part 4: Missing Data

How often do you get data that needs to be charted or graphed only to find out some of the data’s missing?  We see it all the time.  However, just because it’s missing, doesn’t mean you can ignore it.  You need to know how to make it consistent, how to deal with it if it [...]

Well-formed Data – Part 3: Normalization

Our lives are made up almost exclusively of relationships and that includes data.  In fact, it’s hard to think of examples of data that doesn’t involve a relationship.  Customers (hopefully) have many Orders.  Companies have multiple employees.  People (hopefully) have multiple friends, who also have multiple friends, and may even share some of each others [...]