Analyze the data in at least three different ways

Assignment Help Database Management System
Reference no: EM13779621

Organize the Data

Professional formatting follows the formatting guidelines we studied during the first week of class.

Documentation sheet added to provide author, purpose, and date and provide information about each of the sheets you will create as you analyze the data.

At least one calculated field added and copied to all cells in the worksheet.

Analyze the Data

Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, comments, and explanation. Remove any extra sheets so your workbook is as compact as possible when you turn it in. Go back and review your labs for assistance in completing the different types of analysis.

The following are some examples of analysis you might wish to do:

Sort by discount level. Have discounts increased sales volumes? Is there any discount level that appears to be more effective than others?

Graph sales over time to see trends. Are there any peaks and lows in sales? Is there any time of year in which sales are highest? Lowest?

Pivot the data to see total sales by quarter, country, category, and salesperson. Are there any highs? Are there any lows that need to be addressed?

Subtotal the data. How are quarterly sales totals? Sales totals by salesperson? By Country?

Challenge Option: Perform What-If Analysis. What if prices were raised by a certain percentage with a slight decline in sales? What combination of price increases and decline in sales makes most sense?

Reference no: EM13779621

Questions Cloud

Develop three topics sentences that articulate : Develop three topics sentences that articulate the major ideas that will comprise the body of your essay. Remember that your topic sentences should clearly state the argument or point to be made in the respective paragraphs.
Herzberg''s two-factor theory issues : What are your recommendations to make this course better?
Describe a sole proprietorship : Describe a sole proprietorship and discuss its advantages and disadvantages. Describe a partnership and discuss its advantages and disadvantages. Describe a corporation and discuss its advantages and disadvantages
Graphical and verbal explanation : Motels along Myrtle Beach, South Carolina, charge $120 a night in the summer but sometimes as little as $35 a night in the winter. Use supply and demand analysis, including graphical and verbal explanation, for these winter "sales."
Analyze the data in at least three different ways : Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, co..
Give an accurate forecast for the long term : The Not-So-Popular Nordic Bridge www.economist.com/node/387500 Three questions: Explain why the demand for the bridge is likely to be price-elastic. If the Swedish governemnt esimates that the price elasticity is -1.4 claculate the effect on traffic ..
Ethical arguments to other types of arguments : The purpose of this discussion is to help you understand how to construct an ethical argument and how to compare ethical arguments to other types of arguments,
Kind of constructive role : Do you agree that (to use a famous phrase from the eighteenth century Prussian philosopher Immanuel Kant), awakening an individual--or an entire society--from "dogmatic slumbers" is a constructive and useful role of raising probing philosophical q..
Implementation issues for it security policy development : Examine the implementation issues for IT security policy development. Determine which of these issues are the most challenging for organizations to overcome and explain why.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write select statement that returns two columns

Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.

  Identify the different components of an erd

Identify the different components of an ERD and recognize some business rules from the relationships contained in an ERD

  Explain the following elements of network performance

There is a growing requirement to meet or exceed expectations of end users and applications communicating over a packet-switched network. In order to fulfil this requirement, different techniques are used to improve the QoS.

  1kate and leopold are thinking about-buying the rockwood

1.kate and leopold are thinking about-buying the rockwood motellocated on interstate 70. before they make up their mind

  Why might an organization select mysql over sql server

Large-scale database are available on several platforms. Among those are MySQL, SQL Server, and Oracle. Other than cost, why might an organization select MySQL over SQL Server or Oracle

  Create a use case based on relating functional requirements

Describe (in a one to two (1-2) page narrative) a use case, complete with typical and alternate courses, that documents the event of a bank customer withdrawing money from an ATM.

  Create a clustered index on the groupid column

Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividuallD column of the GroupMembership table.

  Compose conceptual data modeling techniques

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

  Find the resulting tuples of the given query

What time does it take to find the resulting tuples of the given query: "List the names of all students who are taking a class in the Turing Auditorium".

  Use sql to create database

Use SQL to create the following database; to including referential integrity. You may NOT use the GUI for this part of the exercise. COURSE ( CourseNu, CourseName, CreditHrs).

  Write methods for outlier detection

Exceptions in credit card transactions can aid us fraudulent use of credit card. Suggest two methods for outlier detection.

  Design a nested menus interface for a check-in

Design a nested menus interface for a check-in and check-out hotel reservation system that can be used internationally.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd