Question

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.

Instructions:

1. Review the data model and data dictionary

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

3. 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.

Answer 1

As a consultant for Sprott Fishing Supplies, my work focuses on analyzing customer transactional history to assist in strategic business decisions. This analysis draws from data across in-store, online, and catalog sales, emphasizing loyalty card transactions. Your role mirrors this analytic nature but within the international trade and ESG advisory context.

Step-by-step explanation:

The question pertains to Sprott Fishing Supplies, a retailer specialized in fishing supplies with a presence across Canada. As a consultant hired by their management, my task involves performing analytics by examining the transactional history of customers who make purchases through various channels. These channels include in-store, online, or through a catalog sent to customers annually. Understanding customer transactions, especially from those holding a loyalty card, provides invaluable insights into purchasing trends and behaviours, which can be leveraged for strategic decision-making.

Your role as an international trade coordinator involves coordinating grain purchase contracts, export operations, supporting offshore operations, and contributing to international arbitration panels. Notably, you also play an advisory role on the company's ESG committee, which aligns closely with the current investor trend of utilizing ESG indicators for investment decisions. These activities are critical as they influence not just the profitability but the corporate reputation in a global context.