Lab Work 2_Pivot Table.docx - Multi-dimensional Reporting...

This preview shows page 1 - 3 out of 12 pages.

Multi-dimensional Reporting With PivotTables Lab Work 2 MOTIVATION You are a manager of Global Bike Incorporated and one of your responsibilities is to make decisions related to ordering, promotions, customer discounts as well as monitoring and managing the daily operations of the store. You have a number of OLTP systems to assist with the day to day transactions. Each month you are provided with a report which displays each sale. The format of the report is illustrated below. Although this report provides a lot of information, the information is not in a format which can assist in the type of decisions you are required to make. You have decided to investigate PivotTables as means to producing more useful reports LEARNING METHOD The learning method used is “guided learning.” The benefit of this method is that knowledge is imparted quickly. Students also acquire practical skills and competencies. As with an exercise, this method explains a process or procedure in detail. Exercises at the end enable students to put their knowledge into practice. Product Microsoft Excel 2007/2010 Level Beginner Focus Multi-dimensional Reporting Author Paul Hawking Hafizi Muhamad Ali Course MIS440 Management Support Sys. Name Student ID Section Hafizi Muhamad Ali 1 November 2019
Image of page 1
The primary purpose of an information system is to process information to produce reports to facilitate decision making. Reports may appear in various formats and used to support a diverse range of organisational decisions. Reports provide a mechanism for organising, analysing, presenting and delivering information to end users. A common classification of reports is based on the types of systems which they are built from. On-Line Transaction Processing (OLTP) systems as the name suggests are optimised for transaction processing. They process real time information and are accessed by many users. The reports are derived from the various business transactions and predominately support tactical decision making. An alternative information system is On-Line Analytical Processing (OLAP). This type of processing allows users to analyse information by creating multidimensional reports. They deal with large volumes of aggregated historical data. OLAP based reports are more flexible than the more traditional reports produced by an OLTP system. As mentioned previously OLTP reports provide information about particular transactions. The type of reports an OLTP system produces could include: Who purchased a particular product? How much did an employee get paid? How many of a product was manufactured? The flexibility of OLAP reporting assists end users in understanding why particular business events have occurred and or forecast what may occur in the future. The types of questions an OLAP system can assist with could include: What are the total sales for each product?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 12 pages?

  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors