1EXHIBIT 1-1 Building Daily Productivity2 Chapter 3EXHIBIT 3-1 Relevant Guidance and Frameworks and the Data Analytics Governanc...
3 Chapter 4EXHIBIT 4-1 Data Analytics Governance Checklist
4 Chapter 5EXHIBIT 5-1 Risk and Value Considerations as Relates to Analytics and Automa...EXHIBIT 5-2 Digital Transformation Alignment with Finance Function GoalsEXHIBIT 5-3 Alignment of Digital Transformation Tooling with Stated Functiona...EXHIBIT 5-4 Impact Severity Category DescriptionsEXHIBIT 5-5 Risk Likelihood ScaleEXHIBIT 5-6 Risk Vulnerability ScaleEXHIBIT 5-7 Speed of Onset ScaleEXHIBIT 5-8 Portfolio View of RiskEXHIBIT 5-9 Risk Assessment and PrioritizationEXHIBIT 5-10 Total Risk by CategoryEXHIBIT 5-11 Consumer and Dependencies Analysis by Risk CategoryEXHIBIT 5-12 Analytics and Automation Build Risk Scoring Methodology MetricsEXHIBIT 5-13 Risk Scoring Categories ExampleEXHIBIT 5-14 Illustrative Risk DashboardEXHIBIT 5-15 Example of Individual Contribution of Builds to the Seven RisksEXHIBIT 5-16 Data Analytics Risk Governance Action Checklist
5 Chapter 6EXHIBIT 6-1 The S&P 500 Five Years of Balance Sheet and Income Statement Dat...EXHIBIT 6-2 Data Import Options in Alteryx Include Various Data Storage Opti...EXHIBIT 6-3 The Input Tool and the Data Input Preview ScreenEXHIBIT 6-4 Data Cleansing Tool and the Data Cleansing Tool Option ScreenEXHIBIT 6-5 Data Joining Tool is Used to Blend Data from Different SourcesEXHIBIT 6-6 Formula Tool Used to Enrich the Data File by Computing and Addin...EXHIBIT 6-7 The Summarize Tool is a Data Transformation ToolEXHIBIT 6-8 The Filter Tool is a Data Transformation Tool Used to Enhance Da...EXHIBIT 6-9 The Sort Tool is a Data Transformation Tool Used to Enhance Data...EXHIBIT 6-10 The Sample Tool is a Data Transformation Tool Used to Enhance D...EXHIBIT 6-11 The Interactive Chart is Part of the Reporting Set of Functions...EXHIBIT 6-12 The Browse Tool Allows for Viewing the Chart Created Through th...EXHIBIT 6-13 Summarize Tool Utilized to Group Data for Whole Market Trend An...EXHIBIT 6-14 Data Transformation Using the Summarize Tool to Transform the O...EXHIBIT 6-15 S&P 500 Total Earnings Five-Year TrendEXHIBIT 6-16 S&P 500 Total Sales Five-Year TrendEXHIBIT 6-17 S&P 500 Total Assets Five-Year TrendEXHIBIT 6-18 Grouping the Data by Company Industry to Include Industry Profi...EXHIBIT 6-19 Resulting Data File from the Summarize Tool and Grouping by Com...EXHIBIT 6-20 The Sort Processing Step Transforming the Data in the Last Tran...EXHIBIT 6-21 The Resulting Transformed Data After the Sort Processing Step R...EXHIBIT 6-22 Industry Comparison Based on Companies’ Total Earnings for the ...EXHIBIT 6-23 Comparative Industry Analysis by Profit Margin of Industries in...EXHIBIT 6-24 Comparative Industry Analysis by Return on Equity of Industries...EXHIBIT 6-25 Summarize Tool Functionality in Transforming Data for Analysis ...EXHIBIT 6-26 Browsing the Transformed Data to Examine the Resulting Transfor...EXHIBIT 6-27 Filter Tool Function is Used to Further Transform the DataEXHIBIT 6-28 Five-Year Earnings Trend for the Information Technology in Indu...EXHIBIT 6-29 Five-Year Sales Trend for the Information Technology in Industr...EXHIBIT 6-30 Summarize Tool Used to Transform Data to Prepare the Data for A...EXHIBIT 6-31 Browse Tool Functionality Displays the Transformed Data File to...EXHIBIT 6-32 The Filter Tool is Used to Transform the Data into Include Only...EXHIBIT 6-33 Information Technology Top 8 Performers to by Total Earnings fo...EXHIBIT 6-34 Information Technology Top 8 Performers to by Total Sales for t...EXHIBIT 6-35 Apple's Five-Year Earnings Trend for the Period 2014–2018EXHIBIT 6-36 Apple's Five-Year Sales Trend for the Period 2014–2018
6 Chapter 7EXHIBIT 7-1 Income Statement Impact of T&E Core System ImplementationEXHIBIT 7-2 Company SWOT AnalysisEXHIBIT 7-3 Porter's Five Forces ModelEXHIBIT 7-4 Porter’s Value ChainEXHIBIT 7-5 Time and Expenses Department SIPOCEXHIBIT 7-6 Expenses Submission Review/Approval/Reimbursement SIPOCEXHIBIT 7-7 Time Sheet Submission Review/Approval & Payroll Cycle SIPOCEXHIBIT 7-8 Expenses Submission/Reimbursement Swim Lanes Process MapEXHIBIT 7-9 Time Sheet Submission/Payroll Swim Lanes Process MapEXHIBIT 7-10 Annotated Process Maps – Divergence of “Like” ProcessesEXHIBIT 7-11 Expense Process SIPOC with Elapsed Time and OpportunitiesEXHIBIT 7-12 Time Sheet/Payroll SIPOC with Elapsed Time and Opportunities
7 Chapter 8EXHIBIT 8-1 Opportunity Inventory MatrixEXHIBIT 8-2 Matching Tools to Use CasesEXHIBIT 8-3 Building Benefits CasesEXHIBIT 8-4 Benefits Cases with Cycle Metrics MultiplierEXHIBIT 8-5 Sizing Build EffortsEXHIBIT 8-6 The Automation Heatmap
Guide
1 Cover
2 Table of Contents
Pages
1 iii
2 iv
3 v
4 ix
5 x
6 xi
7 xiii
8 xv
9 xvi
10 1
11 2
12 3
13 4
14 5
15 6
16 7
17 8
18 9
19 10
20 11
21 12
22 13
23
