Data is the first thing that we need to benefit from BI platforms. You have to know which data should be stored? Data model is healthy or not? Also you have to know which data should be historical? What type historical data should be kept? How often data should be updated? Data is coming from different sources. Target data sets are integrated or not? Who knows organization of data? As a result, architecture of DWH should make you use reporting,Olap analysis, data mining efficiently. Is ODS layer necessary? Is metadata layer necessary? What is OLAP?
All above the questions have to be enlightened by the expertise. Colora is proficient in developing models in regards to sector based Data Warehouse, Datamart, OLAP and Data Mining.