Abstract: A system for data mining and providing business intelligence data including a source system having a computer readable database storing data aggregated from one or more data sources, and an analytics server in communication with the source system and including a computer readable medium having an intermediate data file stored thereon. The intermediate data file consisting of the data aggregated from the one or more data sources.

Abstract: A computer implemented method for data mining and providing business intelligence data including generating by an analytics server one or more dimensions from source data imported from a computer readable medium, wherein the one or more dimensions define categories into which portions of the normalized data can be grouped; generating by the analytics server one or more measures from the source data linked to the one or more dimensions; storing by the analytics server the one or more dimensions and the one or more measures in a plurality of tables arranged in one of a snowflake and a star schema; determining by the analytics server relationship information between one or more measures and one or more dimensions in each of the plurality of tables; storing by the analytics server the relationship information on the computer readable medium; calculating by the analytics server a total cost of at least one product based on the relationship information; and, querying by a computer system in communication with the a