Data Analysis Half term 1 Recap & Review

Using Data Analysis Software

Introduction, Overview, and Getting Started

05/11/2023

Getting Started

05/11/2023

First off – Why..?

• Operational Support
• Analysis

• Decision Making
• Marketing and Sales
• Communication

05/11/2023

Sources of Data

Internal
• Financial Reports
• Market Analysis
• Destinations Data
External
• Government
• Suppliers
• Trade Bodies

Multiple Select

Which TWO of these are external sources of information?

• Government

• Trade Bodies

• Market Analysis

• Your teacher's opinion

Using Data Analysis Software

Gathering & Types of Data

Multiple Choice

What are the key considerations for data management?

• Timeliness, accessibility, quality, cost-effectiveness, and appropriateness

• Data collection and update frequency

• Easy access for informed decision-making

• Complete and accurate data

05/11/2023

Gathering Information

05/11/2023

Data Types

Multiple “forms” or “types” of data:
Text

Characters
Images
Numbers

Dates
Lack of formal organisation

Drag and Drop

Data collected by companies can be separated into different data types. For example someone's age could be saved as a ​

Placeholder

data type. Their name as a ​

Placeholder

type. Some data may ​

Placeholder

which can still be useful to a company, but can also cause issues in the future.

Drag these tiles and drop them in the correct blank above

Number

Text

Lack formal organisation

Internal

External

Quantitative

Be collected without permission

05/11/2023

Purpose of Text Data

Text can be used to keep records of customer
names, addresses, thoughts and feelings, etc.

Why would this be useful?

05/11/2023

Purpose of Number Data

Number data can be used to collect customers
contact numbers, age, or number of years
they’ve been a customer, etc.

Why is this good information for companies to
have?

05/11/2023

Purpose of Dates Data

Date data can be used to hold customers dates
of birth, date a subscription started or renewal
date.

Why collect it?

Match

Match the following

• Date of Birth

• Number of tickets purchased

• A Name

• Teacher code (TJH, AFS, or SXJ)

• Profile Photo

Date Data

Number Data

Text Data

Character Data

Image Data

• Date Data

• Number Data

• Text Data

• Character Data

• Image Data

Draw

Draw the best picture of Tyler

Using Data Analysis Software

Characteristics of Data

05/11/2023

Key Characteristics of Data

Reliability
Validity
Relevance
Time-frame
Accessibility
Quality
Cost-effectiveness
Appropriateness

05/11/2023

Reliability

How trustworthy is the data?

Where did we get it from? How trusted and
verified is the source?

Reliable data helps to stop poor decision
making.

05/11/2023

Validity

Data validity is basically making sure data is as
expected when storing it.

A good example is emails. If someone give an
email does is follow the usual format
[e-mail] or has it been inputted
incorrectly?

Non-valid data can cause errors when searching
or analysing data

05/11/2023

Relevance

How relevant is the data to what I’m trying to
answer?

Does someone’s shoe size help me understand
their GCSE results?

Relevant data stops people collecting too much
and losing the detail

05/11/2023

Time frame

Is the data up to date and current?

For example, is someone’s address still correct?
Is that their contact number?

Timely data helps companies make current and
modern decisions

05/11/2023

Accessibility

Having lots of data is great, but people need to
be able to understand and access it.

Having accessible data helps different
departments within a business use data to
inform their practices and productivity.

05/11/2023

Quality

Quality data has everything we need about that
information. Have all the necessary fields of
information been given?

Someone may have given me their postcode, but
without their house number I can’t send them
information.

05/11/2023

Cost effectiveness

Keeping up-to-date data is important, but there
is a cost for updating and collecting data.

Consider how often a company needs to check
or collect data – would an annual update be
more appropriate than a daily phone call?

Different data will have different levels of cost
effectiveness.

05/11/2023

Appropriateness

Data collection is a sensitive subject for most.
Businesses and individuals should only collect
data that they actually need to inform their
decisions and support their customer base.

I don’t need to know the inside leg
measurement of your goldfish’s cousin.

Multiple Choice

Reliability of data is:

• Relevance, objectivity, and integrity
• Completeness, timeliness, and authenticity
• Precision, validity, and credibility
• Accuracy, consistency, and trustworthiness

Multiple Choice

Appropriateness of data is:

• How recently the data was collected.

• Completeness of data.
• Suitability and relevance of data for a specific purpose or use.
• Accuracy and precision of data.

Multiple Choice

Validity of data is:

• Ensuring data looks as it is expected to

• Collecting data for a specific business need

• Ensuring data is up to date and current

• How easy the data is to get to

Using Data Analysis Software

Data types recap, when it goes wrong, starting on Excel

05/11/2023

Impact of poor data on businesses

Money
• Time and staffing
• Poor decision making
• Excessive costs
Reputation
• Poor quality of service
• Loss of customer confidence or respect
• Loss of markets

05/11/2023

Excel Functions

05/11/2023

Excel Functions and Formula

+
-

/
*
=

(add)
(minus)

(divide)
(multiply)
(starts a formula or checks
if two things are the same)

SUM()
AVERAGE()

COUNT()
COUNTA()
IF()

(Add everything in the brackets)
(“Mean” in the brackets)

(Cells filled in the brackets)
(Cells NOT filled in the brackets)
(Formula checks criteria and gives
answers based on what you’re
wanting out)

Word Cloud

What are two things you've enjoyed about data so far?

Word Cloud

What are two things you've not enjoyed about data so far?

Poll

Do you know what you need to do to pass your course?

• I don't care

• I'm not sure

• I have an idea

• I understand fully

Poll

Do you have what you need to succeed in this course?

• No, there's nothing I want you to do to help me.

• No, I would like some more help.

• Yes, I get all the help I need.

• Yes, but I would like more support to get a Distinction.