Design a data warehouse for a courier company that has branches in many cities in India. Identify all facts and dimensions. For the dimensions, prepare relevant attributes and identify the hierarchies. Also prepare ex records for each fact and dimension table. Discuss the granularity as well.