1. A processor implemented automated data warehouse star schema system that automatically refines a template warehouse star schema for a source database, the automated data warehouse schema system comprising: an input gathering module implemented by the processor that automatically compares a customized source database with baseline template warehouse to gather a custom information selected from a group comprising i) a data type or a length of custom columns, ii) frequently used expressions on custom columns, iii) custom entities or information on constituent columns of the custom entities, iv) custom entity keys, v) relationships of custom entities with other entities, vi) relationships within custom entities, vii) a contribution of custom entities to specialized entities, viii) an update frequency of custom entities and columns, ix) a grouping of custom entity and column updates, or x) a contribution of custom entities and columns to workflows and correlated attributes, a fact determining module implemented by the processor that automatically determines facts by determining frequently updated numeric non key custom columns and the custom entities; a dimension determining module implemented by the processor that automatically determines dimensions by determining non-numeric custom columns and the custom entities that are infrequently updated and that are linked to the facts by foreign keys; and an automated star schema refinement module implemented by the processor that automatically suggests at least one of (i) subsumption of a custom entity into an entity of the template warehouse star schema based on a type of mapped target of related entities, a column type of the custom entity or an update frequency of the custom entity if the custom entity is related to the entity of the template warehouse star schema, (ii) creation of new facts or dimensions for the custom entity based on a column type of the custom entity or an update frequency of the custom entity if the custom entity is a standalone entity, or (iii) creation of specialized entities or augmentation of specialized entities in the template warehouse star schema if the custom entity is related to a currency or a unit of measure to refine a template warehouse star schema for the source database.