Banking system provides account to customers for savings, investments, loans etc. Customers can be segregated as business, corporate, non-profitable institutes, and personal etc. Bank gives interest on savings and investments, but collects from loan. The rate of interest varies based on account type, amount and customers age. High rate of Tax deduction is applicable for business and corporates, whereas personal accounts will have less tax rate or NIL. Non profitable institutes will not have any tax. The tax rate and interest rates will vary with time and subject to socio-economic situations. Identify the dimensions, dimension hierarchy and measures for construction of Data Warehouse. Construct the Data Warehouse schema using dimensions, measures and dimension hierarchy. Draw the lattice of cuboids for this Data Warehouse. Banking system provides account to customers for savings, investments, loans etc. Customers can be segregated as business, corporate, non-profitable institutes, and personal etc. Bank gives interest on savings and investments, but collects from loan. The rate of interest varies based on account type, amount and customers age. High rate of Tax deduction is applicable for business and corporates, whereas personal accounts will have less tax rate or NIL. Non profitable institutes will not have any tax. The tax rate and interest rates will vary with time and subject to socio-economic situations. Identify the dimensions, dimension hierarchy and measures for construction of Data Warehouse. Construct the Data Warehouse schema using dimensions, measures and dimension hierarchy. Draw the lattice of cuboids for this Data Warehouse