O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

E-commerce data model design process

Importation of three tables, namely, User, Invitation, and Departments has been done. The Departments table is not related to any tables since they were imported as a flat file, but there is a need to create a relationship and to make a good logical design in order to make reports and analysis.

The most vital thing is that the User and Invitation tables were imported from a relational database and precisely it contains transaction data. This means the tables are created based on the index and optimization and stored as physical models as the Gender attribute has values 1 and 2, where 1 denotes male and 2 denotes female. But the users must make everything into a logical model, since the end user will be able ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required