A star schema is a type of data warehouse design that optimizes multidimensional query performance (Poolet, 2007).

Below is the answer-

Star Schema – Star schema is used to store warehouse information in the form of dimensions and facts. A fact table consists of business mesaures that can quantify the things. For Example- the sales amount for the products. The Dimension tables describes the various entities/dimensions in the start schema.

I have created the Star schema that contains the Fact and dimension tables and this diagram also list down the various attributes as well.

A large online company’s marketing department needs information to examine sales, predict future directions, and determine how and what to advertise-

To perform this we would have to follow a 2 step process-

1. Firstly, we need to create the Facts and dimension tables in the warehouse and then establish the link between the tables based on the primary keys of dimension tables.

2. A well-designed schema provides dimension tables allows a user to browse a database to become familiar with the information in it and then to write queries with constraints so that only the information that satisfies those constraints is returned from the database.

3. Below information can be collected to analyse-

A salesperson analyzes revenue by customer, product and time period.
A financial analyst tracks actuals and budgets by line item, product, and time period.
A marketing person reviews shipments by product, market, and time period.

Star Schema for Sales –

Regards,

Vinay Singh