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

School

Open University Malaysia (OUM)

*We aren't endorsed by this school

Assignment Type

Individual Assignment

Subject

CBMS4303: Management Information System

Uploaded by Malaysia Assignment Help

Date

14/04/2022

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.

Stuck in This Assignment? Deadlines Are Near?

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 30% Discount on This Assignment Answer Today!

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

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
Convincing Features
Plagiarism Free Report
On-Time Delivery
Native Writers
A+ Quality
100% Confidential
24*7 Online Assistance

Get these features included in Your Assignment

Get Assistance for Assignments, online Exam, and Projects Writing