Patent ID: 10102236

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 analytics server for the change in total cost of the at least one product based on a change in any one of the measures.