Many recent technologies increase the generation of data and its usages. There are concerns to store, retrieved large data, processing multiple queries and services simultaneously. The cube format of the data and dimensional databases can ease the process of retrieval and modelling the data efficiently and effectively. This study suggests few efficient ways to address the concerns using the concept of a data warehouse and analytical operations. It also offers the design aspect of a Hybrid analytical system by linking different functionalities under a Layered Architecture style. The desired inputs are selected from warehouses, later consolidated to form incremental subsequent higher-level data. This style supports a Hybrid system to provide trust by linking across many data sources of the distributed warehouse systems. It enables the ELT services other than the normal ETL operations to handle large data to support the data lake. The suggestive functionalities engine is used to produce data patterns. The merit of the PDC tree is incorporated to provide some possible parallel operations. The findings are applied to a case study of data modelling to predict a potential future epidemic. Such a system generates several reports to help the users or the authority for handling such an epidemic in better efficient ways.