Data Analyst Accelerator Training
Selected as 1 of 25 out of 700 applicants
18-week Data Analytics Bootcamp in association with the NYC Tech Talent Pipeline
Successfully completed 234 hours of data analytics coursework
Technical skills: Excel, SQL, Python, Tableau, AWS
Foundations: Data, Data, Everywhere || Course Focus
Define and explain concepts involved in data analytics including data, data analysis, and data ecosystem
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/positions
Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting
Expression entry and common Excel formulas (including logical functions, text functions, and financial functions)
Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups)
Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables)
How Business Statistics is a requirement to make correct and relevant interpretations of data
Understand, calculate and interpret various descriptive or summary measures of data
Measures of association, the covariance and correlation measures; causation versus correlation
Probability and random variables; discrete versus continuous data
Introduction to statistical distributions
Probability density function and area under the curve as a measure of probability