the objective of this assignment is to introduce the student to the concept of the data model and how it is navigated for ad hoc querying. it is assumed that students will be familiar with basic data manipulation techniques.business context: sprott fishing supplies is a retailer of fishing supplies with a number of stores across canada. customers

This problem has been solved!

You'll get a detailed solution from a subject matter expert that helps you learn core concepts.

See Answer

Question: Objective: The objective of this assignment is to introduce the student to the concept of the data model and how it is navigated for ad hoc querying. It is assumed that students will be familiar with basic data manipulation techniques.Business Context: Sprott Fishing Supplies is a retailer of fishing supplies with a number of stores across Canada. Customers

Objective: The objective of this assignment is to introduce the student to the concept of the data model and how it is navigated for ad hoc querying. It is assumed that students will be familiar with basic data manipulation techniques.

Business Context: Sprott Fishing Supplies is a retailer of fishing supplies with a number of stores across Canada. Customers can sign up for a loyalty card for incentives and most due. This allows Sprott to track customer transactions. Customers can purchase goods by going to the store where inventory is on hand. They may wish to order on line or from a catalogue that is sent to customers once a year. Management has hired you as a consultant to perform analytics by looking at the transactional history and answering some of their questions.

Materials:

SPROTT FISHING DATA MODEL and DATA DICTIONARY.xls

SALES$\_$FACT.SAS$7$BDAT

DATE$\_$DIM.SAS$7$BDAT

$**$ The other dimension tables $($DIM$)$ are found in the tabs of the xls file$**$

Instructions:

Review the data model and data dictionary

Read in the all of the dimension tables in the xls data file into EG

FILE$/$IMPORT

Please ensure that the input format for the length and type of data is the same as the data dictionary when you read the files in$.$

Import the SALES$\_$FACT and DATE$\_$DIM into EG$.$

FILE$/$OPEN

Answer the following questions by making the appropriate joins and aggregations.

Please type your answers and show your results using SAS output or screen shots.

Please ensure that the input format for the length and type of data is the same as the data dictionary when you read the files in$.$

Import the SALES$\_$FACT and DATE$\_$DIM into EG$.$

HOW TO USE SAS ENTERPRISE GUIDE TO BUILD QUERY FOR THE FOLLOWING QUESTIONS.

Questions

How many distinct transactions have been captured in the SALE$\_$FACT? $(2$ marks$)$

How many unique customers have made purchases? $(2$ marks$)$

What is the average transaction size by Region? $(2$ marks$)$

What is the busiest day of the week in terms of transactions for the Toronto Store? $(2$ marks$)$

What is the total sales for the organization by Month & Year and by Region? $(2$ marks$)$

What was the product with the highest sales volume in terms of revenue in the western region in December $1997($month$=12)?(2$ marks$)$

What is the average number of transactions by customer? $(2$ marks$)$

What is the breakdown in revenue by Channel and store for fishing line? $(2$ marks$)$

What is the most popular item in terms of volume for $1998?(2$ marks$)$

Who are the top $10$ customers in terms of revenue for $1997?(2$ marks$)$