Example · BI Analyst
A model can build the dashboard. People still need you to stand behind what the number means.
30 of your 40 hours still need you
- 16 stay yours
- 14 faster with AI
- 10 tools could take
A typical week at the middle pace. Your plan uses your own tasks.
Are BI analyst jobs going away?
By our task-by-task count, 30 of a typical 40-hour week as a BI analyst still need a person. Tools could already take about 10 hours. The exposed 25% is the work that looks like a data analyst's job: pulls, extracts, adding the column, first-draft dashboards. A model already does all four.
Read more
What BI analysts tend to dread is almost entirely in that slice.
The rest holds for a reason most exposure analyses miss. You are becoming the person who decides what a number means for the whole organization. That is systems ownership, and cheaper SQL does not lower its value. The risk is that a platform migration and the Copilot rollout get run by people who aren't you. Then you end up maintaining a semantic layer, the shared model reports draw from, whose definitions someone else chose. The meeting about why two numbers disagree is where the work that holds up happens. This report helps you walk into it as the person who owns the answer.
The hard truth
Data quality is still a top problem for data teams.
You can build a beautiful dashboard and still find people doubting the numbers. AI tools that answer questions from your data depend on that same quality.
Sources (2)
- 56% of data practitioners surveyed named data quality as a problem, still a top issue. dbt Labs, State of Analytics Engineering 2025 (vendor survey), 2025-05
- Gartner predicted at least 30% of generative AI projects would be abandoned after proof of concept, citing poor data quality first. Gartner press release, 2024-07
What stays yours
Deciding what a contested metric means when finance and operations disagree
This needs accountability and context. A definition can feed a regulator-reported number, a payer or customer scorecard and a board pack. Someone named has to pick one and defend it. A model can list the candidate definitions in seconds, but it can't be the name in the governance log.
Finding out why a site's or branch's number is wrong
This rests on context nobody writes down. A scheduler's habit of closing missed visits as completed lives in one branch's workflow and in no table. You know to look because you've sat with that team.
Requirements sessions with a director who says "I just need a dashboard"
This depends on context. The real question is usually "prove to my VP that my team isn't the problem." Getting there takes a human she trusts.
Teaching people to answer their own questions
This needs presence and context. Self-service adoption grows from a relationship. The people who will use Copilot well are the ones you trained on what the certified model contains.
Regulatory and external quality extracts
The legal duty here sits with an executive, who attests to what the company reports. That attestation needs a person who can explain every row; often that is you.
What's the career path after BI analyst?
Plan A is your best move inside the work you do now. Most sessions in the 13-week plan build toward it.
- A
Own the metric registry and the certified semantic model
Why it fits
Why you. You may already reconcile the definitions without being named for it. A record of finding the branch-level bug is standing nobody else on the team may have.
The gap. There is no registry and no sign-off process yet. Finance and operations must agree to a decision rule, which takes people skills more than SQL.
The trade-off. You become the person blamed when two numbers disagree, formally and in writing. The meeting is the same, but you have more authority. You'll ship fewer dashboards for a quarter and someone will notice. A consultancy can still be hired above you. The plan makes that harder but not impossible.
Other moves that fit
These are also good bets in this field. Read them if Plan A doesn't suit you.
Own what the AI is allowed to see
Why it fits
Why you. You build the row-level security (RLS) and know which workspaces carry sensitive data. When compliance rules on Copilot, they need someone who can say what's in them.
The gap. You don't yet have a working relationship with the privacy officer, and your HIPAA knowledge may stop at the annual training module.
The trade-off. It sits next to compliance, which is slower and less visible and can make you the person who says no. If the bug hunt is what you love, keep this a supporting move. The protection is also borrowed, since a privacy officer can buy a governance platform instead.
The portable hedge: two exams and one public artifact
Why it fits
Why you. You already build production reports in Power BI, and the market screens for it.
The gap. Every gap here can be closed in about 90 days.
The trade-off. Leaving resets the asset this report says protects you. Your first year anywhere new is your most exposed. Week 10 prices the market so the hedge is a true option. You don't have to take it.
What's a plan B for business intelligence analysts?
Plan B is a job AI is creating that these skills already fit. One session a week in the plan trains you for it, so it is ready if your job shrinks or you want a change.
BPlan B, picked for this role
AI workflow builder
Your SQL, refresh jobs and Power BI work already automate reporting, and Power Automate and Copilot Studio sit in the same Microsoft stack.
Other options
Context engineer and knowledge curator
Owning what a contested metric means is the semantic layer AI assistants need to answer data questions correctly.
AI governance analyst
Setting row-level security and deciding who sees sensitive data is access control that AI governance teams now need.
In your own plan you can switch to any of the 47 roles.
The first two weeks
The first 2 of 13 weeks. Most weeks have three sessions of 45, 60 and 90 minutes, plus one 40-minute Plan B session on AI. Weeks 5 and 9 fall in month-end close, so they have one 45-minute session plus the Plan B session, and week 12 has two sessions. Each week adds to the metric registry that your week 12 memo is built on. By week 13 you'll have a metric registry with your name on the entries, a signed process for settling metric conflicts, and a memo asking to own the registry.
- Week 1: Measure your week
What you do
- ATrack your time for one week against the 13 tasks in this report. Write down the hours each one takes.
- AList every metric in the board pack, the operational scorecards and the close deck.
- AMark every metric that has two different definitions in different places. Count them.
- BTake the first half of AI Fluency: Framework & Foundations, Anthropic's free course. List three report requests you would let AI draft.
- Week 2: Ask what AI may see
What you do
- AEmail the privacy officer. Ask which workspaces are cleared for Copilot, Microsoft's AI assistant, whether there is a BAA (the HIPAA vendor contract) covering it, and who decides.
- AList which Power BI workspaces hold sensitive data, such as patient or member records.
- ADraft a one-page policy on what the AI may and may not see.
- BRead Microsoft's Copilot for Power BI overview. Open the public Retail Analysis sample and list the measures with no description.
Three courses from the plan
Checked 2026-09-22.
- PL-300: Microsoft Certified Power BI Data Analyst AssociateMicrosoft · $165 US (Microsoft Q&A, December 2025; the certification page says "priced by region")
Yes, Week 6. It is cheap, you will likely pass if you work in Power BI daily, and 29% of postings ask for it.
- DP-600: Microsoft Certified Fabric Analytics Engineer AssociateMicrosoft · $165 in the US; priced by country
After the update, yes, if a Fabric migration is coming.
- Salesforce Certified Tableau Desktop Foundations (formerly Desktop Specialist)Salesforce · $75; retake free
No, unless Tableau is your company's main tool.
Risks beyond AI: moderateOverhead-cut and consultancy risk
Set AI aside for this one. A BI team is overhead (G&A), and overhead gets cut when the business has a bad year, whatever a model can do. In a sector like home health, Medicare rate resets have taken headcount from teams like yours before AI existed. A platform migration handed to a consultancy can also move ownership of the definitions outside the company.
Where this could be wrong
- We assumed nobody owns definitions today. If a governance council with a metric catalog exists, the registry move is "join it," not "build it."
- Company AI policy could loosen faster than we assumed. If compliance signs a Copilot BAA addendum, tasks now blocked by policy open up to AI, and the share of your week tools can do rises to nearer 35%.
- The consultancy risk may be overstated. Some companies keep migrations in-house. Ask the CIO, your head of IT, in Week 2.
- This report leans on a healthcare-services example. A different sector, or a physician-practice or behavioral-health setting, would change who holds responsibility for each task, so check those parts against your own workplace.
Also matched: bi analyst, business intelligence analyst, reporting analyst. Research checked 2026-09-22. Page updated .