DATA MODELS FOR WEBSITE ANALYTICS

Diagram 1) shows an Entity-Relationship Diagram (ERD) for a Logical view and Diagram 2) shows an ERD for a Physical View.

1) Website Analytics Logical ERD Data Model 2) Website Analytics Server Log ERD Data Model


Diagram 3) shows a Data Mart to support BI and Performance Reports.

3) Website Analytics Data Mart


© DataBaseAnswers.org 2009