-
The Creating an Analytical Dataset course provides students with foundational knowledge to input, clean, blend, and format data in preparation for analysis. You will learn:
- The common sources and types of data
- To identify and correct common issues with data
- To format data in useful ways for analysis
- To blend data from multiple sources together
Throughout this course you’ll also learn the techniques to apply your knowledge in a data analytics program called Alteryx. At the end of the course, you’ll complete a project based on the principles in the course..
This course is part of the Business Analyst Nanodegree.
- The common sources and types of data
Overview
Syllabus
-
- Understanding Data
- Learn to identify structured, unstructured, and semistructured data.,Get an introduction to the most common data types.,Learn about the most common sources of data.
- Data Issues
- Learn to clean dirty data.,Learn to how to adjust for missing data.,Be able to identify and correct outliers.
- Data Formatting
- Learn about the importance of data format for analysis.,Transpose, aggregate, and cross tabulate data.,Learn how to use parse data.
- Data Blending
- Learn how to merge data from multiple sources.,Learn to use common data blending techniques.,Explore fuzzy matching and spatial analysis