Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CIMA E1 > 6 - Using data to create & preserve value > Flashcards

6 - Using data to create & preserve value Flashcards

1
Q

Feedback =

A

where the results of a process are gathered and then used to influence future performance (i.e. exercise control) by adjusting inputs into the process.

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

Single feedback loop = (1 liner)

A

Compare actual results against expected results

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

Double feedback loop = (1 liner)

A

Also involves making changes to the actual plans or systems as a result of changes in internal/external conditions.

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

Define sensor (feedback theory)

A

A measuring or recording device

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

Define comparator (feedback theory)

A

compares actual results obtained by sensor against the plan/standard

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

Define effector (feedback theory)

A

A team or individual who acts upon the comparison by issuing new instructions relating to the input.

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

Define High level controller (feedback theory)

A

Performs a role similar to the effector, but from a more senior position in the org.

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

Big difference between single and double feedback look

A 
Single = no human intervention - automated & dependable
Double = need high level human control
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Outline single feedback loop

A

Outputs - sensor - comparator - effector - adjust - Inputs - processes - outputs

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

What extra features does double feedback loop have over single?

A
  • Higher level controller
  • standard (similar to comparator)
  • lower level controller (similar to effector)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What does ‘future data needs’ refer to?

A

Sometimes feedback or new strategies create Qs that finance cannot answer as it lacks info due to gap in data available - needs to be filled by sourcing data.

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

2 ways to source new data

A
  1. Reconfigure an existing system

2. New system

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

4 stakeholders who provide feedback to finance and have data requirements

A

Sales, operations, Marketing, Board of directors.

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

HR general data requirements from info system

A

Appraisal, productivity, training data

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

Shareholders general data requirements from info system

A

Impacts and future prospects of business e.g. Integrated reporting such as carbon footprints

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

Individual directors general data requirements from info system

A

Effective data visu and key metrics

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

employees general data requirements from info system

A

Payroll info and systems data to help suggest and test solutions to inefficiencies as users of these systems

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

Data extraction, transformation & loading (ETL) systems =

A

Take data from an existing database, convert it to a different form and place it into a new database (usually data warehouse). Combine 3 different system functions into a single system.

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

Extract ETL function

A

Data analysed to understand content, format & structure = data profiling.
Then read from specified source & what is required is extracted.

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

Transform ETL function

A

Convert extracted data using rules, look up tables or by combining data, into a set form so it can be placed into another database.

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

Load ETL function

A

Write the transformed data into the target database (data warehouse) where it is held in a systematic and logical way so it is ready for future interrogation by BI systems.

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

Where is data supplied by an ETL system drawn from?

A

A number of independent IT infrastructure systems

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

Business intelligence systems =

A

describe the technological architecture the extract, assemble, store and access data to provide reports and analysis. (ETL one part of this)

24
Q

Bottom of BI stack + explain function

A

IT infrastructure - basic hardware and networking to support info systems.

25
Q

2nd level of BI stack

A

Specialist independent IT systems for each bis function . data often saved in diff formats in diff locations = inconsistencies.

26
Q

3rd level BI stack

A

ETL - takes data from specialist systems, transforms, and loads into org-wide database. + EXTERNAL data.

27
Q

4th level BI stack

A

Systems that store the transformed data & manage it so it can be used by higher level systems: Metadata, data warehouse & warehouse mgmt. Provide storage capacity for big data.

28
Q

5th level BI stack

A

Application level - software that analyses data supplied by ETL system. Mgrs, without specialist IT or analytical expertise, can drill into and view data to find patterns. Basis for big data analytics.
OLAP: interrogate data real time
Data mining
Query & reporting: drilldown & manipulate to create customised report

29
Q

6th level BI stack

A

Customer, finance, operations, supply chain. Business analytical packages targeted at particular user groups.

30
Q

7th level BI stack

A

Company-wide BI tools and apps. Real time access, reports, dashboards. data visu = presentation/delivery layer.

31
Q

Definition of Hadoop

A

a technological solution for BI that can handle the volume, variety & velocity challenges of big data.

