Analyze some Data , OLAP
$2-8 USD / hora
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.
Nº del proyecto: #12292494