LibGuides: ANA330: Module 4

Module 4 Required Resources

Data Quality Fundamentals: A Practitioner’s Guide to Building Trustworthy Data Pipelines
Moses, B., Gavish, L., & Vorwerck, M. (2022). Data quality fundamentals: A practitioner’s guide to building trustworthy data pipelines. O’Reilly Media.
Read Chapter 9 Data Quality in the Real World: Conversations and Case Studies.
In Chapter 9, the authors describe take a more holistic and practical look at Data Quality.
Principles of Data Wrangling: Practical Techniques for Data Preparation
Rattenbury, T., Hellerstein, J., Heer, J., Kandel, S., & Carreras, C. (2017). Principles of data wrangling: practical techniques for data preparation (First edition.). O’Reilly.
Read Chapter 9: Data Wrangling Tools
In this chapter, the authors discuss various tools used for data cleaning and preparation. The “tools” much like a tool in a toolbox of a construction worker, are the tools of the trade in data preparation. Some tools can be used for many applications and some tools for only one or two applications. Understanding what you have available and what you need are an important understanding for an analyst.

Transform Data by Example
Microsoft Research. (2019, September 23). Transform data by example. https://www.microsoft.com/en-us/research/project/transform-data-by-example/

Grande, T. (2015, May 7). Recoding variables in Excel [Video]. YouTube. https://www.youtube.com/watch?v=Z8znLeKuvog

Emery, A. (2012, November 11). How to Recategorize Variables in Excel with the If Formula: Part 1 [Video]. YouTube. https://www.youtube.com/watch?v=Ytlu0uTHvV8

Research Masterminds. (2017, February 14). Calculate mean and standard deviation in Excel [Video]. YouTube. https://www.youtube.com/watch?v=15oJU12hZ8k

Vivo Phys -Matthews, E. (2020, March 10). Standard deviation in Excel [Video]. YouTube. https://www.youtube.com/watch?v=pVzYjkKX4-E

Top Tip Bio. (2019, September 27). Calculating Mean, Standard Deviation & Error In Excel [Video]. YouTube. https://www.youtube.com/watch?v=39JDN5BNEJ0

Enterprise DNA. (2022, May 2). How to use Chi-square Test in Excel to compare variables [Video]. YouTube. https://www.youtube.com/watch?v=dgo_j1siJCQ

Top Tip Bio. (2019, March 12). How to perform a Pearson Correlation Test in Excel [Video]. YouTube. https://www.youtube.com/watch?v=Ev86DMtLXOk