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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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