Missing value versus zero value
Missing values in the data source can mean two things in real business—either the data is zero or it is missing. For example, in the case of a sales transaction based system, if there is no data for a product for a certain month, it means there was no sale of that product in that month. However, in some other system; for example, yearly returns of different stocks missing data might just mean that the data is not available for a certain reason. However, it certainly doesn't mean the return was zero.
Hence, it is important to clearly highlight the missing value as zero or missing in the report.
Getting ready
Create a simple crosstab report with all Product line on rows and Month key on columns from GO Data Warehouse (Query) | Sales. Choose sales quantity and unit cost as measures.
How to do it...
First of all, we will run the report to see if there are any missing values.
We can see that the Sales Quantity and Unit Price are missing for certain columns.
Now go to...
