CBMS4303: Information system is one of the big and popular issues where most companies and organizations currently struggling to get the best out of their data management: Management information system Assignment, OUM, Malaysia

University Open University Malaysia (OUM)
Subject CBMS4303: Management Information System

An information system is one of the big and popular issues where most companies and organizations currently struggling to get the best out of their data management. The problem lies not in the process of gathering the information or raw data but in how to manage, interpret and transform those data into something readable and understandable.

Pivot table is one of the functions in the excel application which is very useful due to its capability of processing big amounts and ranges of data into something useful for an organisation to improve their strategies, find mistakes, detect discrepancies and any other problems residing in the company.

Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.

Based on this statement, you are required to write a report based on the raw data given (Superstore X sale data for the year 2009 until 2012). By manipulating the pivot table application, you are required to answer all the information required below and to put it into a report format.

  1. Find the sales trend of the customer segment within the 4 years and,
  • To find the top 10 customers for each of the segments and in each of the years. Requires data and graph
  • To show the 5 most taken Product Names from the group of the top customers and their buying patterns. Requires data and graph
  • To find the highest price (among the four years) for each of the 5 most taken product names. Requires data and graph
  • To find the most preferable ship mode and which ship mode is preferred the most by each of the 5 most taken Product Name. Requires data and graph
  • Use the data in any way necessary to find a minimum of 2 problems and solutions. Each problem and solution must be explained and to be elaborated on in detail.
  • You have to produce a report for these particular question
  • requirements
  1. No numbers are allowed to be mentioned inside the report
  2. Problems and solutions must come from either 1 of the questions
  3. Using any data extracted from the file, you are required to produce a “Dashboard” consisting of any data that you choose from any of the 4 questions above. The dashboard must have the followings:
  • 3 Slicers
  • 1 Timeline
  • 3 Graphs
  • 1 Pie Charts
  • 1 Dashboard Table

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Get Help By Expert

If you’re struggling to get your CBMS4303: Management Information System assignments done on time then Malaysia assignment Help is the perfect website for you. our experts work round the clock to serve the efficient solution on management assignments at a market price.

Answer

Recent Solved Questions

Online Exam & Assignment Writing Services

51770+ Orders Delivered

4.9/5
5 Star Rating

Confidential & Secure Assignment Help For

Group Assignment Help

Online Exam -Test & Quiz

Cheapest Price Quote

Diploma & Certificate Levels

Semester & FYP Papers

Summative & Individual

GBA & Reflective

Last Minute Assistance

Sample Assignment Download

Malaysian Food Delivery Industry Essay Sample
This essay sample is about the Malaysian food delivery industry. The food delivery industry is a booming business in Malaysia. It's not hard to see why - people are too…
Essay Sample
CSC598 Multimedia Research Project Formulation Assignment Example Malaysia
This assignment CSC598 prepares students for performing research. It will discuss the steps in doing research and how to think creatively when solving problems, as it requires you to use…
Computer & It

UP TO 15 % DISCOUNT

Instant Paper Writing Services by Native Malaysia Writers

Plagiarism Free Solutions
100% Original Work
24*7 Online Assistance
Native PhD Experts
Hire a Writer Now

Get Assistance for Assignments, online Exam, and Projects Writing