Data Analyst Certification Notes (DA101, DA201)

Data Analyst Certification Notes (DA101, DA201)

Data Analyst Certification (DA101)

  • 1.1 Perform data extraction, joining and aggregation tasks

    • Aggregate numeric, categorical variables and dates by groups using PostgreSQL.
    • Interpret a database schema and combine multiple tables by rows or columns using PostgreSQL.
    • Extract data based on different conditions using PostgreSQL.
    • Use subqueries to reference a second table within a query in PostgreSQL.
  • 1.2 Perform cleaning tasks to prepare data for analysis

    • Match strings in a dataset with specific patterns using PostgreSQL.
    • Convert values between data types in PostgreSQL.
    • Clean categorical and text data by manipulating strings in PostgreSQL.
    • Clean date and time data in PostgreSQL.
  • 1.3 Assess data quality and perform validation tasks

    • Identify and replace missing values using PostgreSQL.
    • Perform different types of data validation tasks (e.g. consistency, constraints, range validation, uniqueness) using PostgreSQL.
    • Identify and validate data types in a data set using PostgreSQL.
  • 2.1 Calculate metrics to effectively report characteristics of data and relationships between features

    • Measures of center: extmuextmu (mean), ildexilde{x} (median), extModeext{Mode}.
    • Measures of spread: range, extSDext{SD}, extVarext{Var} or extVarianceext{Variance} extVar=extSD2ext{Var} = ext{SD}^2.
    • Calculate skewness: extSkewnessext{Skewness}.
    • Calculate missingness: extMissingnessext{Missingness}.
    • Calculate the correlation between variables:
      ho or rr.
  • 2.2 Read and analyze data visualizations to demonstrate characteristics of data

    • Distinguish between data visualizations: bar chart, box plot, line graph, histogram.
    • Interpret the visualizations and summarize the characteristics of the data.
  • 2.3 Read and analyze data visualizations to represent the relationship between features

    • Distinguish between visualizations: scatterplot, heatmap, pivot table.
    • Interpret the visualizations and summarize the relationship between features.
  • 3.1 Describe statistical concepts that underpin hypothesis testing and experimentation

    • Define statistical distributions (e.g. extBinomial,extNormal,extPoisson,text−distribution,χ2,Fext−distribution,…ext{Binomial}, ext{Normal}, ext{Poisson}, t ext{-distribution}, \chi^2, F ext{-distribution}, \dots).
    • Explain the statistical concepts in hypothesis testing (e.g. null hypothesis H<em>0H<em>0, alternative hypothesis H</em>1H</em>1, one-tailed and two-tailed tests).
    • Explain the statistical concepts in experimental design (e.g. control group, randomization, confounding variables).
    • Explain parameter estimation and confidence intervals: CI = \hat{\theta} \
      \pm z_{\alpha/2} \, SE.

Data Analyst Certification (DA201) – R or Python

  • 1.1 Perform standard data import, joining and aggregation tasks

    • Import data from flat files into R or Python.
    • Import data from databases into R or Python.
    • Aggregate numeric, categorical variables and dates by groups using R or Python.
    • Combine multiple tables by rows or columns using R or Python.
    • Filter data based on different criteria using R or Python.
  • 1.2 Perform standard cleaning tasks to prepare data for analysis

    • Match strings in a dataset with specific patterns using R or Python.
    • Convert values between data types in R or Python.
    • Clean categorical and text data by manipulating strings in R or Python.
    • Clean date and time data in R or Python.
  • 1.3 Assess data quality and perform validation tasks

    • Identify and replace missing values using R or Python.
    • Perform different types of data validation tasks (e.g. consistency, constraints, range validation, uniqueness) using R or Python.
    • Identify and validate data types in a data set using R or Python.
  • 1.4 Collect data from non-standard formats by modifying existing code

    • Adapt provided code to import data from an API using R or Python.
    • Identify the structure of HTML and JSON data and parse them into a usable format for data processing and analysis using R or Python.
  • 2.1 Calculate metrics to effectively report characteristics of data and relationships between features

    • Calculate measures of center (e.g. mean, median, mode) for variables using R or Python.
    • Calculate measures of spread (e.g. range, standard deviation, variance) for variables using R or Python.
    • Calculate skewness for variables using R or Python.
    • Calculate missingness for variables and explain its influence on reporting characteristics of data and relationships in R or Python.
    • Calculate the correlation between variables using R or Python.
  • 2.2 Create data visualizations in R or Python to demonstrate the characteristics of data

    • Create and customize bar charts using R or Python.
    • Create and customize box plots using R or Python.
    • Create and customize line graphs using R or Python.
    • Create and customize histograms graph using R or Python.
  • 2.3 Create data visualizations in R or Python to represent the relationships between features

    • Create and customize scatterplots using R or Python.
    • Create and customize heatmaps using R or Python.
    • Create and customize pivot tables using R or Python.
  • 3.1 Apply sampling methods to data

    • Distinguish between different types of random sampling techniques and apply the methods using R or Python.
    • Sample data from a statistical distribution (e.g. normal, binomial, Poisson, exponential, etc.) using R or Python.
    • Calculate a probability from a statistical distribution (e.g. normal, binomial, Poisson, exponential, etc.) using R or Python.
  • 3.2 Implement methods for performing statistical tests

    • Run statistical tests (e.g. text−test, ANOVA, χ2 testt ext{-test}, \, ANOVA, \, \chi^2\text{ test}) using R or Python.
    • Analyze the results of statistical tests from R or Python.