Exam (elaborations)
Unit 5 Data Modeling
- Module
- Unit 5 - Data Modelling
- Institution
- PEARSON (PEARSON)
Distinction achieved
[Show more]
2 reviews
By: onyx1 • 2 year ago
By: hammadhussain7861 • 3 year ago
Content preview
DATA MODELINGBY:Ibrahim Zitouni
[DATE]
[COMPANY NAME]
[Company address]
,Contents
Introduction.................................................................................................................................................2
Scenario.......................................................................................................................................................2
Identifying information and sources............................................................................................................2
Spreadsheet features to support data modelling........................................................................................8
Using data modelling to consider alternatives...........................................................................................13
Benefits and limitations of alternative solutions:......................................................................................15
Impact and consequences of alternative solutions:...................................................................................15
Evaluating models:.....................................................................................................................................16
Documenting and justifying decisions:......................................................................................................17
Analysis of advanced features and functions of spreadsheet software:....................................................17
Overall evaluation of advanced features of spreadsheet:.........................................................................19
References.................................................................................................................................................21
, Introduction
In this project, I will look at the foundations of decision-making and see how data modeling can be used
to analyze outcomes as well as decide a specific result. Consequently, this could assist me in developing
a range of tools including strategies required to build comprehensive spreadsheets, which I would be
able to generate reliable data which might aid in decision-making. As a result, I will go through the
phases of the decision cycle, as well as other topics like spreadsheet functionality, potential
considerations, evaluation metrics, including the need to establish evidence and justifications regarding
the models.
Scenario
I have recently joined the a company that has recently been open in London as trainee data analyst. My
employers specializes in the range of cheese where they import the cheese to countries within Europe
especially in France as well as Netherlands including various restaurants throughout the UK . The
company has problems related to the currency fluctuations. I have been asked by my employers to
predict future sales as well as create a report on the different ways spreadsheets could be used.
Identifying information and sources
I'll define the kind of data I'll require as well as where it'll emerge from within this section of the
decision-making method. In addition, I will check to see if the data I have is accurate.
Often, most of the data I require is currently included within the scenario, thus I should remain
undertaking all of the steps necessary to create a good data model free of flaws or irregularities.
An example of identifying information:
This instance shows how to build a table containing data by using one of the tools mentioned
beforehand to help correctly define details. This might well support me because each piece of
information will be entered under the appropriate heading, as shown above which begins with cells "B3
to E5". As a result, by having a relevant spreadsheet data model, every user can understand what data is
being displayed.
An example of identifying data sources (Microsoft Excel):
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 ibrahimzitouni1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £8.89. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
65040 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
Recently viewed by you
Summary ·
Resumen tema 7 DA II
Exam (elaborations) ·
CHM1 Exam 2 Graded A+
Summary ·
Overview of brain scanning
Exam (elaborations) ·
Digital Marketing Strategy
Package deal ·
best exam 2023/2025
Summary ·
samenvatting H9 Kant
Summary ·
Sociologie (2018-2019)
Flashcards ·
Flashcards PCCD
