25 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You usually split time between data work and meetings. Morning: pull market data and update Excel models, check emails in Outlook, and run any Alteryx workflows. Late morning: meet portfolio managers or clients to discuss positions or upcoming deals.
Afternoon: build charts in Excel or Power BI, write analysis for a report or PowerPoint, and follow up on financing records or compliance items. Expect concentrated model-building, short calls, and at least one presentation or deliverable due each day.
Learn Microsoft Excel deeply: relative/absolute formulas, pivot tables, INDEX/MATCH, and basic VBA or macros. Excel is used for valuations, forecasting, and charts every day.
Next, get comfortable with PowerPoint for client presentations, Outlook for communication, and at least basic Power BI or Google Sheets for dashboards. Familiarity with Alteryx or QuickBooks is useful depending on the employer — Alteryx for data prep, QuickBooks if you’ll touch bookkeeping or small client books.
Use AI to speed repetitive tasks: summarise earnings calls, generate first-draft slide text, or suggest chart layouts. Always check AI outputs against original data and your Excel model; AI can hallucinate numbers or misstate sources.
Never copy AI-generated valuations or investment recommendations without independent calculations. Keep data provenance: note where each input came from (Bloomberg, company filings, QuickBooks), and store raw data and model versions so auditors or managers can verify results.
Start titles are usually Analyst or Junior Analyst; next steps are Senior Analyst, Associate, then Portfolio Manager or VP. Progress depends on deals closed, model quality, and client relationships.
Pay varies by city and firm. Entry analysts often see a salary range from an hourly equivalent of about $25–$45/hour (salaried) up to higher in big financial centers; bonuses depend on performance and firm profits. Check company offers and local salary surveys for precise numbers.
Practice building full financial models: cash-flow forecasts, DCF (discounted cash flow) valuations, and sensitivity tables in Excel. Use real company filings (10-K, 10-Q) to populate your models and make a one-page investment memo.
Make sample client slides in PowerPoint and a simple dashboard in Power BI or Google Sheets. Learn to read market data and write short recommendations; show these projects in interviews. If available, take short courses on Excel, financial modeling, and Alteryx for data prep.
Investment analysts focus on valuing securities, forecasting performance, and recommending purchases or sales for portfolios or companies. You build models, monitor markets, and present findings to portfolio managers or clients.
Financial planners advise individuals on budgeting, retirement, and insurance. Accountants record transactions and prepare tax/audit documents (QuickBooks is common there). Investment analysts overlap with both but are more about valuation, market research, and trading or portfolio decisions.