Introduction |
|
xv | |
Assessment Test |
|
xxii | |
Chapter 1 Today's Data Analyst |
|
1 | (16) |
|
Welcome to the World of Analytics |
|
|
2 | (3) |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
4 | (1) |
|
|
5 | (1) |
|
|
6 | (4) |
|
|
7 | (1) |
|
Cleaning and Manipulation |
|
|
7 | (1) |
|
|
8 | (1) |
|
|
8 | (1) |
|
Reporting and Communication |
|
|
8 | (2) |
|
|
10 | (3) |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
11 | (1) |
|
Machine Learning, Artificial Intelligence, and Deep Learning |
|
|
11 | (2) |
|
|
13 | (1) |
|
|
13 | (2) |
|
|
15 | (2) |
Chapter 2 Understanding Data |
|
17 | (40) |
|
|
18 | (21) |
|
|
20 | (11) |
|
|
31 | (5) |
|
|
36 | (3) |
|
|
39 | (3) |
|
|
39 | (2) |
|
|
41 | (1) |
|
|
42 | (1) |
|
|
42 | (6) |
|
|
42 | (2) |
|
JavaScript Object Notation |
|
|
44 | (1) |
|
Extensible Markup Language (XML) |
|
|
45 | (2) |
|
HyperText Markup Language (HTML) |
|
|
47 | (1) |
|
|
48 | (1) |
|
|
49 | (2) |
|
|
51 | (6) |
Chapter 3 Databases and Data Acquisition |
|
57 | (48) |
|
|
58 | (13) |
|
|
59 | (3) |
|
|
62 | (6) |
|
|
68 | (3) |
|
|
71 | (10) |
|
Online Transactional Processing |
|
|
71 | (3) |
|
Online Analytical Processing |
|
|
74 | (1) |
|
|
75 | (6) |
|
Data Acquisition Concepts |
|
|
81 | (7) |
|
|
81 | (2) |
|
|
83 | (5) |
|
|
88 | (11) |
|
|
89 | (7) |
|
|
96 | (3) |
|
|
99 | (1) |
|
|
100 | (1) |
|
|
101 | (4) |
Chapter 4 Data Quality |
|
105 | (46) |
|
|
106 | (10) |
|
|
106 | (1) |
|
|
107 | (3) |
|
|
110 | (1) |
|
|
111 | (1) |
|
|
112 | (1) |
|
|
113 | (1) |
|
|
114 | (1) |
|
|
114 | (2) |
|
Data Manipulation Techniques |
|
|
116 | (16) |
|
|
116 | (1) |
|
|
117 | (1) |
|
|
118 | (1) |
|
|
119 | (2) |
|
|
121 | (1) |
|
|
121 | (1) |
|
|
122 | (2) |
|
|
124 | (2) |
|
|
126 | (1) |
|
|
127 | (1) |
|
|
128 | (2) |
|
Parsing/String Manipulation |
|
|
130 | (2) |
|
|
132 | (12) |
|
Circumstances to Check for Quality |
|
|
132 | (4) |
|
|
136 | (1) |
|
|
136 | (4) |
|
Data Quality Rules and Metrics |
|
|
140 | (2) |
|
Methods to Validate Quality |
|
|
142 | (2) |
|
|
144 | (1) |
|
|
145 | (1) |
|
|
146 | (5) |
Chapter 5 Data Analysis and Statistics |
|
151 | (50) |
|
Fundamentals of Statistics |
|
|
152 | (3) |
|
|
155 | (20) |
|
|
155 | (5) |
|
Measures of Central Tendency |
|
|
160 | (4) |
|
|
164 | (9) |
|
|
173 | (2) |
|
|
175 | (15) |
|
|
175 | (4) |
|
|
179 | (7) |
|
|
186 | (4) |
|
|
190 | (2) |
|
Determine Type of Analysis |
|
|
190 | (1) |
|
|
191 | (1) |
|
Exploratory Data Analysis |
|
|
192 | (1) |
|
|
192 | (2) |
|
|
194 | (2) |
|
|
196 | (5) |
Chapter 6 Data Analytics Tools |
|
201 | (30) |
|
|
202 | (3) |
|
|
203 | (2) |
|
|
205 | (4) |
|
|
205 | (1) |
|
|
206 | (2) |
|
Structured Query Language (SQL) |
|
|
208 | (1) |
|
|
209 | (3) |
|
|
210 | (1) |
|
|
211 | (1) |
|
|
211 | (1) |
|
|
212 | (1) |
|
|
212 | (5) |
|
|
213 | (1) |
|
|
214 | (3) |
|
|
217 | (8) |
|
|
217 | (1) |
|
|
218 | (1) |
|
|
219 | (1) |
|
|
220 | (1) |
|
|
221 | (1) |
|
|
222 | (1) |
|
|
222 | (2) |
|
|
224 | (1) |
|
|
225 | (1) |
|
|
225 | (1) |
|
|
225 | (2) |
|
|
227 | (4) |
Chapter 7 Data Visualization with Reports and Dashboards |
|
231 | (48) |
|
Understanding Business Requirements |
|
|
232 | (3) |
|
Understanding Report Design Elements |
|
|
235 | (12) |
|
|
236 | (1) |
|
|
237 | (2) |
|
|
239 | (5) |
|
|
244 | (3) |
|
Understanding Dashboard Development Methods |
|
|
247 | (5) |
|
|
247 | (1) |
|
Data Source Considerations |
|
|
248 | (1) |
|
|
249 | (1) |
|
|
250 | (1) |
|
|
250 | (2) |
|
Operational Considerations |
|
|
252 | (1) |
|
Exploring Visualization Types |
|
|
252 | (16) |
|
|
252 | (6) |
|
|
258 | (6) |
|
|
264 | (2) |
|
|
266 | (1) |
|
|
267 | (1) |
|
|
268 | (3) |
|
|
268 | (1) |
|
|
269 | (1) |
|
|
269 | (1) |
|
|
269 | (1) |
|
|
270 | (1) |
|
|
271 | (1) |
|
|
272 | (2) |
|
|
274 | (5) |
Chapter 8 Data Governance |
|
279 | (32) |
|
|
280 | (19) |
|
|
281 | (1) |
|
|
281 | (5) |
|
|
286 | (3) |
|
Storage Environment Requirements |
|
|
289 | (2) |
|
|
291 | (1) |
|
Entity Relationship Requirements |
|
|
292 | (1) |
|
Data Classification Requirements |
|
|
292 | (5) |
|
Jurisdiction Requirements |
|
|
297 | (1) |
|
Breach Reporting Requirements |
|
|
298 | (1) |
|
Understanding Master Data Management |
|
|
299 | (4) |
|
|
300 | (1) |
|
|
301 | (2) |
|
|
303 | (1) |
|
|
304 | (2) |
|
|
306 | (5) |
Appendix Answers to the Review Questions |
|
311 | (16) |
|
Chapter 2: Understanding Data |
|
|
312 | (2) |
|
Chapter 3: Databases and Data Acquisition |
|
|
314 | (1) |
|
|
315 | (2) |
|
Chapter 5: Data Analysis and Statistics |
|
|
317 | (2) |
|
Chapter 6: Data Analytics Tools |
|
|
319 | (3) |
|
Chapter 7: Data Visualization with Reports and Dashboards |
|
|
322 | (1) |
|
Chapter 8: Data Governance |
|
|
323 | (4) |
Index |
|
327 | |