E1 Fin In Digital World Flashcards
What are the three general ways that the finance function creates and preserves value
Enables, shapes, narrates
What are the five primary roles of the finance function
Planning forecasting resource allocation performance management and control financial/corporate reporting
Which of the five primary roles fall under ENABLES
Planning - which includes budgeting
forecasting
resource allocation - which includes people materials machinery money
Which of the five primary finance roles falls under SHAPES HOW
Performance management and control note that this is viewed as one thing
This includes KPIs & variance analysis
Which of the five primary finance roles falls under NARRATES HOW
Financial/corporate reporting
this is producing the accounts for purposes of shareholders and other interested parties
What are the four levels of the diamond shape of the finance organisation
4 smart finance factories
3 three digital centres of excellence
2 business partnering
1 senior financial leadership
Four is at the base of the diamond one is at the top
Which area of finance handles tax
Tax is handled by the Treasury function
Treasury is part of Level 4 & this would be accounting for tax.
Tax Planning is handled by Specialists in Level 3
What are the key roles of the Treasury function
Working capital management cash management financing foreign currency tax
What are the key things that management accounting brings
Providing information to help managers and other internal users in:
decision-making
performance measurement
planning and control activities
What are 3 of the key tools used by management accounting
Cost schedules/standard cost cards budgets
Variance Reports
In terms of why information is produced what is the key difference between management accounting and financial reporting
Management accounting is for internal use financial reporting is for external use such as shareholders creditors banks and government
What are the legal requirements for financial reporting vs management accounting
Management accounting has no legal requirement
financial reporting is required for limited companies
What are the required formats for management accounting versus financial reporting
Management accounting has no required format - just determined by what the business needs
financial reporting has required formats
What are the characteristics of useful data in management reports
Accurate Complete Cost less than benefits Understandable Relevant Adaptable Timely Easy to Use
What are the attributes of Good Data
Accurate Timely Relevant Concise Cost effective
What are the known limitations of using external data
External data may not be accurate
external data may be out of date
the company publishing the data may not be reputable
external data may not meet the exact needs of the business
it may be difficult to gather external data
What does ETL stand for in terms of data
Extraction
transformation
loading
What is data profiling
Before extracting the data, it needs to be analysed to understand
content
format
and structure
this is data profiling
What is data extraction
Harvesting data from source databases and locations
What is transformation in the ETL process
Transforming the source data into the format used for the destination database
this is done using codes and rules
What is loading in the ETL process
This is the process of the newly cleaned and prepared data being uploaded to the destination database ready for use
What is Hadoop
A company / software provider that allows processing of big data
What is data modelling
Data modelling is a systemic way of looking at all an organisations data requirements in a way that can be converted into code.
Identifies a clear way the data should be organised so it can be retrieved interrogated linked and grouped
What are the three levels of data modelling process
Conceptual
logical
physical
What is the conceptual level of data modelling
Practical of you considering the business data and the required information