This is the new one This is the new meta pixel newest one
100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
D2- Justify the information selected to support a business decision-making process £2.99   Add to cart
Quickly navigate to
Preview
  2.  
  3. Pearson
  4.  
  5. Information Technology 2010 QCF
  6.  
  7. Unit 3 - Information Systems

Essay

D2- Justify the information selected to support a business decision-making process

2 reviews
 2490 views  16 downloads

4. Explain and justify in a report format appropriately titled and clearly laid out to the Chief Executive of Matlin Insurance how the information selected to support the decision making process for the car insurance promotion was the correct data, checked for quality and how any alternatives were ...

[Show more]

Preview 1 out of 7  pages

Document information

  • August 18, 2016
  • 7
  • 2015/2016
  • Essay
  • Unknown
  • Distinction

Subjects

Written for

All documents for this subject (74)

2  reviews

review-writer-avatar

By: Osmunda_Archamia.zosterophora • 6 year ago

review-writer-avatar

By: Globularia_Pseudochromis.flammicauda • 8 year ago

reply-writer-avatar

By: • 8 year ago

Thanks for review!

Seller

avatar-seller
Kosteletzkya_Valenciennea.longipinnis

Reviews received

Content preview

D2- Justify the information selected to support a
business decision-making process
In my first report I managed to find valuable information that Matlin Insurance might
be able to use. I used different methods to retrieve information from the excel
documents to produce valuable charts which were the highest selling cars for
2012/2013, worst selling cars, and total car sales for both years. Maltin can then
adjust their business targets to the data I have provided.

Highest Selling Car For 2013 and 2012
60,000 FordFord
Marque Registrations




55,000
50,000
45,000
40,000 Ford
35,000
30,000 FordFord Ford
FordFord
25,000 2013
20,000
15,000 2012
10,000
5,000
0
March April May June
Months

This was the first chart I managed to create from the data I was given which was comparing the highest
selling cars for different years 2012 and 2013. All of the information was found using a helpful tool in excel
called sort which automatically sorted the highlighted values from 2012 (Highest to lowest) this then gave a
brief overview on how the business was coping with the sales figures.

For this chart I decided to make this the bar chart with the axis labels. For this when all the data I needed
was selected I clicked on the Graph tool in excel and chose the bar chart. Now because I wanted to compare
years for both of the data sets of data 2012 and 2013 I simply created 2 individual charts and then combined
them into each other. This then made things easier to compare because the data from both years was right
next to each other so for employees viewing this graph they can see the difference easily. This kind of graph
was better for this situation than other graphs such as a Pie Chart because you wouldn’t be able to combine
them together to see the difference.

Calculating the highest selling car was important so for this the best tool would be to use ascending tool
which was located in the sort tab. So because I wanted to find the highest selling car I would use highest to
smallest rather than the other way around. All this information will be useful in my chart as it allowed for the
Insurance Company to see the bestselling car easily for both years and make decisions of this. I thought this
would be the best tool to use rather than just selecting the highest figures because its more valid as I could
make errors and if the excel document got updated the figures will also get updated.

I have also used the select data tool so that I could label my x axis. This was needed so that users can
interpret my chart clearer because it would be no good having the bars done but no labels it could indicate
numerous things. The select data tool allows the management team at Matlin Insurance to easily read out
the bar results rather than going in the Y-axis and struggling or maybe guessing the result of a certain bar
within the graph. And finally I sued the central alignment tool so that I could underline my x axis all centrally
and all positioned more professionally, this made the chart look presentable so it can be used in
presentations or for customers

For this chart I had to make sure I did a quality check to see if the information was correct so of course I
compared some of the figures from the chart to the raw data I was presented in the excel document. The
information matched for example I double checked the sales figures for all the months in 2012 for ford and it
was the same in the excel document, although I couldn’t see the exact number of registrations the figures
were the same.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Kosteletzkya_Valenciennea.longipinnis. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for £2.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

0 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling

Recently viewed by you

Essay ·

(3)

P6- Explain the potential legal implications of using and editing graphical images

Essay ·

(5)

P5- Describe typical services provided by networks
£2.99  16x  sold
  • (2)
  Add to cart