◆ Statistics

What a forecasting 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
8systems it runs on
See the 26 tasks ↓Open in the atlasThe full career map →
This is what one task looks like here
Prepare financial analysis reports
Prepare the monthly financial analysis report for Revenue and COGS by …3 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 me right now?
Whichever you pick, the task behind it opens below.

The work, task by task

26 tasks
Hands on the work19
Prepare financial analysis reports+
Prepare the monthly financial analysis report for Revenue and COGS by product line, include variance to budget, three key drivers, and an executive two-slide summary for Monday morning so CFO can decide reallocation before the board pack is final.
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 quarterly financials from sales, operations, and payroll, reconcile to the ledger, produce cleaned input tables and a summary dashboard of margins and cash burn for Friday’s forecast meeting with FP&A and the head of operations.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Analyze investment projects+
Analyze the proposed warehouse expansion project: build a discounted cash flow with capex phasing, operating uplift, tax and depreciation effects, then produce a risk-weighted IRR and recommendation for the capital committee next Wednesday.
jdwiki2 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 financial plan covering cash flow forecasts, capex needs, revenue scenarios, and investment allocations for the board meeting on Monday, stress-testing three downside cases and flagging funding gaps above $200k.
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 transparent audit pack with reconciled ledgers, tax schedules, supporting invoices, and a one-page variance narrative for the external auditors and tax officer by next Friday, ensuring all entries match the statutory accounts.
esco
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Advise clients or organizations on financial decisions+
Advise the CFO and head of strategy on whether to reallocate the next quarter's working capital into the new product line, showing projected cash flow, break-even timing, and three downside scenarios by Wednesday so the board can vote Thursday.
onetwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Collaborate with portfolio managers and analysts+
Work with Maia in portfolio management and Daniel the equity analyst to reconcile forecast assumptions, merge their revenue and risk inputs into a single model, and deliver a reconciled forecast with commentary and action items by Friday noon for the portfolio review meeting.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Purchase investments for companies in accordance with company policy.+
Execute purchases to rebalance the corporate investment portfolio to policy targets, buy the approved short-duration corporate bonds up to the authorised limit today, record trade details, and confirm compliance with duration and credit limits before settlement.
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 Excelcalculates variances, builds tables and charts, and supports linked financial schedules for reportingOpen its task library →
5 tasksMicrosoft PowerPointcreates the two-slide executive summary derived from the spreadsheets
4 tasksMicrosoft Outlooksend targeted follow‑up emails, attach ledger extract, and set deadlines with recipients
3 tasksMicrosoft Power BIingests reconciled inputs and builds the margin and cash burn dashboard for stakeholder review
2 tasksGoogle Docscollaborates on the variance narrative and collects reviewer comments in one place
1 taskAlteryxautomates data preparation and report generation workflows to reduce manual steps and errors
1 taskIntuit QuickBooksmaintains the ledgers and generates reconciled transaction reports and tax schedules required for audit
1 taskMicrosoft Wordformats the memo and narrative recommendation for HelenOpen its task library →
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 forecasting 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
M · R6 of R7This job sits on speculating — real theory, real diagnosis, but reality still holds the grading pen.

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
StatisticsExperimentation Scientist26 evidenced tasks StatisticsProcess Improvement Analyst25 evidenced tasks km/h RPMStatisticsMeasurement Analyst25 evidenced tasks StatisticsData Labeling Lead23 evidenced tasks StatisticsFreelance Data Consultant23 evidenced tasks StatisticsSas Programmer22 evidenced tasks StatisticsActuary21 evidenced tasks StatisticsClinical Data Manager21 evidenced tasks

Questions people actually ask

You spend mornings pulling data from Excel, Power BI, or Alteryx, cleaning it, then updating financial models and forecasts. That often means running a cash-flow or revenue forecast and checking assumptions like sales growth rates and expense schedules.

Afternoons are meetings: presenting findings in PowerPoint to managers, conferring with portfolio managers about asset performance, or following up with backers and stakeholders by email (Outlook/Docs). You also prepare materials for deals and keep records for auditors or tax teams.

Start with Microsoft Excel — think pivot tables, VLOOKUP/XLOOKUP, and building models with formulas. Most forecasting work and charts live in Excel and get exported to PowerPoint or Power BI.

Next learn Power BI for dashboards and Alteryx for automating data prep. Know Outlook/Word/PowerPoint for client presentations and QuickBooks only if you’ll handle accounting entry-level tasks.

Use AI to speed repetitive tasks: generating formula templates, summarizing market reports, or drafting slide text. Always treat AI output as a draft — verify numbers against source data in Excel or Alteryx and document assumptions.

Never feed confidential client or transaction data into public AI tools. Keep sensitive datasets in company systems (Power BI, secured Excel files) and log decisions for auditors.

Salary varies by region and experience. Entry-level forecasting analysts in the U.S. often start near the market median for financial analysts; senior roles or those managing portfolios earn significantly more. Bonuses come from performance and completed deals.

Key factors: your skill with Excel/Power BI/Alteryx, whether you handle client relationships or transaction execution, and industry—investment firms and corporate finance typically pay higher than small businesses.

Take courses in Excel modeling, statistics, and corporate finance. Practice by building simple forecasts: a three-statement model (income, balance sheet, cash flow) in Excel and a dashboard in Power BI using public financial data.

Learn to present: make 6–8 slide PowerPoint decks that explain assumptions and outcomes. Familiarize yourself with QuickBooks basics if you’ll work with accounting teams.

Forecasting analysts focus on building models and predicting future financial metrics (cash flow, revenue, expense scenarios) and on tools like Excel, Power BI, and Alteryx. They prepare reports and advise on viability and pricing.

Financial analysts have overlapping tasks but may concentrate more on valuation, securities pricing, or company-level analysis. Portfolio managers decide what to buy/sell and execute purchases within company policy—forecasting analysts supply their models and market monitoring.

Advanced Excel modeling: being fast with formulas, scenario tables, pivot tables, and clear workbook structure makes daily forecasting and sensitivity tests much quicker and less error-prone.

Closely tied is data preparation skill in Alteryx or Power BI — cleaning and automating data reduces manual errors and frees time for analysis and stakeholder presentations.

km/h RPM

How far can AI take you?

one question
Be honest — how far can a language model take you on speculating?
There is a real answer, and it is not the flattering one.