32
Q

How does Hadoop increase speed that tasks can be completed?

A

rather than 1 system processing from start to finish, task broken down into separate elements & each element sent to a separate server (node) for processing. This reduces processing time as different task elements can be worked on at once.

33
Q

Hadoop: the breaking down of tasks and distributing them is performed by…

A

HDFS = Hadoop Distribute File System

34
Q

Hadoop: the coordination for the separated task processing is performed by…

A

MapReduce framework

35
Q

Hadoop: what happens once the separated tasks are completed?

A

They are then reassembled

36
Q

Data modelling =

A

Analysis of an org’s data needs required to support its bis processes.

37
Q

Data manipulation =-

A

the reorganisation or transformation of data to make it easier to read or more meaningful.

38
Q

Data analysis =

A

Overall process of collecting, cleansing, manipulating and modelling data to support decision making. Additional aspect is the decision making.

39
Q

State 3 stages of data modelling

A
  1. Conceptual model
  2. Logical model
  3. Physical model
40
Q

Data modelling: what is conceptual model & how are finance involved?

A

Finance liaise with internal stakeholders to determine types of insights required & therefore record data requirements.

41
Q

Data modelling: what is logical model & how are finance involved?

A

Data requirements developed into formal docs which set out specific data structures that will be used to organise the database (data flows, sources, storage). Finance then review this to make sure it’d meet data requirements.

42
Q

Data modelling: what is physical model & how are finance involved?

A

Manage data and relationships between datasets and tables - create hardware & code software.
Finance test the physical model to ensure it can create the type of insights required.

43
Q

4 pros of data modelling

A
  1. Foundation for handling data & facilitates effective use of data
  2. Helps comply with data regs by enforcing bis rules at early stage
  3. Enhanced quality of data through well-planned approach
  4. Consistent naming conventions & values through systematic and reliable database
44
Q

What is a data manipulation language (DML)?

A

Something used to automate the process of data manipulation and handle complex databases. DMLs search the parameters of data being held and give instructions to ensure it’s help in consistent and structured manner.

45
Q

How are finance involved in data manipulation?

A

Manipulate data using accounting fields, dates and values to make it easier for users to understand trends e.g. by putting into spreadsheet.

46
Q

Exploratory data analysis =

A

finding new relationships or features in an existing dataset.

47
Q

Confirmatory data analysis =

A

Confirming or disproving a hypothesis

48
Q

Predictive data analysis =

A

Making forecasts based on techniques such as statistical modelling.

49
Q

Text data analysis =

A

Extracting and classifying data from textual sources e.g. grouping products into named categories. Minor part of data analysis.

50
Q

How does finance help manage the volume issue with big data?

A

Assist mgmt in determining infra & storage needs
Monitor volume & predict future storage
Internal audit ensure don’t run out of storage

51
Q

1 solution to volume issue with big data

A

Cloud storage - can be scaled up or down as needed.

52
Q

How does finance help manage the velocity issue with big data?

A

Provide benchmarking insights on how good networks and comms systems are to IT - data needs to be streamed as fast as bis requires.

53
Q

How does finance help manage the variety issue with big data?

A

Ensure data connection and visu tools can make sense of diff forms of data to meet org’s insight needs.

54
Q

How does finance help manage the veracity issue with big data?

A

finance cleanse data before it can be trusted as accurate.

55
Q

3 Qs that are asked to ensure effective data visualisations

A
  1. Who is audience - what detail needed & their technical ability
  2. How do they want the data - what form?
  3. what outcome do they want - what decisions try to make?
56
Q

4 reasons why finance performs the creation and maintenance of data visualisation roles (even though many diff business functions could do this)

A
  1. Finance responsible for insights = should control visus
  2. Experts = can spot & amend errors themselves = faster
  3. Improve comms by finance - being in charge of visus enables finance to have deeper understanding of data behind visus and so can provide richer and higher level analysis
  4. Finance knows org-wide strategy - not just 1 function
57
Q

___ is a key aspect of finance creating data visualisations

A

business partnering

CIMA E1 (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions