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

  Types of relationships in a design model of a database

There are many kinds of relationships in a design model of a database. Why is it important to classify each of these types in an ERD Model?

  Explain thoughts on database design process

Explain thoughts on database design process this far. You have learned about first three phases of process: defining mission statement and mission objectives, analyzing current database, and creating data structures.

  Physical design and implementation it requires the use of a

physical design and implementation it requires the use of a relational database management system. strayer university

  Sales transaction in retail clothing

Examine different sales transactions. Design a context diagram and a level-0 diagram that represent the selling system at the store.

  Explain issues to convert relationship for new cardinality

Using example of vehicles and drivers, explain issues to convert relationship for new cardinality including new relationships and attributes for the tables.

  Estimated costs and expected activity

Abel Company uses activity-based costing. The company has two products - estimated costs and expected activity

  Describe product characteristics and deliverables

Develop a scope statement for the project and describe product characteristics and deliverables.

  Implementation of virtual private databases

SQL implements VPD using the VIEW object while Oracle10g provides specific functions for row-level security and fine-grained access.

  Your database has been a hit you have been called back to

your database has been a hit. you have been called back to the customers headquarters and they want a detailed report

  Draw the er diagram for the database described above

Consider a video game store. For each game, the database contains information about title, producing company name, designer(s) name(s), version of the game, type of the game and characters in the game

  Explain relational database design and implementation

ISYS 224 Database Systems - Relational Database Design & Implementation

  Draw an initial entity-relationship model

Normalise the Project Allocation form (Fig 1) to arrive at third normal form entities. Show all the steps of normalisation clearly.

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