26 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You’ll split time between data work and finance work. Mornings often start with checking Microsoft Outlook for status updates, market news, and meeting invites, then reviewing dashboards in Microsoft Power BI or Excel to spot traffic or revenue drops.
Afternoons usually mean building or updating models in Excel, preparing charts or a PowerPoint for stakeholders, and meeting managers to discuss investment or budgeting decisions. Expect ad-hoc tasks like pulling numbers from QuickBooks or running data prep in Alteryx.
Start with Excel — you’ll use it daily for financial models, forecasts, valuation tables, and charts. Learn formulas, pivot tables, and charting first.
Next, learn Power BI for dashboards and interactive reports, then Alteryx for cleaning and automating data flows. QuickBooks is useful if you’ll handle bookkeeping or audit prep, but it’s narrower: learn it after the others.
Expect about 60% analysis and 40% meetings/presentations in many roles. You’ll spend heavy blocks in Excel or Power BI building models and charts, then time translating findings into PowerPoint or Google Docs for stakeholders.
You’ll also meet portfolio managers, clients, or company management to explain recommendations, refine assumptions, and follow up on financing records with backers.
Yes, AI can speed tasks: generating first-draft slides, cleaning data scripts for Alteryx, or suggesting Excel formulas. Treat AI outputs as a starting point and always verify numbers against source systems like QuickBooks or raw data.
Risks include wrong calculations, leaking sensitive financial data, or trusting a poor model. Keep confidential files offline when required, document every change, and never present AI-generated figures without audit trails and manual checks.
Pay varies by location and company size. Entry-level analysts in the U.S. often start around $50,000–$70,000 a year; more experienced analysts who build models, supervise juniors, or advise on investments commonly earn $80,000–$120,000.
Learn to build clear, auditable Excel models. That means correct formulas, named ranges, version control, and an assumptions sheet. Good models make forecasting, valuation, and scenario tests fast and defensible.
Pair that with making clear charts and slides (PowerPoint or Google Docs) so you can present recommendations to clients, managers, and backers with numbers they can verify.