# Microsoft Copilot — raw output, 2026-09-13 22:15 (+07), free, "Auto" mode, **temporary chat**, one message, no follow-ups

Interface Russian; answer in English. Captured from the page text; URLs appear inline in the answer. Chat URL kept open for review.

---

You have a better starting position than many career changers. Your 8 years as a bookkeeper gives you three advantages that junior analysts often lack: strong spreadsheet skills; experience working with business data and financial reports; understanding of how companies actually operate. The biggest gap is not technical knowledge. It's proving that you can analyze data and communicate insights with a portfolio.

**Honest assessment of your odds** — Assuming 8 hours/week for 6 months (about 200 hours total), you complete the plan below, you build 2-3 public projects, you're willing to apply for "Junior Data Analyst", "BI Analyst", "Reporting Analyst", "Business Analyst (Junior)", and internal data-focused roles. My estimate: 30-40% chance of landing an external junior data analyst role within 12 months. 50-70% chance if you can move internally within your company or into a finance/reporting analyst role first. 70%+ chance of getting interviews if you combine bookkeeping experience with Power BI and SQL projects. The biggest mistake I see career changers make is thinking certificates get jobs. They do not. Projects plus relevant work experience get interviews.

**What to learn (and what to skip)** — Must learn: SQL, Power BI, data visualization, basic statistics, portfolio projects, how to tell a business story with data. Skip for now: machine learning, data science, Python beyond very basic exposure, Tableau, expensive bootcamps (€3k-10k), master's degrees. Focus beats breadth.

**Budget**

| Item | Cost |
|---|---|
| Google Data Analytics Certificate | ~€180-€270 depending on completion speed |
| Microsoft PL-300 Exam | ~€165 equivalent exam fee |
| Optional DataCamp month(s) | €25-50 |
| Total | €370-485 |

**6-Month Roadmap**

Month 1: SQL Foundations — Resource (free): SQLBolt, https://sqlbolt.com. Weekly plan: SELECT/WHERE/ORDER BY; GROUP BY; JOINs; subqueries. Deliverable: GitHub account, upload solved SQL exercises.

Month 2: Structured Analytics Training — Google Data Analytics Professional Certificate, https://www.coursera.org/professional-certificates/google-data-analytics. Coursera describes it as a beginner-level program lasting about 6 months at 10 hours/week. Cost: Coursera subscription is approximately $49/month; learners typically spend around $147-$294 depending on completion speed. Focus on data cleaning, analysis process, SQL modules; skim R.

Month 3: Power BI — Microsoft Learn, https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/ — free official training: preparing data, modeling, visualizations, administration. Weekly project: P&L dashboard, cash flow dashboard, budget vs actual dashboard.

Month 4: Portfolio Project #1 — "Small Business Financial Performance Dashboard" (Excel, SQL, Power BI): revenue trends, expenses, profit margins, monthly performance. Publish on GitHub and LinkedIn.

Month 5: Portfolio Project #2 + Certification Prep — Portuguese public data analysis (INE Portugal, Lisbon open data portals): housing, tourism, inflation, employment. Prepare for Microsoft PL-300; exam fee commonly listed at $165 USD (regional pricing may vary).

Month 6: Job Search Preparation — Resume positioning: "Finance professional with 8 years of experience analyzing business data, advanced Excel skills, SQL, and Power BI reporting." LinkedIn headline: "Finance & Reporting Professional | SQL | Power BI | Excel | Aspiring Data Analyst". Apply to Junior Data Analyst, Reporting Analyst, BI Analyst, Commercial Analyst, Finance Analyst, Operations Analyst.

**Salary expectations in Lisbon** — Recent Glassdoor data for Lisbon shows average Data Analyst compensation around €32,000 per year. For your situation: Junior Data Analyst €24k-32k; Reporting Analyst €25k-35k; Finance/Data Analyst Hybrid €28k-38k.

**If I were you** — SQLBolt first; Google Data Analytics Certificate; Power BI every week; PL-300 certification; two finance-focused portfolio projects. With your bookkeeping background, I would not try to compete with computer science graduates.

---

## Links (URLs in the answer)

https://sqlbolt.com · https://www.coursera.org/professional-certificates/google-data-analytics · https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/ · Glassdoor cited as a chip, no URL exposed.