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

Stories to compare: Thoma King’s ‘The Baby in the Airmail Box ” and Susan Swan’s ‘The Man Doll’

Description Using the following essay prompts, create a specific argument. 1) In many works of literature, romantic relationships between characters create,  clarify, or complicate central themes of the work; or, in other words, these  texts use a romantic relationship—positive or negative —to contribute to the  meaning of the work as

In this assignment, you will create a comprehensive culmination presentation and portfolio that displays your understanding of the core academic

In this assignment, you will create a comprehensive culmination presentation and portfolio that displays your understanding of the core academic activities, your personal experiences as it relates to core academic activity objectives, and your plans for professional development aligned with course learning objectives. Course Learning Objectives: 1. Apply knowledge about

You might describe your company by a SWOT analysis as

You might describe your company by a SWOT analysis as follows: Strengths: attributes of the organization that are helpful to achieving the objective. Weaknesses: attributes of the organization that are harmful to achieving the objective. Opportunities: external conditions that are helpful to achieving the objective. Threats: external conditions that

Anti-Discrimination Laws Related to Employment Your supervisor has placed you

Anti-Discrimination Laws Related to Employment Your supervisor has placed you in charge of hiring a new, full-time administrative assistant for your department. · Prepare an advertisement for that position that complies with federal law. This advertisement must be detailed. The minimum length of your job description must be 300 words

ACMB01 – Argument Essay Prompt – Spring 2019

Prompt: Scholars and social critics have long been concerned with the issue of language: the ways in which linguistic articulations (whether verbal or textual) shape our reality, the ideology reflected in the language we use, who has the power to speak and be heard, and the consequences of each of

In this section from the two possible solutions, select the

In this section from the two possible solutions, select the best one that you recommend. You must justify your recommendation. Why is it the best solution? Identify consequences of your decision. Why is your recommendation better than the alternative? In this section, explain how bias could influence your perspective. First

In this assignment, you will develop a risk matrix that

In this assignment, you will develop a risk matrix that analyzes key risks from one of the mini-case studies. You will analyze the cause of each risk, estimate its probability of occurrence and its potential impact, and recommend a response to each risk. You will also analyze the skills and competencies

Find a peer-reviewed scholarly journal article discussing big data analytics.

Find a peer-reviewed scholarly journal article discussing big data analytics. Complete a review of the article by writing a 2-3 page overview of the article. This will be a detailed summary of the journal article, including concepts discussed and findings. Additionally, find one other source (it does not have to

you have an autographed CD by Drake and put it

you have an autographed CD by Drake and put it up for sale on eBay. So far, the highest bid is $74.50. A friend has offered you $100 for the CD, commenting that he could get $150 for it on eBay in a year. You know this is highly unlikely.

Compare and contrast, in detail, at least two types of

Compare and contrast, in detail, at least two types of pluralism. Do you think the United States is becoming more pluralistic? Why or why not? How do ethnic enclaves relate to pluralism in the US? Please share an experience of visiting an ethnic enclave or grocery store with the

A “criminal minds” Aileen Wournos individual will be your “patient”

A “criminal minds” Aileen Wournos individual will be your “patient” A brief history of the patient including diagnoses (documented or your thoughts if no diagnosis is recorded) and medications (if applicable). Not a lot of gory details about their crimes. Any substance abuse, addiction or violence issues surrounding this

The situation. Healthcare providers need access to patient personal health

The situation. Healthcare providers need access to patient personal health information wherever patients are present for care. Systems that standardize electronic medical records provide such access, but the risk to privacy that accompanies that access is real, and breaches often make the news. At the Federal level, the HIPAA Privacy

Describe your chosen character in adequate detail so that your

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

What were the three biggest factors in how the United States developed

This essay should be a standard five part essay, an introduction, essay body concerning three sections of ideas proving your overall argument, and a conclusion. It must have a minimum of 1250 words. Introduction: (As obvious as it sounds), this is the opening paragraph where you will coherently and concisely

If your last name begins with “P… – Q… “

Part 1 This discussion is set up as a group

Part 1 This discussion is set up as a group discussion so that you can share information with your colleagues and benefit from the information they share with you. After considering all pieces of information from the discussion post, you will determine if the building of a wildlife crossing could

part one . Is staffing currently adequate at your facility?

part one . Is staffing currently adequate at your facility? Why or why not? How could you promote changes to ensure staffing becomes or remains adequate? Part 2 Review these most common sentinel events in healthcare TED talk on Transparency, Compassion, and Truth in Medical Errors. (Links to an external site.)

Read 1 Corinthians 14:20 and respond to the following in

Read 1 Corinthians 14:20 and respond to the following in an original post of no less than 200 words. What do we typically think of when we think of the spiritually mature person? Does our image of spiritual maturity typically involve someone who is savvy in research and scientific methodologies?