Spreadsheet Applications And Data Analys

Assignment Online Analytical Processing (OLAP) Paper

Introduction

Assume your organization sells cars and there are 5 models of cars. The company sells all over the United States and so the organization is broken down into regions of the country which include East, West and Central. Further, each region has multiple dealerships that sells cars and each dealership has many salespeople. If you wanted to find total sales for the company or a region you could simply query the database. Because this data is made up of multiple facets (different models of cars, different regions, different dealerships, different sale people), if you want to delve further into analyzing the data, such as comparing dealership sales and within region by model, you would need to look at these different aspects of the data for comparison. Online Analytical Processing (OLAP) is a concept used just for this purpose. PivotTables are a good example of an OLAP technology.

Instructions

Write a 2 page paper on the concept of OLAP. Summarize an example of a dataset that could be used for OLAP. Compare and contrast OLAP to database querying. Explain the benefits of using OLAP to analyze data for the example you’ve presented. Last, expand on how PivotTables and PivotCharts fit the mode of being an OLAP tool.

Don't use plagiarized sources. Get Your Custom Essay on
Spreadsheet Applications And Data Analys
Just from $13/Page
Order Essay

Writing Requirements

·        2 pages (approx. 400 words per page), not including title page or references page

·        Cite 2 different sources in paper

Tips for Success

Instead of just Googling for answers try using an University Library databases and/or library guide for this course.

Weekly Learning Goal(s): [No.2]

2.    Evaluate how PivotTables and PivotCharts, which is based on the concept of Online Analytical Processing, can be used in business to analyze data to aid in decision making. (CLO #5)

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper
Live Chat+1(978) 822-0999EmailWhatsApp