Digital: Data and analysis Flashcards

1
Q

What is data?

A

1: factual information (such as measurements or statistics) used as a basis for reasoning, discussion, or calculation;
2 :information in digital form that can be transmitted or processed; and
3 :information output by a sensing device or organ that includes both useful and irrelevant orredundantinformation and must be processed to be meaningful

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data vs information

A

Data: raw, unprocessed facts and figures
Information: data that has been processed in a way that makes it meaningful for planning and decision making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

’information in digital form

A

Digital Form:
1 and 0 = 1 bit (binary system)
10101010 = 8 bits = 1 byte

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

data Size

A

If in weight 1000g = 1kg then 1000 Bytes should be 1KB (Kbyte)
A kilobyte is approximately 1,000 bytes (in fact 1,024 bytes)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Financial data

A

Standard metrics checked and best understood by the organization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Enterprise data

A

Financial data plus broad operational and transactional data that bolsters analysis and forecasting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Big data

A

Enterprise data Communicating the above insights to users and contributing to an objective, responsible perspective to influence their decision making
What is Big Data?
Big Data is an emerging technology that has implications across all business departments. It involves the collection and analysis of large amounts of data to find trends, understand customer needs and help organisations to focus resources more effectively.
Big Data has a role to play in information management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Collecting data

A

Formal data collection
This happens when an organisation needs specific data to fulfil a particular purpose.
Informal data collection
Happens continuously, e.g. when employees learn about what is going on around them
via newspapers, websites, etc.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Sources of Data

A

Internal Sources
Accounting record
Human resources
Production data
Sales and marketing data
Timesheet

External Sources
Customers – product requirements & price elasticity
Libraries & information services
Newspapers, journals & the internet
Government agencies i.e. Stats SA or SARS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Structured data

A

Clearly defined data types within a structure.
Normally this structure is a type of database and / or other file where the data is stored in rows and columns.
Recorded in predefined fields and formatted appropriately.
Allows for easy manipulation and analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Quantitative and qualitative information

A

Qualitative Information
Can be given a value, e.g. $100m
Financial statements: Balance sheets, income statements, and cash flow statements that provide numerical data on a company’s financial performance.
Stock prices: The price of a company’s stock can be measured and tracked over time.
Interest rates: The rate at which money can be borrowed or invested can be measured and analysed to determine financial strategy.

Quantitative Information
Cannot be given a value, colour, subjective rating
Market sentiment: The overall mood of investors and traders can influence stock prices and financial trends.
Brand reputation: A company’s brand reputation can affect its long-term financial success and value.
Customer satisfaction: The opinions and experiences of customers can influence a company’s financial performance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Qualities of information

A

Accurate
Complete
Cost-effective
Understandable
Relevant
Accessible
Timely Easy-to-use

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Data modelling

A

Analysis of an organisation’s data needs to support its business processes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Data manipulation

A

Reorganisation or transformation of data to make it easier to read or more meaningful

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Data analysis

A

Overall process of collecting, cleansing, manipulating and modelling data to support decision making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The role of the finance function in data modelling

A

Three stages to data modelling:
Conceptual model:
Consultation with internal stakeholders to determine and record data requirements.
Logical model
Data requirements are developed into formal documents.
Physical Model
A physical model is created to manage data and the relationships between data sets and tables.

17
Q

Advantages of data modelling

A

Foundation for handling data effectively

Business rules enforced on data and security

Quality of data is enhanced

Consistency is improved

18
Q

Types of data analysis

A

Exploratory
Finding new relationships or features in a data set

Confirmatory
Confirming, or disproving a hypothesis

Predictive
Making forecasts, based on techniques such as statistical modelling

Text
Extracting and classifying data from textual data sources

19
Q

A methodical approach to data analysis

A

Plan the analysis
Collect and enhance the data
Perform the analysis
Review and communicate results of analysis

20
Q

Plan the analysis

A

Understand the business and the nature of the problem /need for analysis / message to communicate - what data analysis are required – Ensure you understand - What is the objective of the analysis
Identify what data is needed to perform a meaningful analysis
Consider:
Who is the data owner of the information
Where is the data located (locally within the organisation/ cloud or at a 3rd party) – How can the data be accessed, or do we need assistance from IT.
What format will the data be in. (e.g. SQL database/ xls /csv file)
When will the data be ready for collection. Volume of the data / how will it be transferred/ encrypted
Required fields for the analysis ( do we know the meaning of the data ( is a Data dictionary available – else create one? Master tables or transactional files))
Create a formal data request for the data (audit trail and required approval and permissions)

