Dave Fowler - The Informed Company

17 Chapter 15Figure 15.1 Figure 15.2 Data being backfilled.Figure 15.3 A table with a deprecated metric and two strategies for renaming...Figure 15.4 Figure 15.5 Figure 15.6 Screenshot of a Chartio Jira project board.Figure 15.7 Figure 15.8 Any modeling code should be peer reviewed before it is incorpora...

18 Chapter 16Figure 16.1

19 Chapter 17Figure 17.1 An outlier identified in a sales‐per‐day line graph.Figure 17.2 A date marked representing when a marketing campaign launched.Figure 17.3 A point in time marked when a field name was updated.Figure 17.4 The process of adding new columns to a data mart.

20 Chapter 21Figure 21.1 Table survey in a spreadsheet.Figure 21.2 Custom query for internal usage within a visual SQL UI.Figure 21.3 Data Grip, an SQL editor.Figure 21.4 An SQL editor with column insert feature selected.Figure 21.5 An SQL editor with columns inserted.

21 Part 3Figure P.1 Figure P.2 Figure P.3

22 Part 4Figure P.1 Data marts are subsections of a data warehouse schema.Figure P.2 An entire data warehouse schema.Figure P.3 A data warehouse schema sectioned off for each department's ...Figure P.4 Data warehouse inventory by department needs.

1 Cover Page

2 Title Page The Informed Company How to Build Modern Agile Data Stacks that Drive Winning Insights Dave FowlerMatt David

3 Copyright

4 Dedication

5 Table of Contents

6 About This Book

7 Foreword

8 Introduction

9 Table of Contents

10 Begin Reading

11 Acknowledgments and Contributions

12 Index

13 WILEY END USER LICENSE AGREEMENT

1 iii

2 iv

3 v

4 xiii

5 xiv

6 xv

7 xvi

8 xvii

9 xviii

10 xix

11 xxi

12 xxii

13 xxiii

14 xxv

15 xxvi

16 xxvii

17 xxviii

18 xxix

19 xxx

20 xxxi

21 xxxii

22 xxxiii

23 xxxiv

24 xxxv

25 1

26 2

27 3

28 4

29 5

30 6

31 7

32 8

33 9

34 11

35 12

36 13

37 14

38 15

39 16

40 17

41 18

42 19

43 20

44 21

45 23

46 24

47 25

48 26

49 27

50 28

51 29

52 30

53 31

54 33

55 34

56 35

57 36

58 37

59 38

60 39

61 40

62 41

63 42

64 43

65 44

66 45

67 46

68 47

69 48

70 49

71 50

72 51

73 52

74 53

75 54

76 55

77 56

78 57

79 59

80 60

81 61

82 62

83 63

84 64

85 65

86 66

87 67

88 68

89 69

90 70

91 71

92 72

93 73

94 75

95 76

96 77

97 78

98 79

99 80

100 81

101 82

102 83

103 84

104 85

105 86

106 87

107 88

108 89

109 90

110 91

111 92

112 93

113 94

114 95

115 96

116 97

117 98

118 99

119 100

120 101

121 102

122 103

123 104

124 105

125 106

126 107

127 108

128 109

129 111

130 112

131 113

132 114

133 115

134 116

135 117

136 118

137 119

138 120

139 121

140 122

141 123

142 124

143 125

144 126

145 127

146 128

147 129

148 130

149 131

150 132

151 133

152 134

153 135

154 136

155 137

156 138

157 139

158 140

159 141

160 143

161 144

162 145

163 146

164 147

165 148

166 149

167 150

168 151

169 152

170 153

171 154

172 155

173 156

174 157

175 158

176 159

177 161

178 162

179 163

180 164

181 165

182 167

183 168

184 169

185 171

186 172

187 173

188 174

189 175

190 176

191 177

192 178

193 179

194 181

195 182

196 183

197 184

198 185

199 186

200 187

201 188

202 189

203 190

204 191

205 192

206 193

207 194

208 195

209 196

210 197

211 199

212 200

213 201

214 202

215 203

216 204

217 205

218 206

219 207

220 208

221 209

222 211

223 212

224 213

225 214

226 215

227 216

228 217

229 218

230 219

231 220

232 221

Dave FowlerMatt David

Copyright © 2022 by Dave Fowler and Matt David. All rights reserved.

Published by John Wiley & Sons, Inc., Hoboken, New Jersey.

Published simultaneously in Canada.

No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per‐copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750‐8400, fax (978) 646‐8600, or on the Web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748‐6011, fax (201) 748‐6008, or online at www.wiley.com/go/permissions.

Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.

For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762‐2974, outside the United States at (317) 572‐3993, or fax (317) 572‐4002.

Wiley publishes in a variety of print and electronic formats and by print‐on‐demand. Some material included with standard print versions of this book may not be included in e‐books or in print‐on‐demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.

Library of Congress Cataloging‐in‐Publication Data

Names: Fowler, Dave (Computer scientist), author. | Matt David, author.

Title: The informed company : how to build modern agile data stacks that drive winning insights / Dave Fowler, Matt David.

Description: Hoboken, New Jersey : Wiley, [2022] | Includes index.

Identifiers: LCCN 2021028324 (print) | LCCN 2021028325 (ebook) | ISBN 9781119748007 (paperback) | ISBN 9781119748021 (adobe pdf) | ISBN 9781119748014 (epub)