Our Services

Get 15% Discount on your First Order

Assume that Orion Star Sports & Outdoors Co. has engaged

December 7, 2021

Assume that Orion Star Sports & Outdoors Co. has engaged you as a consultant to advise them on business strategies to increase sales. Study the data tables from this perspective. The most important tables in this data set are:

+ orders + product_line

+ products + profit

1. Answer the following questions in general:

a) What are the key business questions that can be asked and answered using this data?

b) How does each table relate to answering those questions?

c) How do I have to link the tables in order to be able to answer those questions?

2. For each field in the four tables, answer the following specific questions:

a) Is this a question field, an answer field, or a link field? In other words, is this a key dimension along which I wish to analyze the data (question field), a data item that I want to “slice and dice” along selected dimensions (answer field), or a field that simply helps me link from one table to another?

b) What data type is represented by this field (e.g. integer, text, symbols, currency, etc.)?

c) Are there missing or null values in the data for this field?

d) For range fields (e.g. dates and numbers), what is the range of values in the data? What are the maximum and minimum values?

e) What do you think is the purpose of this field?

f) What questions would you ask the company about this field?

3. Prepare spreadsheets that answer the following questions:

a) What are the top 10 products for orders (by dollar volume)?

b) What are the top 10 countries for orders (by dollar volume)?

c) What are the top 10 selling products by units? By dollar volume?

d) For top two US states and top two countries (excluding the US) in questions 1 and 2, what are the 5 top selling products by units? By dollar volume?

e) Provide the customer ID’s, order dates, and order amounts for all customers who have ordered more than once.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Using the readings, discuss the role of the Doctorate of

Using the readings, discuss the role of the Doctorate of Nursing Practice (DNP) as an innovator by translating evidence into practice. Include content on interprofessional collaboration to support innovation. This assignment contains an initial 250 – 300 words post in response to the posted topic. APA and a minimum of

“A brand is a story always being told” -Scott Bedbury

“A brand is a story always being told” -Scott Bedbury (Nike and Starbucks executive), quoted in “11 Simple Steps for a Successful Brand Building Process.” LinkedIn is a powerful social media tool that can help you communicate your personal brand. For the Unit 4 Assignment, you will download and complete

Six Sigma projects are powerful tools for achieving breakthrough improvements.

Six Sigma projects are powerful tools for achieving breakthrough improvements. Improvement projects utilize the Define, Measure, Analyze, Improve, and Control (DMAIC) methodology while design or re-design projects use the DMADV methodology. Such projects can be undertaken for large or small initiatives, but because they require a fair bit of work

Assignment Instructions 1.Prepare the journal entry to establish the petty

Assignment Instructions 1.Prepare the journal entry to establish the petty cash fund. 2.Prepare a petty cash payments report for April with these categories: delivery expense, mileage expense, postage expense, merchandise inventory (for transportation-in), and office supplies expense. 3.Prepare the journal entries for part 2 to both (a) reimburse and

ASSIGNMENT:DUE: Midway through onsite experience I DID AN INTERNSHIP BUT

ASSIGNMENT:DUE: Midway through onsite experience I DID AN INTERNSHIP BUT I NEVER GOT THE CHANCE TO DO A JOB ANALYSIS ON AN EMPLOYEE. I NEED HELP ON MAKING A FAKE ONE. I ATTACHED THE ACTUAL EXISTING JOB DESCRIPTION ALREADY. IT CANNOT BE THE SAME AS THE DOCUMENT I ATTACHED. YOU

What are the advantages and disadvantages of (a) nonprofit Nursing Assignment Help

What are the advantages and disadvantages of (a) nonprofit status and (b) publicly traded stock that provides incentives to physicians? Please frame your response by providing examples that demonstrate, make clear, and support your answers. You are a medical professor in charge of creating college assignments and answers for medical

Time Value of Mooney

Time Value of Mooney Extensive research on the above topic (Should be more of finance based). Use examples, show an application of the topic, and critically analyze the subject, including any calculations. FREE FROM PLAGIARISM #Time #Mooney

The intended audience of this presentation is a CEO/CIO panel

The intended audience of this presentation is a CEO/CIO panel that is considering adopting new project management approaches to create more value from information systems development projects. Prepare a maximum 40 slide professional PowerPoint deck that explains advanced project management practices on Resource Management, illustrates experiences/applications of such techniques, and

A large lawn sprinkler with four identical arms is to

A large lawn sprinkler with four identical arms is to be converted into a turbine to generate electric power by attaching a generator to its rotating head, as shown in the below figure. Water enters the sprinkler from the base, along the axis of rotation, at a rate of 20

What is the developmental impact on children and teens who

What is the developmental impact on children and teens who excessively participate in gaming? Is it ethical for media to specifically target children and teens with directed marketing messages? What is the impact on children and teen socialization as they move into adulthood when there has been excessive utilization

As discussed in Chapter 12 in the Bartol & Bartol

As discussed in Chapter 12 in the Bartol & Bartol (2019) text, in most circumstances, rehabilitation and reintegration of offenders is the goal of the criminal justice system as evidenced by the number of offenders ultimately being released back into society. This includes concerns for public safety, the behavior and

Based on this article: https://www.thoughtco.com/pros-cons-of-embryonic-stem-cell-research-3325609 What main argument (or claim)

Based on this article: https://www.thoughtco.com/pros-cons-of-embryonic-stem-cell-research-3325609 What main argument (or claim) does the author make? Summarize the reasons the author uses to support the claim. What viewpoints may audience members have that oppose the author’s main argument? Is the author biased? Why or why not? What does it mean to be

The first part of this assignment is to construct a

The first part of this assignment is to construct a spreadsheet of all the ratios (attached) for a publicly-traded company you have chosen to research. You will calculate the last 3 years for your company and the previous 3 years for a primary competitor for each ratio. The second

Class, we are all familiar with individuals’ credit scores. What

Class, we are all familiar with individuals’ credit scores. What about businesses and organizations? Yes, we can also review their scores! One of the scores is called credit rating generated by credit rating agencies such as Moody’s, S&P, and Fitch. Can you check on the credit rating of the

Opiate Use Disorder Case Study

Please do not attempt to work on this paper if you’re not familiar with writing case studies or unsure what to write. Also, its time sensitive, so if not finished in 24 hours, please cancel the order. Thank you in advance. The case study provided below, and extra details in

Machiavelli Ideology on Hobbe’s Leviathan

The paper should be 1700 words long. Double spaced, Times New Roman, Must have citations in APA format (with the page number in the citation). Answer the questions below exactly as it is asked. Sources used will be The Prince by Machiavelli and Leviathan by Hobbes. Don’t use other sources.

Acute Flaccid Paralysis Questions Nursing Assignment Help

Expert Solution Preview Introduction: As a medical professor responsible for creating college assignments and evaluating student performance, I would like to provide an answer to the query regarding content related to medical education. Answer: Medical education encompasses a broad range of topics, including basic sciences, clinical skills, and patient care.

Find an online news article involving any kind of juvenile

Find an online news article involving any kind of juvenile case that you want to discuss. Based on what you have learned so far in this course, address the following: Summarize the article Present your analysis of the case Describe why you agree or disagree with what is reported about