High Level Design
OverviewThis 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.
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.
|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)
Red – less than precious month
Green – more than precious month
Gauge Scale – 0 – 2Xprevious month views
((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|
|#||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)