10 Reasons This Is the Data Analyst Career Plan to Follow as AI Changes the Work
A 29-page field guide to the skills, certifications and projects that matter now, built on three public analyses of roughly 68,700 job postings. Add the Toolkit for the resume templates, interview bank and portfolio projects to act on it.
The market figures come from published analyses, cited on the pages of the guide:
Huntr
InterviewStack
365 Data Science
UCI Online Retail II
Stack Overflow Developer Survey
NYC TLC trip data
01The evidence
It shows where the studies disagree, instead of picking the number that sounds best
Three public analyses count skills in job postings differently, so they give different answers. The guide puts the ranges side by side and tells you which skills sit at the top in every study.
Share of data-analyst postings that mention each skill
SQL53–72%
Python31–53%
Excel24–44%
Power BI27–40%
Tableau26–40%
R20–25%
ML7–11%
Each bar spans the lowest to the highest figure across the three studies. Axis runs 0–100%. Source and limits: pages 6 and 7 of the guide.
02The pay signal
It shows which skills sit with higher pay, and why you should not over-read that
Skills like A/B testing and dbt appear with higher median salaries than SQL or Excel alone. The guide explains why that is a correlation, not a promise, and what to do with it.
Median US salary of postings that list the skill
A/B testing$115k
dbt$115k
Looker$110k
Snowflake$104k
pandas$101k
SQL~$89k
Excel~$82k
One source (InterviewStack, US, 479 postings, overall median $87.2k). Bars start at $0. Single-source, so treat as a signal, not a finding.
03AI, specifically
It names the five technologies reshaping the job and where the analyst fits
Instead of general advice to "learn AI", the guide describes the AI-augmented analyst: the work that gets faster, the judgment and domain context that does not, and the skills to build around it. You do not need to master all five. You need to know which one changes your job.
The five technologies in the guide
Generative AI & LLMsCloud-native analyticsData meshLow-code / no-codeReal-time & streaming
Recommends the book to executives and managers seeking analytics strategy, organisational capability and culture guidance, rather than technical models. Praises the examples and the DELTA framework, while questioning the age of some underlying studies.
Reader review of Competing on Analytics, summarised · one of the 10 books in the guide
It gives you three tracks to choose from, so you stop trying to learn everything
Each track has its own skills pyramid, learning path and certification route, with a clear view of what to learn first and what to leave for later.
Three specialization tracks
Data Engineering-OrientedRobust pipelines and infrastructure. Analytics engineering to data engineering.
Business Intelligence SpecialistBusiness-facing dashboards. BI leadership to analytics management.
Decision Science AnalystStatistical and ML methods for business decisions. Decision scientist to data scientist.
Choose one as primary. A track you can sustain for 18 months beats the "hottest" one you abandon in three.
Praises understandable design principles and examples of good and bad practice, emphasising informative, contextual dashboards without distracting decoration.
Reader review of Information Dashboard Design, summarised · the guide's pick for the BI track
05Toolkit · resume and outreach
It rewrites eight resume bullets for you, then gives you the templates and scripts
Two Word templates (resume and cover letter), outreach and salary-negotiation scripts, and a rubric to score your own materials before anyone else reads them.
Format of a resume rewrite (illustrative example)
BeforeResponsible for weekly sales reports.
AfterRebuilt the weekly sales report as a SQL view, cutting preparation from half a day to ten minutes.
Illustration of the format only. The Toolkit has eight worked rewrites and a rubric.
06Toolkit · interview bank
It gives you 30 interview questions with answers you can run and check
Twenty SQL, six business-case and four statistics questions. The SQL ones run against a practice database in the download, so you see the answer instead of reading about it.
One of the practice queries (SQLite, included)
SELECT strftime('%Y-%m', o.order_date) AS month,
ROUND(SUM(oi.quantity * oi.unit_price * (1 - oi.discount)), 0) AS revenue
FROM orders o
JOIN order_items oi ON oi.order_id = o.order_id
WHERE o.status = 'completed'GROUP BY month ORDER BY month DESC;
-- 2025-12 → 5,268 · 2025-11 → 9,118 · 2025-10 → 10,439
Output checked against the included database. Synthetic data: 500 customers, 40 products, 1,497 orders.
07Toolkit · portfolio
It hands you four portfolio projects with datasets that have been checked
Each project comes with a verified public dataset, its licence and attribution, and a README template, so a hiring manager can see what you did in under a minute.
08Certifications, books and courses
It tells you which certifications, books and courses are worth your money
A certification roadmap with current prices and exam codes, ten books and ten learning platforms with clickable links, and the communities and newsletters to follow. Verified as of October 2026; confirm prices on the vendor's site.
Praises approachable, comprehensive data-wrangling coverage and a useful balance of technical explanation and practical examples for beginners and experienced readers.
Reader review of Python for Data Analysis, summarised · one of the 10 books in the guide
09The plan
It turns all of this into a 90-day, 6-month and 12-month plan
You finish with a sequence to follow, not a reading list.
The roadmap on page 16
90 days · 10–15 hrs/wkSkills-gap assessment, SQL and visualization, modern data stack, an end-to-end analytics build.
6 months · 8–10 hrs/wkCommit to one track, ship a specialized project, add business-domain knowledge, start publishing.
12 months · 10–15 hrs/wkExpand expertise, build visibility, and make your case for advancement.
Each horizon has its own KPIs, for example 2 certifications and 1 flagship project in the first 90 days.
10Positioning
It tells you plainly what it cannot do
No promised job, no promised salary, no video course. If that sounds like the opposite of most career products, that is deliberate.
It is
A guide plus working files
Built on cited public studies, limits stated
A plan you carry out yourself
It is not
A course with video lessons
Management advice for senior leaders
A guarantee of a job or salary
Look inside
See the actual pages before you decide
These are real pages from the files you download. Swipe to see more.
Guide, page 6What job postings ask for, with the disagreement between studies shown.Guide, page 9Three tracks. Pick one.Guide, page 16The 90-day, 6-month and 12-month roadmap.Toolkit, page 4Eight resume bullets, rewritten.Toolkit, page 12SQL questions with answers you can run.Toolkit, page 27Portfolio Project 1: retail customer retention.
Proof you can check
There are no reviews of this guide yet. Here is what you can check.
The guide has not launched, so it has no customer testimonials, and this page will not invent any. Below: figures you can verify, then what readers say about the books the guide recommends.
~68,700
job postings across three public analyses, each cited with its limits.
20 of 20
SQL practice questions have answers that run on the included database. You can run them yourself.
p = 0.20
A worked statistics example: 5.0% vs 5.4% with 10,000 users per group is not a significant difference. The bank shows why, and the sample size you would need.
0
invented testimonials, ratings or press logos on this page. Every skill figure shows its range and source.
What readers say about the books inside
The guide's reading list, as its own readers rate it
The guide points you to ten books. Here is how readers describe five of them, including the criticisms. These summarise reviews of the books. They are not reviews of this guide.
Python for Data Analysis
11 reader reviews summarised
Praises straightforward NumPy and pandas syntax, practice datasets and integration with other libraries. Criticises fragile pages and the lack of end-of-chapter exercises.
Values it as a quality reference and a way to revisit fundamentals.
Finds it useful but demanding, and reports errors and missing notebook outputs in the accompanying GitHub materials.
Storytelling with Data
4 reader reviews summarised
Praises practical before-and-after examples that explain why chart changes work, even for readers with extensive corporate experience.
A biostatistics professor praises how it bridges analytics and presentation.
Notes that interactive dashboards and software implementation are outside its scope.
Information Dashboard Design
9 reader reviews summarised
Finds it a permanent reference for both dashboard creators and users, with useful examples.
An analyst praises engaging writing, useful facts and strong examples for improving dashboards and reports.
Recommends it to newcomers but finds overlap with earlier books by Few and Tufte, and less mobile coverage than the cover suggested.
Data Science for Business
5 reader reviews summarised
Strongly recommends it for developing data-analytic thinking and applying data mining to business problems.
Values the profit curves, expected-profit calculations and cost-benefit matrices for model selection.
Stresses the book is useful but not sufficient alone, and one reader found the equations very small in the Kindle edition.
Competing on Analytics
10 reader reviews summarised
Praises guidance on organisational readiness, where to begin with analytics and what questions to ask.
Uses it in a graduate business-analytics course and praises approachable, effective chapters.
Finds the detail dense even with an MBA background, and wants more insight into analytical models.
39 reader reviews summarised across five of the ten books. The other five have no summaries here. The guide is not affiliated with these authors or publishers.
The download link is valid for 2 hours. We have also emailed the link to you — check your inbox (and spam folder) if it has not arrived yet.
Order ID:
Lost your link?
29pages in the guide, with clickable resources
39pages in the Toolkit PDF
30interview questions: 20 SQL, 6 business case, 4 statistics
4portfolio projects with verified datasets
8worked resume rewrites
6tables in the practice database, seeded for repeatable answers
Is it for you?
Who it is for, and who should skip it
Buy it if you are
An analyst with 0–5 years' experience who wants a clear plan
A career changer building a first portfolio
An analyst worried about AI and unsure what to learn
Skip it if you want
A course with video lessons
Management advice for senior leaders
A guaranteed job or salary
Compare
Assembling it yourself vs. this guide
This guide + Toolkit
Free sources, on your own
Studies side by side, ranges shown
Yes
You compile them
Resume, cover letter and README templates
Yes
You search for them
SQL questions with runnable database
Yes
Varies by site
One 90-day, 6-month and 12-month sequence
Yes
You build it
Video lessons or live coaching
No
Sometimes
Costs
$47 or $97
Free, plus your time
Questions
Before you buy
Is this a course?
No. It is a guide plus working files. You do the work; the material tells you what to do and gives you the starting files.
Will it get me a job?
No guide can promise that. It shows what employers are asking for and gives you proof-building projects and interview practice.
Is the data original research?
The market figures come from three published analyses, cited on the page, with their limits stated. The Toolkit includes a script so you can run your own.
How current is it?
Verified as of October 2026. Prices and program names change, so confirm them on the vendor's site.
What is the difference between the editions?
The Guide stands alone. The Guide + Toolkit adds the Toolkit PDF and the files you reuse: two Word templates, the README template, the practice database with 20 SQL answers and the skills-study script.
Who wrote it?
The author is anonymous. They work in cloud and data platforms and can't comment on employer hiring practices. The guide explains how it was built and what it leaves out.
What is the refund policy?
All sales are final. This is a digital download delivered immediately, so I do not offer refunds. If a file will not download or is damaged, email support and I will fix it or resend it. See the Refund Policy page for details.
Become the data analyst AI makes more valuable, not less.