0

6.1kviews

A manufacturing company has a huge sales network. To control the sales, it is divided into regions. Each region has multiple zones.

written 5.6 years ago by teamques10 ★ 68k

•   modified 4.8 years ago

Each zone has different cities. Each sales person is allocated different cities. The objective is to track sales figure at different granularity levels of region and to count no. of products sold. Design a star schema by considering granularity levels for region, sales person and time. Convert the star schema to snowflake schema.

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

2 Answers

1

971views

written 5.6 years ago by teamques10 ★ 68k

•   modified 5.6 years ago

ADD COMMENT SHARE EDIT