Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.
Core to the job
Chapter 2
Data maturity
Check a small organisation's data and score its AI readiness
What you'll learn
Data inventory
Quality profiling
Maturity dimensions
Gap impact
Practice
Run a mini data audit on an organisation you know30 min
Write a Data Readiness Findings Memo for a Retail AI Project35 min
Chapter 2
Data governance
Give each dataset one owner and a quality review schedule
What you'll learn
Data ownership
Stewardship roles
Quality measures
Dispute route
Master data
Practice
Choose a Central or Federated Data Operating Model25 min
Chapter 2
Data architecture
Label a data system's parts and sketch how data flows
What you'll learn
Data warehouse
Lakehouse platforms
Data pipeline
Data catalog
Build versus buy
Storage shape choice
Current before target
Architecture trade-off
Practice
Label the Components of a Data Stack Diagram15 min
Chapter 6
AI use cases
Rank possible AI uses by value, risk and effort
What you'll learn
Reliable AI tasks
Use-case value
Risk and feasibility
Demo production gap
Practice
Score Three AI Use Cases on a Simple 2×215 min
Score three AI use cases on value, risk, and effort25 min
Chapter 6
AI rollouts
Map one AI idea through delivery stages, naming each blocker
What you'll learn
AI delivery stages
Stage gates
Value and risk tradeoffs
Shared dependencies
Waves before dates
No-regrets moves
Practice
Keep the Date, Change What Is In It20 min
Turn a Scored Use-Case List into a Two-Wave Roadmap30 min
Mark the No-Regrets Items on a Real Roadmap25 min
Chapter 6
Measuring AI value
Time a task with and without AI and record results
What you'll learn
Baseline measure
Adoption and outcomes
Value assumptions
Error rates
Cost per answer
Latency budget
Practice
Name What You Would Measure Before an AI Pilot Starts15 min
8 more in the plan
Problem solvingTest each possible cause of a problem instead of guessingCh 4
What you'll learn
Problem vs symptom
Clean problem splits
Root cause
Deciding under uncertainty
Practice
Separate the Problem from the Symptom10 min
Critical thinkingSpot a weak assumption and ask where numbers come fromCh 4
What you'll learn
The hidden assumption
Argue the other side
The base rate
Fact vs inference
Wanting it to be true
Secondary researchCompare sources that disagree and explain why they differCh 4
What you'll learn
Source types
Independent sources
Source purpose
Claim provenance
Practice
Profile 3 competitors in 30 minutes30 min
SQLCheck a table for missing values and duplicates using SQLCh 5
What you'll learn
SQL query shape
Data profile
Script reading
API webhook flow
Spreadsheet modelsBuild a spreadsheet model whose results update when inputs changeCh 5
What you'll learn
Model structure
Formula links
Lookup formulas
Sensitivity table
CommunicationRewrite an update for two different readers, cutting extra linesCh 8
What you'll learn
Lead with the point
Match detail to the reader
Said versus heard
Specific feedback
Practice
Write a Six-Line Delay Message10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 8
What you'll learn
Early team friction
Clear ownership
Challenge ideas, not people
Lead or follow
Practice
Navigate a Disagreement Without Damaging the Relationship20 min
StoryboardingSketch each slide's point and evidence before building the slidesCh 9
What you'll learn
Storyboard before slides
Action headlines
Headline story
Opening context
Practice
Storyboard a Three-Slide Argument15 min
Your plan
Chapter by chapter.
13 chapters, in this order. Chapter 1 is free.
1~2 wks
See the work of a data and AI strategy consultant
StartFree
2~2 wks
Design a data platform with clear ownership
Skills
31–2 wks
Build a one-page data and AI roadmap
Project
4~2 wks
Find answers others have already published
Skills
5~2 wks
Build spreadsheet models and query data
Skills
6~2 wks
Choose, run and measure AI projects
Skills
71–2 wks
Talk to two working strategy consultants
People
8~2 wks
Make yourself understood across a team
Skills
9~2 wks
Build slides that tell a clear story
Skills
102–3 wks
Capstone: build a data audit and AI roadmap
Project
111–2 wks
Answer the questions interviewers ask
Interview
121–2 wks
Decide how you will get in
Decide
13on your timeline
Send your first applications
Apply
The job
What a Data and AI Strategy Consultant does
Helps organizations decide where AI should go and fixes the data first. Assesses how mature the client's data is, designs the data architecture and governance (rules for who owns and protects data), and builds an AI roadmap that leaders approve and fund.
The work
Assess how ready a client's data is: quality, access, ownership, and gaps
Map the client's data landscape: what exists, where it lives, who owns it
Design data governance models that set clear rules for quality and ownership
Rank AI opportunities by value, risk, and how ready the data is
Build the data and AI roadmap that boards review, approve, and fund
Recommend build versus buy for data platforms and AI capabilities
Sequence the unglamorous data fixes that must happen before AI projects start
Define success measures so leaders can track whether the strategy is working
A typical day
Review data quality findings from yesterday's assessment of client systems
Interview a department head about which data they own and trust
Work with architects to compare two data platform options on cost and fit
Score three proposed AI use cases against the data readiness checklist
Draft the roadmap slide that shows data fixes before AI launches
End with a short note to the client sponsor on findings and risks
Tools
Spreadsheets: Excel, Google SheetsSlides and docs: PowerPoint, Google Slides, NotionData analysis: SQL, PythonData catalogs: Collibra, Alation, Microsoft PurviewCloud data platforms: Snowflake, Databricks, BigQueryDiagrams: Lucidchart, Miro, draw.ioAssessment frameworks: data maturity models, readiness scorecardsProject tracking: Jira, Asana
Ways in
There is more than one route.
Ways to study
Bachelors degree in information systems, computer science, business, or economics
Bachelors degree in any field plus strong data analysis and SQL skills
Masters degree in business analytics, data science, or information management
Short courses in data governance, cloud data platforms, and AI strategy
Certifications such as DAMA CDMP for data management, or Azure Data Fundamentals and AWS Cloud Practitioner for cloud basics
How people get their first job
Apply for consulting internships on data, analytics, or AI advisory teams
Start as a data analyst or business analyst and join data strategy projects
Build a portfolio with a data audit, a governance plan, and a small roadmap
Earn a data fundamentals certificate from a major cloud vendor
Map and clean the data of a school club or small business, then document what changed
How long does it take to become a data and ai strategy consultant with Welica?
The plan is 13 chapters, 5–6 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.
Do I need a degree?
Not always. Common routes are bachelors degree in information systems, computer science, business, or economics, bachelors degree in any field plus strong data analysis and SQL skills, masters degree in business analytics, data science, or information management, short courses in data governance, cloud data platforms, and AI strategy, or certifications such as DAMA CDMP for data management, or Azure Data Fundamentals and AWS Cloud Practitioner for cloud basics.
What is free?
Chapter 1, See the work of a data and AI strategy consultant, is free for good. Premium unlocks the rest of the plan.