Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data to create and preserve value for the organisation - Coggle Diagram
Data to create and preserve value for the organisation
Stakeholders of the finance function
HR
Shareholders
Production
Employees
Sales
Directors
Data engineering, extraction and mining
Extraction, transformation and loading (ETL
are the three stages in transferring data. They bring data from various sources to a single destination
Transformation
is the transforming of data into a suitable format that will enable it to be used
Loading
data being uploaded and ready for use
Extraction
is the process of harvesting data from a source database
Data profiling
prior to extraction data needs to be analysed to understand its content and format
Datawarehouse
a storage for data that went through the
ETL
process where it'll be analysed by the
business intelligence
function
Business intelligence
is the technology driven process of analysing business data to generate insight
Data visualisation
is used by the
Business Intelligence
to present findings to the wider business
A
data model
considers the data of an organisation in a systematic way that will allow it be stored and retrieved in an efficient and effective way
Advantages of a consistent approach to data are
enforces
business rules
by being
consistent
the data becomes reliable
forms a
foundation
for handling data
Quality
of data is enhanced
three levels of data modelling process
Conceptual
Logical
Physical
Data manipulation
is the process of making data readable
A
data model
outlines the parameters at which data is held and a
data manipulation language
or
DML
is then used to search and interrogate the data
Data strategy
is a coherent approach for organising, governing and deploying an organisation's information assets
Digital technology
must be considered at a strategic level and a central component of a business's overall business strategy
key components
velocity
variety
volume
veracity