Data Analyst Career Pack
Build evidence you can explain.
Resume templates and examples, 18 SQL exercises, two reproducible portfolio projects, and a timed interview rubric.
Only need the resume files? Buy the resume component individually. It is already included in this pack.
Read two pages from the included guide (PDF)
What you can do with it
- Blank resume plus three fictional examples for different career stages
- 18 solved SQLite exercises with expected outputs
- Completed revenue-quality and operational-SLA portfolio projects
- Application tracking, skills planning and a 45-minute mock interview
Exactly what is included
25 CSV · 5 DOCX · 1 JSON · 5 MD · 1 PDF · 3 PY · 40 SQL · 6 TXT · 2 XLSX
See every included filename (88 files)
CHANGELOG.txtCONTENTS.txtCareer-Planning-Workbook-Blank.xlsxCareer-Planning-Workbook.xlsxData-Analyst-Interview-Workbook.docxData-Analyst-Resume-Template.docxKNOWN-LIMITATIONS.txtLICENSE.txtREADME.txtResume-Example-Career-Changer.docxResume-Example-Entry-Level.docxResume-Example-Experienced.docxResume-Targeting-and-Mock-Interview.mdStart-Here-Career-and-Portfolio-Guide.pdfportfolio/operational-sla/Interview-and-Presentation.mdportfolio/operational-sla/README.mdportfolio/operational-sla/case-events.csvportfolio/operational-sla/expected-cases.csvportfolio/operational-sla/results/summary.jsonportfolio/operational-sla/run-analysis.pyportfolio/operational-sla/sla-analysis.sqlportfolio/revenue-quality/README.mdportfolio/revenue-quality/data/Customers.csvportfolio/revenue-quality/data/Products.csvportfolio/revenue-quality/data/Sales.csvportfolio/revenue-quality/expected-monthly.csvportfolio/revenue-quality/monthly-revenue.sqlportfolio/revenue-quality/results/monthly-report.csvportfolio/revenue-quality/run-analysis.pysql-lab/01-Create-Practice-Database.sqlsql-lab/README.txtsql-lab/advanced/00-setup.sqlsql-lab/advanced/11-sparse-months-expected.csvsql-lab/advanced/11-sparse-months-solution.sqlsql-lab/advanced/11-sparse-months.sqlsql-lab/advanced/12-cohort-retention-expected.csvsql-lab/advanced/12-cohort-retention-solution.sqlsql-lab/advanced/12-cohort-retention.sqlsql-lab/advanced/13-multiple-facts-expected.csvsql-lab/advanced/13-multiple-facts-solution.sqlsql-lab/advanced/13-multiple-facts.sqlsql-lab/advanced/14-ordered-funnel-expected.csvsql-lab/advanced/14-ordered-funnel-solution.sqlsql-lab/advanced/14-ordered-funnel.sqlsql-lab/advanced/15-quality-triage-expected.csvsql-lab/advanced/15-quality-triage-solution.sqlsql-lab/advanced/15-quality-triage.sqlsql-lab/advanced/16-repeat-definition-expected.csvsql-lab/advanced/16-repeat-definition-solution.sqlsql-lab/advanced/16-repeat-definition.sqlsql-lab/advanced/17-null-antijoin-expected.csvsql-lab/advanced/17-null-antijoin-solution.sqlsql-lab/advanced/17-null-antijoin.sqlsql-lab/advanced/18-calendar-window-expected.csvsql-lab/advanced/18-calendar-window-solution.sqlsql-lab/advanced/18-calendar-window.sqlsql-lab/advanced/README.mdsql-lab/advanced/verify.pysql-lab/exercises/01-Monthly-revenue.sqlsql-lab/exercises/02-Customers-without-completed-orders.sqlsql-lab/exercises/03-Top-products.sqlsql-lab/exercises/04-Weighted-gross-margin.sqlsql-lab/exercises/05-Latest-event.sqlsql-lab/exercises/06-Running-revenue.sqlsql-lab/exercises/07-Month-over-month-growth.sqlsql-lab/exercises/08-Duplicate-staging-keys.sqlsql-lab/exercises/09-Missing-and-unmatched-keys.sqlsql-lab/exercises/10-Repeat-customers-by-year.sqlsql-lab/expected/01-Monthly-revenue.csvsql-lab/expected/02-Customers-without-completed-orders.csvsql-lab/expected/03-Top-products.csvsql-lab/expected/04-Weighted-gross-margin.csvsql-lab/expected/05-Latest-event.csvsql-lab/expected/06-Running-revenue.csvsql-lab/expected/07-Month-over-month-growth.csvsql-lab/expected/08-Duplicate-staging-keys.csvsql-lab/expected/09-Missing-and-unmatched-keys.csvsql-lab/expected/10-Repeat-customers-by-year.csvsql-lab/solutions/01-Monthly-revenue.sqlsql-lab/solutions/02-Customers-without-completed-orders.sqlsql-lab/solutions/03-Top-products.sqlsql-lab/solutions/04-Weighted-gross-margin.sqlsql-lab/solutions/05-Latest-event.sqlsql-lab/solutions/06-Running-revenue.sqlsql-lab/solutions/07-Month-over-month-growth.sqlsql-lab/solutions/08-Duplicate-staging-keys.sqlsql-lab/solutions/09-Missing-and-unmatched-keys.sqlsql-lab/solutions/10-Repeat-customers-by-year.sql
Compatibility and limits
XLSX workbooks were recalculated and scenario-tested during authoring; native Microsoft Excel validation remains pending. Formula cells are colored, not password-protected. DOCX files are editable; pagination can vary. Python examples require Python 3.10+; SQL examples were tested in SQLite. No software license is included.
Examples are fictional. Adapt the definitions and validate your own data. Prepared workbook capacities and extension instructions are stated in each guide.