Nathan E. Myers - Self-Service Data Analytics and Governance for Managers

1 Cover

2 Title Page Self-Service Data Analytics and Governance for Managers NATHAN E. MYERS GREGORY KOGAN

3 Copyright

4 Dedication

5 Preface

6 Acknowledgments

7 About the Authors

8 Introduction

9 CHAPTER 1: Setting the StageImpact Emergence of Data Analytics Self-Service Data Analytics Employee/Analyst/Operator Perspective Managers' Perspectives Executives' Strategic Perspectives Arguments for Self-Service Data Analytics Tooling Need for Self-Service Data Analytics Governance

10 CHAPTER 2: Emerging AI and Data Analytics Tooling and Disciplines Introduction to Data Analytics Tooling Conclusion

11 CHAPTER 3: Why Governance Is Essential and the Self-Service Data Analytics Governance Gap Governance Is Essential Mature Governance Frameworks Self-Service Data Analytics Governance Gap Structures Needed to Fill the Governance Gap Conclusion Note

12 CHAPTER 4: Self-Service Data Analytics Project Governance Securing Sponsorship and Establishing the Governance Committee Extending Governance Precepts from Established Frameworks Conclusion Notes

13 CHAPTER 5: Self-Service Data AnalyticsRisk Governance Setting Risk Appetite in an Environment of Changing Performance Expectations Data Analytics Risk Governance Enhances Value Creation Data Analytics Tool Selection Drives the Level of Partnership with IT Alignment of Finance Function Goals with Digital Transformation Capabilities Data Analytics Risk Governance Assessing Risks in the Analytics and Automation Environment Developing the Portfolio View of Risk Developing Risk Responses and Controls in the Analytics and Automation Environment Conclusion Notes

14 CHAPTER 6: Self-Service Data Analytics Capabilities in Action with Alteryx Alteryx Functionality Alteryx in Action Conclusion

15 CHAPTER 7: Process Discovery: Identify Opportunities, Evaluate Feasibility, and Prioritize Business Case for Systems versus Self-Service Data Analytics Process Discovery Phases and Methodology Conclusion Notes

16 CHAPTER 8: Opportunity Capture and Heatmaps Opportunity Inventory Matrix Project Acceptance Criteria and Organizational Constraints Automation Heatmap and Prioritization Workflow Tooling Use Case Library Conclusion

17 Glossary

18 Index

19 End User License Agreement

1 Chapter 1 EXHIBIT 1-1 Building Daily Productivity

2 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

1 Cover

2 Table of Contents

3 Begin Reading

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 14

24 15

25 16

26 17

27 18

28 19

29 20

30 21

31 22

32 23

33 24

34 25

35 26

36 27

37 28

38 29

39 30

40 31

41 32

42 33

43 34

44 35

45 36

46 37

47 38

48 39

49 40

50 41

51 42

52 43

53 44

54 45