A Data warehouse is a central repository of all data of an organisation/business from various sources. DW is done by a process which involves…