High Level Design


This use case pertains to an e-commerce website which allows its consumers to purchase items directly from an online store. With the data that is being gathered based on website interactions by online consumers, the brand managers can analyze their own data based on their products’ views and compare it to their competitors.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Online Product Views - Retail Dashboard


Enable brands managers to improve viewers’ interactions with their products to eventually increase revenue.


  • Enable brands managers to analyze trends and get insights on consumers’ habits with regards to their products.
  • Allow each brand manager to compare their performances with their competitors on the online sales platform.

KPI Architecture

Objectives KPIs Measures Data Source
Enable brands managers to analyze trends and get insights on the consumer’s habits regarding their products # of Views # of views: Count(Views) Views
Latest Closed Month Views:  (Count(Views),Last month)

Conditional coloring:

Red – less than precious month

Green – more than precious month

Gauge Scale – 0 – 2Xprevious month views

MoM Growth:

((Count(Views),this month) – (Count(Views),last month))/ (Count(Views),last month)

Views Trend by Month:  Count(Views) per month
Day of Week Distribution: (Count(Views),day of week) / (Count(Views), entire week)
Views Hitmap:  Count(Views) per day
Allow each brand managers to compare his\her performances with their his\her competitors on the online store site Market Share Market Share: Count(View) / (Count(Views),all(Brands)) Views
Me Vs. Others:

My Views: # of views  per category

Others Views: (Count(Views),all(Brands))-Count(View) per category

Top 5 Brands: (Count(Views),all(Brands)) per brand
Market Share Trend:

My Views: # of views  per month

Others Views: (Count(Views),all(Brands))-Count(View) per month


# of Competitors # of Competitors: Count(Brand,all(Brand)) – 1 Views
Top Products 10 Top Products: # of views per Product->Brand->Category->SubCategory Views; Products

 Data Requirements

# Source Table Name Table Details (Type, #Rows, Key field/s)
2 MS SQL Views Fact Table, Key = View ID
3 Products Dimension Table, Key = Product ID

Data Modeling (Elasticube Design)

Suggested data model for online product views analysis