Multi Dimensionalised Aggregation in Horizontal Dataset Using Analysis Services
Projecting data in different dimensions is the core concept taken for this project. Preparing a data set for analysis is generally the most time consuming task in a data mining project. In the existing system they used simple, yet powerful, methods to generate SQL (Structured Query Language) code to return aggregated columns in a horizontal tabular layout, returning a set of numbers instead of one number per row. This new class of functions is called horizontal aggregations. The horizontal aggregation is evaluated using three fundamental methods: case, SPJ (Select Project Join) and pivot.