Excellence WorkAT THE SUMMIT, YOU WILL BE ABLE TO
EXCELLENCE WORK
Become a Data Analyst
0/15STARS
0/15 stars lit
From a vague request to an honest answer, computing with real Census and BLS figures as you go: the five steps of every analysis, categorical and quantitative data, percent change against percentage points, mean, median, spread and standard deviation, an outlier you flag on a dot plot with 1.5 × IQR, samples and bias, a messy spreadsheet to clean, personal data and why removing names isn't enough, formulas and PivotTables, SQL with two tables to join, a bar chart that makes a 2.6% rise look like a tripling, correlation against causation with a trend line you draw, a manager who wants more than the data show, and three data careers with their pay and outlook.
3h 13m5 constellations
01Run an analysis in five steps, from the question to an honest answer
02Compute means, medians, spread, percent change and percentage points
03Catch outliers, biased samples and dirty data before they mislead
04Summarize data with formulas, PivotTables and basic SQL
05Chart honestly and claim only what the data support
Every lesson of Become a Data Analyst
15 lessons in 5 levels, about 3 hours. Level 1 is free.
Level 1Think Like an AnalystFree · 3 lessons
- From Question to AnswerKnow what data analysts do and the five steps every analysis follows.12 min
- Kinds of DataTell categorical from quantitative data, discrete from continuous, and a sample from a population.12 min
- Percent Change and Percentage PointsCompute percent change from the right base, and never confuse it with percentage points.13 min
Level 2Summarize the NumbersMembership · 3 lessons
- Mean, Median, ModeCompute the three centers and know when the median tells the truth better.12 min
- Spread: How Far ApartMeasure spread with the range, quartiles, the IQR and the idea of standard deviation.13 min
- Shapes and OutliersRead a distribution's shape and flag outliers with the 1.5 × IQR rule.13 min
Level 3Good Data InMembership · 3 lessons
- Samples and BiasPick a fair sampling method and spot the biases that wreck surveys.12 min
- Clean Before You CountFind and fix what breaks totals and averages: duplicates, blanks and stray formats.13 min
- Handle People's Data With CareKnow what counts as personal data, why removing names isn't enough, and how to keep data safe.13 min
Level 4The Analyst's ToolsMembership · 3 lessons
- Spreadsheets: Formulas and PivotsWrite formulas with the right references and summarize a table with a PivotTable.12 min
- SQL in Plain WordsRead and write the core of SQL: SELECT, WHERE, GROUP BY and JOIN.14 min
- Charts That Tell the TruthChoose the right chart, and spot the axis tricks that make small changes look huge.13 min
Level 5Tell the Truth With DataMembership · 3 lessons
- Correlation Is Not CausationRead a scatter plot, draw a trend line, and know what it takes to claim a cause.13 min
- Report What the Data SayTurn an analysis into a clear finding with its limits, and push back when asked to overclaim.14 min
- Careers in Data, and the Final TestKnow three careers built on data, their pay and outlook, and pass the path's final test.14 min
AFTER THE CORE