◆ Data & Analytics

What a crm 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
9systems 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 North America campai…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 North America campaigns: pull actuals and budget, reconcile variances, highlight three drivers of profit erosion, attach the reconciled statements, and deliver to Maria in FP&A by next Tuesday 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 and analyse Q2 financial information for CRM: extract campaign spend, revenue, and CAC, cleanse and join transaction lines, compute cohort LTV, and upload the dataset plus a one-page summary to the shared drive for Emily by Wednesday noon.
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+
Analyse the proposed loyalty programme investment: build a three-scenario NPV and IRR model across five years, stress test discount rates and churn, and send the model and recommendation to Javier in Strategy before next Thursday'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?
Advise clients or organizations on financial decisions+
Draft a concise financial advisory note for Hargrove Retail explaining the recommended three-year cashflow plan, show projected P&L and balance sheet impacts, and flag risks to covenant compliance before I send it to their CFO by Tuesday.
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+
Prepare a one-page collaboration brief for portfolio managers Anna Ruiz and Marcus Lee summarising client segmentation, priority accounts, suggested allocation changes, and three data questions for the analysts to answer at Wednesday’s 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 the approved corporate purchase: buy 2500 shares of the AAA short-duration bond fund using the company’s trading mandate, confirm it fits policy limits, and send trade confirmation and updated cash position to treasury within the hour.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Confer with clients to restructure debt, refinance debt, or raise new debt.+
Call client Morgan Foods to review refinancing options, run the refinance versus restructure scenario showing interest savings, covenant impact, and recommended term, then email the agreed next steps and draft term sheet by Friday close.
onet
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Create client presentations of plan details.+
Build a concise client presentation for Brightwell Holdings that explains the financial plan, three recommended actions, projected outcomes, and two backup scenarios, formatted for a 15-minute board slot and ready for review tomorrow morning.
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
20 tasksMicrosoft Excelbuilds reconciled statements, performs variance calculations and charts for a region-level financial reportOpen its task library →
6 tasksMicrosoft PowerPointto package summary slides for Maria and stakeholders
4 tasksMicrosoft Outlookemail outreach and calendar scheduling tied to contact records
3 tasksMicrosoft Power BIvisualises forecast outputs and scenario comparisons for stakeholders
3 tasksGoogle Docshosts the user documentation and onboarding materials for Operations
2 tasksAlteryxingests, cleanses and joins transaction-level data and produces ready datasets and cohort LTVs for reporting
1 taskIBM SPSS Statisticsmodels scenario outcomes and stress-tests covenant impacts under different refinance terms
1 taskIntuit QuickBooksstores ledgers, produces reconciliations and trial balances, and exports statutory reports required by auditors and tax advisers
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 crm 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 & AnalyticsFinancial Analyst26 evidenced tasks Data & AnalyticsExperimentation Analyst26 evidenced tasks Data & AnalyticsData Governance Analyst26 evidenced tasks Data & AnalyticsR 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 start by checking Microsoft Outlook for overnight client emails and any urgent transaction notes. Then you pull data from Excel or Power BI to update dashboards showing customer accounts, asset performance, and open financing records.

Midday you run analyses in Excel or Alteryx—building forecasts, pricing securities, or preparing materials for deals—and end by drafting a short PowerPoint for stakeholders and noting follow-ups in Google Docs.

Learn Microsoft Excel deeply: pivot tables, VLOOKUP/XLOOKUP, and building financial models. CRM analysts use Excel daily to prepare forecasts, value securities, and make investment recommendations.

Next, learn Power BI for dashboards, PowerPoint for client presentations, and Alteryx for data cleaning. Basic Outlook, Google Docs, and QuickBooks knowledge helps with communication and bookkeeping tasks.

Use AI to automate repetitive tasks: cleaning data in Alteryx, generating charts from Excel, or drafting slide text for presentations. Always keep the original data and automation logs so you can trace results.

Never let AI make final investment recommendations or valuations. Verify models and outputs manually, document assumptions, and get sign-off from a portfolio manager or senior analyst before presenting to clients.

Salaries vary by firm and experience; entry-level analysts often start at typical finance-analyst ranges, while senior CRM or specialized valuation roles pay more. Bonuses often depend on deal activity and portfolio performance.

Factors that move pay: level of Excel/Power BI/Alteryx skill, experience valuing securities, certifications, and whether you handle client-facing tasks like restructuring debt or leading transactions.

Practice Excel financial modeling: build forecasts, sensitivity tables, and valuation models. Make a short PowerPoint showing your analysis and a one-page Google Doc explaining assumptions—these are the materials you’ll present in interviews.

Get hands-on with Power BI or Alteryx for cleaning and dashboards, and learn basic QuickBooks for bookkeeping context. Try an internship or help on a student portfolio to show real examples of reports and presentations.

A CRM analyst focuses on customer and client data flows, reporting, and tools—building dashboards, preparing transaction materials, and maintaining transparent records for audits. They use Excel, Power BI, and CRM data sources.

A financial analyst models investments and valuations more deeply; a portfolio manager makes buy/sell decisions and manages assets. CRM analysts support both by creating reports, presentations, and tracking financing records.

Advanced Excel ability matters most: accurate financial models, securities valuation, and clear charts. Employers expect you to build forecasts, run scenario analyses, and produce clean tables for PowerPoint.

Prove it with a short portfolio: an Excel file with a model and a linked PowerPoint slide, plus a Google Doc explaining assumptions. Show you can run a dataset through Alteryx or Power BI to make a dashboard if you can.