Earn these career-relevant skills in weeks, not years.
- Identify and define a business question and evaluate relevant sources of data collection.
- Identify principles of data management.
- Define statistical properties that can describe data.
- Explain the different types of data and distinguish between qualitative and quantitative data.
- Summarize the data analysis process from collecting data to reporting findings.
- Identify, define, and critique sources of errors in data.
- Evaluate a data set to identify missing data and outliers.
- Clean and recode data to prepare it for analysis using data cleaning techniques in Excel®.
- Prepare a summary description of actions taken to clean data for analysis.
- Explain data cleaning tasks and illustrate data cleaning tasks with examples.
- Verify data consistency, manipulate heterogeneous data, and identify missing data using Microsoft® Excel®.
- Create a clear and documented report dashboard with visualizations using Microsoft® Excel®.
- Describe and compare how and when to use tables, charts, and graphs for data presentation.
- Manipulate data sets and create tables, graphs, and charts in Microsoft® Excel® for presenting cleaned data.
- Arrange data graphically using the appropriate tool for the data.
- Apply quantitative modeling and data analysis techniques to the solution of real-world business problems, communicate findings, and effectively present results using data visualization techniques.
- Employ appropriate data-cleaning modeling techniques to evaluate and analyze a business problem.
- Evaluate code of ethics for a professional organization and apply ethical standards to a data modeling business case.