25 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You’ll spend the morning pulling data and checking market moves: open Excel files, refresh Power BI dashboards, and scan Outlook for overnight client messages. Expect to run Alteryx workflows or Excel macros to clean transaction and pricing data, then update forecasts or valuation models.
Afternoons often mean meetings: present findings in PowerPoint or Google Slides to portfolio managers, meet with company management or clients, and draft client presentations. End the day updating QuickBooks or finance records and noting actions for tomorrow.
Start with Microsoft Excel — VLOOKUP/XLOOKUP, pivot tables, and building simple discounted cash flow models; these are used daily for valuations and forecasts. Learn PowerPoint or Google Slides next to make client presentations and stakeholder reports.
After that learn Power BI for dashboards and Alteryx for data prep. Familiarity with QuickBooks helps for finance records and tax/audit transparency, and Outlook is essential for scheduling and client emails.
Use AI to speed repetitive tasks: generate Excel formulas, summarize earnings calls, or draft presentation text. Always validate outputs against raw data and your own calculations — AI can hallucinate numbers or misinterpret finance rules.
Automate data cleaning with Alteryx or Power Query and keep an audit trail. Never submit AI-generated valuations or recommendations to clients without manual checks, documented assumptions, and versioned backups.
Salaries vary widely by city and employer; entry-level product analysts often start in the low-to-mid five figures annually, while experienced analysts at investment firms can reach mid-to-high five figures or more. Bonuses tied to performance are common.
Check Bureau of Labor Statistics (SOC 13-2051.00), Glassdoor, LinkedIn Salaries, and company job postings for location-specific numbers and typical bonus ranges.
A product analyst focuses on analyzing investment products, preparing reports, building pricing and valuation tools, and supporting client presentations. You’ll spend more time on modeling, product-level performance, and tools like Power BI or Alteryx.
A portfolio manager makes buy/sell decisions and manages client portfolios directly. A financial analyst can be broader (company finance, budgeting, or FP&A). All three overlap on Excel work, but product analysts are more focused on product valuation, client materials, and operational tools.
Clear, accurate financial modeling in Excel combined with the habit of documenting assumptions. Good models answer specific questions: show inputs, formulas, and outputs so anyone can reproduce your valuations or forecasts.
Pair that with presentation skills in PowerPoint and the discipline to keep data pipelines clean in Alteryx or Power BI. That mix makes your recommendations trustworthy and easy to present to clients or stakeholders.