You would expect there to be a record and hopefully only one record for each sales person in a typical sales system and another record in another table for each of the customers. But what happens when a one of these sales people gets assigned to a different
Read More...
What's different about a data warehouse is that all of the information from the line of business or source systems gets rearranged into two types of information: Dimensions contains a group of descriptive attributes. An example is a product where we have
Read More...
The terms Business Intelligence, Data Warehousing, and Data Marts are used interchangeably by many people so I thought it would be good to explain the differences. The data warehouse is the repository for all the data to be analysed and reported on without
Read More...