You are a BA that is employed by a multinational professional services (https://en.wikipedia.org/wiki/Professional_services ) firm on the basis of some work you did in ICT394 as a student. You have been contracted out by your employer to a company that sells a large range of random items, called Omnibenchmark Pty Ltd.

Been tasked with creating a data warehouse so Omnibenchmark can analyse their sales in order to assist with their management decision making, in particular, they wish to be to answer the following questions:

-Total of sales of each product by Year/Month/Week/Day

-Total sales of products by supplier by Year/Month/Week/Day

-Total sales by branch by Year/Month/Week/Day

-Total sales of product by branch by Year/Month/Week/Day

-Total sales by sales clerk by Year/Month/Week/Day

-Total sales by product by sales clerk by Year/Month/Week/Day

-Total sales by product type by sales clerk by Year/Month/Week/Day

Below are the sources and the tables within them that are/may be of interest to you. These are discussed below (Primary Key, Foreign Key):

Source 1: Human Resources Database

The Human Resources (HR) database contains data about the people who are employed by The Cold Dog Marketing Company. You have been granted access to a VIEW that includes the data you may need for the various analyses required. It only includes details of employees currently employed by The Cold Dog Marketing Company in a Sales-related position. The view has been supplied to you as a text file.

The VIEW is called viewEmployee and has the following columns:

viewEmployee (EmpID, LastName, FirstName, DateStarted).

Source 2: Inventory System Database

The Inventory System maintains stock levels for all products sold by The Cold Dog Marketing Company as well as the details of the Supplier. There are two tables to which you have been granted access. The Product table, and the Supplier table. They are structured as below:

PRODUCT (ProductNum, ProductName, SupplierNum, ProductType)

SUPPLIER (SupplierNum, SupplierName, Country)

Source 3: Sales Database

The Sales database is an oracle database

SALE (SaleID, ClerkID, CustomerID, SaleDate,)

SALE_LINE_ITEM (SaleID, LineID, ProductID, ProductPrice, Quantity)

SALE_CLERK (Clerk_ID, Clerk_Name, BranchID)

CUSTOMER (CustomerID, FamilyName, GivenName, Address, Suburb, State, PostCode)

PRODUCT (ProductID, ProductName)

BRANCH (BranchID, BranchPostCode)

Stat Scheme:

Dimension Table Dimension Table Dimension Table view Employee Fack Table SALE SALE - LINE_ ITEM EmpID SaleID LoutName LineID (PK, FK ) ProductNum FirstNam Product ID SuppliesNum Sale Date (FE> ProductPrice Dimension Table ProductNum Family Name (FK) SaleDate PRODUCT GivenName (FF) "Total Sales Product ID Addrell Dimension Table Baduck Name BRANCH SupplierName Country Branch Post Code