National data — wages and growth are not published by state for this view.
Certificate · AL
PCAD – Certified Associate Data Analyst with Python
OpenEDG Python Institute
Median earnings
—
Cost
$195
Duration
—
Completion
—
PCAD validates junior-to-intermediate data analysis skills, from acquiring and cleaning data to exploring patterns, building statistical models, and communicating findings visually. This associate-level credential covers Python, SQL, pandas, NumPy, and foundational machine learning. There are no formal prerequisites, although PCAP and PCED knowledge is recommended. The exam contains 48 questions in 60 minutes with a 75% passing score. Exam PCAD-31-0x.
Gather, aggregate, and store data from surveys, databases, APIs, and files while addressing legal and ethical concernsClean and standardize datasets by resolving errors, imputing missing values, scaling, and encoding featuresValidate data with type, range, and cross-field checks to maintain data integrityImport, export, and extract data from CSV, JSON, XML, databases, APIs, and web pages using requests and BeautifulSoupPrepare datasets by reshaping, managing outliers, and splitting data into training and test setsWrite well-structured Python using core data structures, functions, PEP 8 style, and exception handlingManage modules and packages with imports and pipModel data records with classes, inheritance, composition, and polymorphismWrite SQL queries with joins, grouping, and CRUD operations and run parameterized queries securely from PythonApply descriptive statistics, correlation, bootstrapping, and linear and logistic regression to analyze dataClean, merge, reshape, index, and summarize data with pandas DataFrames and NumPy arraysEvaluate supervised learning models using test datasets and the bias-variance tradeoffBuild and refine visualizations with Matplotlib and Seaborn and select appropriate chart typesPresent data findings to different audiences through clear narratives and evidence-based summaries