Quick answer. A marketing professional can move into a junior data analyst role in 12 months with a structured plan: three months foundations (SQL, spreadsheets), three months technical depth (Python, Power BI or Tableau), three months credentials and project work (Google Data Analytics Professional Certificate plus a portfolio), and three months job search. The structure matters more than the individual courses.

Why Marketing to Data Is the Right Pivot

Marketing generates enormous amounts of data — campaign metrics, funnel analytics, attribution, segmentation — and most marketing professionals already interact with it regularly. The gap between "marketer who reads dashboards" and "data analyst who builds dashboards" is narrower than the gap implies. The technical skills are learnable in a year; the domain instinct a marketer has is exactly what data teams in consumer companies are short of.

Month 1–3: Foundations

Advanced Excel / Google Sheets. VLOOKUP, INDEX/MATCH, pivot tables, Power Query. You already use spreadsheets; this phase deepens fluency.
SQL fundamentals. SELECT, JOIN, GROUP BY, window functions. SQL is the lingua franca of data work; it is also the most consistently listed requirement on junior analyst job descriptions.
Statistical reasoning. Distributions, variance, significance, A/B test interpretation. Most marketers know the vocabulary; this makes the intuition rigorous.

Month 4–6: Technical Depth

Python for data analysis. pandas, NumPy, matplotlib. The crucial step from spreadsheet thinker to programmatic analyst.
Power BI or Tableau. Pick one based on the job market you are targeting — Power BI dominates in UK enterprise, Tableau in US consumer.
One cloud platform at analyst depth. BigQuery or Snowflake fundamentals; you do not need to be an engineer, but you do need to run queries against a modern warehouse.

Month 7–9: Credentials and Portfolio

Google Professional Data Analytics Certificate. Six months of official content, 4–10 hours per week; with the first six months of preparation, you can compress this to 3 months.
Portfolio project one: marketing analytics case study on real-looking data — funnel analysis, campaign attribution, retention cohort. Deploy as a Power BI or Tableau Public dashboard linked from your CV.
Portfolio project two: a full SQL + Python analysis of a public dataset (UK NHS, Our World in Data, Kaggle). Write up the findings in a short blog post or LinkedIn article.

Month 10–12: Job Search

CV and LinkedIn rewrite emphasising quantitative projects, credentials, and bridging the marketing-analyst narrative.
Apply to 30+ junior analyst roles. Use GeraJobs plus LinkedIn; filter for "junior", "associate", or "analyst" roles open to career changers.
Practice SQL and case interviews. Most junior analyst interviews test SQL live and a structured data case; the practice transforms offer rates.
Accept a role that is slightly below your current compensation. Most career changers take a short-term dip; rebuild within 18–24 months at a higher base than the marketing peak.

Budget

Foundations courses and Python/Power BI: roughly 200–500 GBP total via GeraLearn or subscription.
Google Data Analytics Professional Certificate: 39 USD/month on Coursera or bundled in Gera Prime.
Time: 8–12 hours per week for 12 months, typically evenings and one weekend session.
Total cash cost: under 1,000 GBP for most learners.

Where It Goes Wrong

Career changers fail most often by:

Jumping between courses without finishing anything.
Hiding the career change on their CV rather than leading with it.
Not building the portfolio project — the single most important artefact for a junior-analyst interview.
Applying only to roles they would get if their marketing CV counted for more than it does.
Giving up at month 10 because nothing has landed yet. Junior analyst job searches take 2–4 months; that is normal.

Life After the Role

Most marketing-to-data pivots land at a first role 10–20% below their previous salary, and reach a higher salary than their marketing peak within 24 months. Longer-term, the data career path leads to senior analyst, analytics engineer, data scientist, or head of analytics — with compensation that substantially outruns the equivalent marketing path.

Supporting Gera Systems for the Pivot

GeraJobs lists junior analyst roles globally. GeraHome can handle the "take one weekend a month off housework to study" backstop. Gera Prime bundles learning subscription with wider benefits.

Next Step

Tonight: download a free SQL course from the GeraLearn catalogue and spend one focused hour. Block four study hours in the calendar for this week. Start.