◆ Data & Analytics

What a financial analyst
really does.

26 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.

26evidenced tasks
6systems it runs on
See the 26 tasks ↓Open in the atlasThe full career map →
This is what one task looks like here
Analyze investment projects
Run a viability analysis on the three proposed investments, compare pr…2 sources agree

The shape of the day

tap a movement to see its tasks

Which one is you, right now?

Pick the moment · no score, no sign-up
Which moment is you right now?
Whichever you pick, the task behind it opens below.

The work, task by task

26 tasks
Hands on the work19
Analyze investment projects+
Run a viability analysis on the three proposed investments, compare projected cash flows, IRR and payback periods under base, upside and downside scenarios, flag any that fail a 10% hurdle and summarise risks for Monday's investment committee.
jdwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Prepare financial analysis reports+
Prepare a clear financial analysis report on last quarter's operating performance: reconcile actuals to budget, explain major variances, quantify one-off items and present three action recommendations for the COO and head of operations by Monday morning.
escojdwiki3 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Gather and analyze financial information+
Gather the last 24 months of revenue, COGS and operating expenses, clean and normalise the series, compute rolling margins and KPIs, and produce a one-page dashboard with explanations for the business unit lead by Friday afternoon.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Handle all the matters in reference to the finance and investments of a company+
Prepare a consolidated finance and investment brief covering cashflow, working capital, capex, and our portfolio positions for the board meeting next Wednesday, flagging risks, proposed reallocations, and a three-year forecast tied to the growth plan.
esco
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Maintain transparent financial operations for taxation and auditing bodies+
Assemble a complete audit packet for the tax authority and external auditor by Friday containing trial balance, reconciled ledgers, tax computations, and supporting vouchers, annotate any adjustments and unresolved queries for the audit lead.
esco
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Perform securities valuation or pricing.+
Value the preferred and common shares for the $120 million deal by updating the discounted cash flow model, check quoted market prices and recent trades, reconcile with the cap table, and produce a one‑page fair value conclusion by Friday close.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Draw charts and graphs, using computer spreadsheets, to illustrate technical reports.+
Update the quarterly technical appendix with three new line charts showing revenue, EBITDA margin, and rolling ROIC from the model, format axes for the board deck, and export the images sized for slide insertion by tomorrow noon.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Prepare all materials for transactions or execution of deals.+
Compile the deal book for the Merger with all diligence schedules, the executed term sheet, financial model, valuation memos, and signed board approvals, confirm completeness with Legal, and circulate to execution team by 4pm Thursday.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Grow the practice4
Watch and assess2
Work with people1

What the work runs on

named inside the evidenced tasks
23 tasksMicrosoft Excelbuilds discounted cash flow schedules, scenario tables and formula-driven KPIs for comparing projectsOpen its task library →
6 tasksMicrosoft Outlookdrafts and sends the brief to stakeholders and schedules follow‑up meetings
5 tasksMicrosoft PowerPointformats forecast outputs into slides for the Friday presentation
4 tasksMicrosoft Power BIpublishes refreshed KPI dashboards for broader stakeholder consumption
2 tasksMicrosoft Officeassembles documents into a cohesive deal book and coordinates review across departments
1 taskIntuit QuickBooksstores transaction records and generates reconciled ledgers and trial balances needed for audit and tax submissions
Browse every evidenced software task →

The same task, four heights

this page is height one
ExecuteDo today's task, with fewer mistakesyou are here → ImproveMake it easy for the next person to acceptin the atlas → DecideWork out the right move when it is unclearin the atlas → BecomeLearn the pattern so it stops coming backin the atlas →

Can AI actually do this job?

the honest answer

It can

where it genuinely helps
  • Explain the theory behind the work
  • Draft, tidy and structure your writing
  • Rehearse a hard conversation before you have it
  • Build a study plan that fits your gaps

It cannot

where it stops, completely
  • Be in the room where a financial analyst actually works
  • Carry the responsibility when the call is wrong — that weight stays yours
  • Notice what no one wrote down: the hesitation, the thing left unsaid
  • Live with the outcome

What the work pays

two countries, two different measures

India

the occupation GROUP, not this job · PLFS via ILOSTAT 2025
  • ₹50,473 a month — the median for Managers, the group this work sits in
  • India publishes pay by broad occupation group, so this covers many jobs besides this one. It is a shape, not a salary.

Where the evidence lives

open any of it yourself
O*NETThe US Department of Labor's own record of this job13 of these tasks ESCOThe European skills and occupations register4 of these tasks Job descriptionsReal postings, in the wild11 of these tasks WikipediaHow the world describes this work9 of these tasks UK NOS FSPISM12Carry out financial and investment analysis of an individual businessnational standard UK NOS FSPISM13Carry out financial and investment analysis of a collective fundnational standard

Close to this work

12 nearby
Data & AnalyticsExperimentation Analyst26 evidenced tasks Data & AnalyticsData Governance Analyst26 evidenced tasks Data & AnalyticsR Analyst26 evidenced tasks Data & AnalyticsCrm Analyst26 evidenced tasks Data & AnalyticsWeb Analyst26 evidenced tasks Data & AnalyticsGrowth Analyst26 evidenced tasks Data & AnalyticsProduct Analyst25 evidenced tasks Data & AnalyticsPower Bi Developer25 evidenced tasks

Questions people actually ask

You usually start by checking email in Microsoft Outlook and reviewing market feeds. Morning tasks: update Excel models, pull sales and expense numbers from QuickBooks or internal systems, and refresh Power BI dashboards that track portfolio performance.

Afternoon often means meetings: present findings to stakeholders using PowerPoint, meet company management to discuss projects, and follow up on financing records. End the day running valuations or stress tests in Excel and writing the short financial analysis report you’ll share tomorrow.

Start with Microsoft Excel. You’ll build financial models, forecasts, and valuation spreadsheets there every day — think discounted cash flow (DCF) models, pivot tables, and advanced formulas.

Next, learn Power BI so you can turn those models into dashboards for stakeholders. QuickBooks is useful if the role touches company bookkeeping or tax-ready records, but it’s secondary to Excel for analysts.

Yes, AI can help draft presentations, summarize earnings, and suggest formulas, but never let it generate final valuations or trading decisions without you verifying the numbers in Excel. Treat AI like a research assistant that speeds up routine writing or data cleanup.

Keep sensitive files local: don’t paste private financial records or client data into public AI chats. Record your verification steps and keep audit-ready files for taxation and auditors.

Entry-level analysts in the U.S. often start around $55,000–$75,000 a year; with 3–5 years experience, many reach $80,000–$110,000, and senior or specialized roles can exceed $120,000. Geography, industry (investment bank vs corporate finance), and company size change the numbers.

Bonuses and carried interest (in investment firms) can add significantly. Your ability to build models in Excel, produce credible Power BI dashboards, and close deals affects pay more than formal degrees alone.

Practice building full Excel models: revenue, costs, capex, DCF valuation, and sensitivity tables. Use real company annual reports to recreate a financial model and write a short analysis report.

Learn PowerPoint to present findings and Power BI to make dashboards. Take one QuickBooks tutorial if you’ll work with company books. Finally, get comfortable meeting people — present your model to a friend or mentor to practice stakeholder conversations.

Unlike accountants, who record and report past transactions for tax and audit, financial analysts forecast future performance, build models, and recommend actions. You’ll use QuickBooks outputs but convert them into forecasts and valuations in Excel.

Compared with portfolio managers, analysts usually prepare research, valuations, and investment recommendations; portfolio managers make final buy/sell decisions and manage trading. Analysts collaborate with portfolio managers and produce the charts and reports they use.