21
Q

Collect and enhance the data

A

Collect the data
Maintain a register of data collected
Choose analytic tool(s) best suited to the analysis of your data and to meet the objective
Assessing data quality and completeness
-MAKE A WORKING COPY
Perform a reconciliation of what was received vs what was requested
Compare record counts to control totals
Compare data import to system printouts or screen views you may request
Test that you have what you need and nothing more as defined in your scope
Make sure you have all the fields you require
Use filters, recalculation, duplicate checks, statistics on key fields, sorting on key fields
Perform recalculations: opening balance + movement = closing balance
-High-level initial data assessment
Compare data received to data request submitted
Compare table by table; Compare field by field
High level inspection of field contents and data types
High level check of coverage, e.g. period, locations
If multiple files are received are they in the same format, will they be easy to combine and consolidate?
-Inspecting the layout of the data
Delete unnecessary columns / Delete unnecessary rows
Resize columns / Resize rows
Erase unneeded cell contents
Format numeric / date / time values
Copying worksheet data
Moving worksheet data
Replacing data in fields
Paste special

22
Q

Perform the analysis

A

Consider the relevance, quality, completeness and reliability of the data obtained
Apply basic data analysis techniques suitable to meet the objective
Review and communicate results of analysis

23
Q

Data extraction, transformation and loading (ETL)

A

A process of taking data from an existing database, convert it into a different form and place it into a new database.

Extraction:
data analysed then read from a specified source and what is required is extracted

Transformation:
data is converted into a set form so that it can be placed into another database

Loading:
transformed data is written into target database where it is held in a systematic and logical way

24
Q

Activities of finance professionals

A

Assembling information (Plan the analysis, collect & enhance the data)
collating, cleaning and connecting data into assembled information (e.g. financial and management accounts and returns)

Analysis for insights (perform the analysis)
Analysing financial and non-financial information to draw out patterns and provide relevant insights

Advising to influence (review & communicate results of analysis)
Communicating the above insights to users and contributing to an objective, responsible perspective to influence their decision making

Applying for impact
Supporting and guiding actions to help organisations achieve the desired outcomes

25
Q

How can data and information improve sales and marketing

A

Sources of customer data
Visitor’s data (such as cookies) from the organisations websites
Online promotions, adverts, and mail responses
Relationship Management software
Social network (tablet and phone apps) apps and games
Online trends
Online customer feedback posted online

Identifying patterns and trends that can be used to improve an organisations understanding of its customers

Sources of operational data
Electronic data interchange systems
Logistics (and reverse logistics) systems
Inventory management systems
Material requirement planning, manufacturing resource planning, enterprise resource planning systems
Quality control systems

Sources internal to the organisation (therefore data in form that easy to collect and analyse to help detect inefficient processes

26
Q

Analysis techniques

A

Filter/display criteria
Expressions/equations: verify key values or test logical relationships
Gaps: identify missing items in a sequence or series
Statistical analysis: provides a quick overview of data before analysis begins (min, max, range, mean, mode)
Duplicates: highlight duplicate values in key fields (should not have duplicates)
Sort/index: arrange in ascending/descending order on a key field
Summarization: count the number of records falling into each unique category
Stratification: count the number of records in a specified number range
Pivot tables: easier to view anomalies
Aging: comparison of date fields
Joining/relating: combining data from different data files
Trend analysis: compares trends over time or any other dimension
Benford’s Law: compares the frequency of the occurrence of digits in the data to the theoretical frequency distribution

27
Q

Excel analysis techniques

A

Tables (Kind of database – Rows and columns / Fields and records)
Tools included in a table
Building and maintaining a table (Converting ranges to tables / external sources such as a database )
Analysing table information (Simple statistics)
Quick statistical measures (Avearage; Count; Numerical count; Minimum; Maximum; Sum)
Sorting of records
Filtering table records
Applying a predefined AutoFilter
Applying Multiple Filters

28
Q

Excel analysis techniques

A

Analysing data with conditional formatting (In cell visualisations)
Six rules that you can use:
>
<
||
= (Value)
Text that contain
A Date occurring (Yesterday, Last Week or Next Month)
Duplicate Values
Top or bottom values in a range
Data bars/ Colour scales / Icon sets
Based on a formula
Subtotals
Consolidating from multiple workbooks

29
Q
A