Use Excel tools and functions to clean and prepare data for analysis.

Use Named Ranges and Tables to automate your analysis.

Understand the different types of data in Excel and use appropriate functions to work with them.

Use logical and lookup functions to transform, link and categorize data.

Explain how the problem-solving road map applies to typical analysis scenarios. 

Discuss the use of data in the decision-making process.

Demonstrate the use of spreadsheets to complete the basic tasks of the data analyst including entering and organizing data.

Describe the key ideas associated with structured thinking.

Define and explain key concepts involved in data analytics including data, data analysis, and data ecosystems.

Conduct an analytical thinking self assessment giving specific examples of the application of analytical thinking.

Discuss the role of spreadsheets, query languages, and data visualization tools in data analytics.

Describe the role of a data analyst with specific reference to jobs.

Explain what factors to consider when making decisions about data collection.

Discuss the difference between biased and unbiased data.

Describe databases with references to their functions and components.

Describe best practices for organizing data.

Define different types of data integrity and identify risks to data integrity.

Apply basic SQL functions to clean string variables in a database.

Develop basic SQL queries for use on databases.

Describe the process of verifying data cleaning results.