Analyze some Data , OLAP

Cerrado Publicado hace 7 años Pagado a la entrega
Cerrado

Consider an environment ; a business problem, any real life case that interests you.

Describe the environment very breifly.(50 worlds)

Design an OLAP cube with the following characteristics

Fact table: at least one measures and one calculated member together with keys to dimension tables

Dimensions: At lest three dimensions, one of them being a time dimension

Provide attributes some of whicha are candidates for being levels of concept hierarcies.

Fill out the tables with real or hypothetical data as much as possible. Since this cube is to be designed for illustration purposes the size of the data can be small. with at keast 1000 records in the fact table is required.

Use Exel Power Pivot as the OLAP tool and Access as the database..

Illustrate possible drill down and role up opperatiohs.

As a short report to be submitted state the problem clearly (aroud 50 words) and present the database desing including fact table, measress, calculated measures, the describtions of dimensions and concept hierarchies.

Procesamiento de datos Excel

Nº del proyecto: #12292494

Sobre el proyecto

1 propuesta Proyecto remoto Activo hace 7 años