摘要 |
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. The analytics server includes computer readable instructions for: importing the data aggregated from the one or more data sources for storing on the intermediate data file in the form of source data; normalizing the source data using predetermined scripts into normalized data stored in normalized data tables on the computer readable medium; generating one or more dimensions from the source data, wherein the one or more dimensions define categories into which portions of the normalized data can be grouped; generating one or more measures from the source data linked to the one or more dimensions; and, generating one or more formulae for calculating information from one or both of the dimensions and the measures.
|