Summary
Summary Unit 5 : Data Modelling Assignment 2 all criteria met
- Module
- Data Modelling
- Institution
- PEARSON (PEARSON)
Unit 5 : Data Modelling Assignment 2 all criteria met
[Show more]
Seller
Follow
Content preview
BTEC LEVEL 3 – ITUNIT 5 – Data modelling
B: Design a data model to meet client requirements
C: Develop a data model to meet client requirements
,Table of contents
Introduction
In this project, I was recently chosen to work as a trainee data analyst for a new
organisation.
First and foremost, I am willing to create a useful spreadsheet model that can
anticipate the impacts of currency changes on company profit margins. I'II use this
information to design a data model that meets all of the client's criteria, such as
worksheet structure diagrams and the ability to include a test. The design would
subsequently be reviewed with additional clients to identify and recommend
adjustments. In addition, I will explain how the specifications are totally met,
followed by a comprehensive and reasoned analysis of the optimised data model in
contrast to existing customer needs.
P3 - Produce designs for a data model which meet client
requirements.
Scenario
My client required a data model that could calculate currency conversion rates
between the Euro and the Pound Sterling depending on various circumstances. The
client submitted the necessary data, which included the pricing of several types of
cheese in Euros and the average monthly sales. When the exchange rate varied, the
company had two options: drop the profit margin to keep the same pricing, or raise the
price while retaining the margin, which could result in a decrease in sales. As a result,
the organisation needed a solution to assess the impact of these two possibilities. In
addition to addressing the needs of the customer, the data model had to be created in
such a way that both technical and non-technical users could use and comprehend it.
Functions the model must perform
The spreadsheet data model must be capable of converting Euros to Sterling Pounds. This is
accomplished by dividing the base price by the exchange rate. Furthermore, the profit margin
should be calculated by removing the cost per kilogramme in pounds from the sales price. The
total profit is derived by multiplying the profit margin by the total sales. The model should
automatically update and determine the new average sales price whenever the currency
conversion rate changes. By including these aspects, the data model may give the cheese firm
with a full financial picture that takes the foreign exchange rate and any swings in sales price or
profit margin into consideration.
Design - user interface
, Main page
I created home page for the spreadsheet model that is intended to improve the user
experience and facilitate navigation throughout the document. This page serves as a
guide, allowing users to easily scroll through the spreadsheet and locate the
information they need and also navigate other pages of the spreadsheet. The design is
a testament to my ability to create effective solutions that align with client
requirements. I am confident that this page will improve the usability and efficiency
of the spreadsheet.
This page have bottoms to cheese pages, data, exchange rate and result which will
help the client to understand and explore data quickly, as it is important to organise
and categorise data into local format.
Cheese Pages
It is critical to designate separate pages for different varieties of cheese because this
will allow for more efficient data organisation and analysis. With specific websites for
each cheese variety, it is easy to compare and contrast crucial data such as production
volume, sales income, and customer feedback, which can provide useful insights for
the company's decision-making processes. Furthermore, having the data organized
logically and structurally can help to reduce errors and ensuring that the information is
easy to access and update as needed. Overall, categorizing cheese into various pages
is a best practice for data management that can assist to increase the accuracy and
usefulness of the data being gathered and analyzed.
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card for the summaries. There is no membership needed.
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 khaderhajji. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.96. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
66579 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now