Data Analytics Certification Program

1.1 Define the concept of data

1.2 Describe basic data variable types

• Boolean, numeric, string

1.3 Describe basic structures used in data analytics

• Tables, rows, columns, lists

1.4 Describe data categories

• Qualitative, quantitative, structured, unstructured, metadata, big data

2.1 Import, store, and export data

• Fundamental understanding of ETL (extract, transform and load) processes, data manipulation tools (SQL, R, Python, Microsoft Excel including aspects of Power Query), and common data storage file formats (delimited data files, XML, JSON).

2.2 Clean data

• Purpose and common practices (handling NULL, special characters, trimming spaces, inconsistent formatting, removing duplicates, imputing data, etc.); validating data

2.3 Organize data

• Purpose and common practices (sorting, filtering, slicing, transposing, appending, truncating, etc.)

2.4 Aggregate data

• Purpose and common practices (grouping, joining/merging, summarizing, pivoting, etc.)

3.1 Describe and differentiate between types of data analysis

•  Descriptive analysis, diagnostic analysis, hypothesis testing, predictive analysis, prescriptive analysis

3.2 Describe and differentiate between data aggregation and interpretation metrics

•  Searching, filtering, unique values, aggregate functions such as Sum, Max, Min, Count, Avg/Mean, Mode, Median, Std Dev

3.3 Describe and differentiate between exploratory data analysis methods

• Identify data relationships, describe data drilling concepts (granularity, etc.), describe data mining concepts (anomalies, correlation analysis, patterns, outliers, etc.)

3.4 Evaluate and explain the results of data analyses

• Calculate trends, determine expected values, interpret results of predictive models, p-values, tests, and regression analyses

3.5 Define and describe the role of artificial intelligence in data analysis

• Define artificial intelligence, machine learning, and algorithm; describe how AI is used in data analysis; describe how machine learning algorithms are used in data analysis (Note: Specific algorithms are out of scope).

4.1 Report data

•  Effectively display information in tables and charts; explain when and why to disaggregate data

4.2 Create visualizations from data

•  Identify data visualization practices that minimize the potential for misinterpretation; identify visualization types that represent the underlying data structure and analysis questions (including comparison, time/trend, part-to-whole, relationship, distribution, correlation graphs, box and whisker diagram, scatter chart, scatter plot, bar chart, Sankey diagram, histogram, pie chart, column chart, etc.)

4.3 Derive conclusions from a data visualization

• Translate a visual representation of data into words; identify differences between claims based on an analysis and its graphical representation

5.1 Describe data privacy laws and best practices

•  GDPR, FERPA, HIPAA, IRB, PCI, etc.

5.2 Describe best practices for responsible data handling

• Methods of handling PII, securing data, and protecting anonymity within small data sets; importance of anonymizing data; trade-offs when balancing interpretability and accuracy; shortcomings of making population-level generalizations with limited sample data

5.3 Given a scenario, describe types of bias that affect collection and interpretation of data

•  Confirmation bias, human cognitive bias, motivational bias, sampling bias; selecting visualizations/data representations to avoid bias