Patent ID: 8874595

Claim:
A system for data mining and providing business intelligence data comprising a source system including a computer readable database storing data aggregated from one or more data sources; an analytics server in communication with said source system and including a computer readable medium having an intermediate data file stored thereon, said intermediate data file consisting of said data aggregated from said one or more data sources; wherein said analytics server includes computer readable instructions stored on said computer readable medium for: importing said data aggregated from said one or more data sources for storing on said intermediate data file in the form of source data; normalizing said source data using predetermined scripts into normalized data stored in normalized data tables on said computer readable medium; generating one or more dimensions from said source data, wherein said one or more dimensions define categories into which portions of said normalized data can be grouped; generating one or more measures from said source data linked to said one or more dimensions; generating one or more formulae for calculating information from one or both of said dimensions and said measures; storing said one or more formulae in a formulae table; one or more computing devices in communication with said analytics server, and including a module for querying and receiving data from said analytics server, and for simulating changes in the calculated information based on user-inputted data and said one or more formulae stored in said formulae table.