Use AI assistants to speed up real data work: cleaning messy data, exploring it, writing formulas and Python, building charts and explaining findings. Learn to check the numbers so AI never puts a wrong figure in your report.
LevelIntermediate
Estimated time20 hours
Syllabus6 modules + capstone
FormatSelf-paced
Leads toApprentice rank in Data Analysis with AI
Is this course for you?
Who it’s for
Analysts, accountants and operations staff
Anyone who works in spreadsheets every week
Marketing and sales people who report on numbers
Students moving into data roles
Before you start
Confident with spreadsheets (sorting, filtering, basic formulas)
AI Fundamentals or Prompt Engineering for Work recommended
No coding needed to start; Python is introduced gently
What you’ll be able to do
01Clean and reshape messy data with AI help, and document each step
02Ask good analytical questions and explore data with summaries and pivots
03Have AI write spreadsheet formulas and Python (pandas) code, then test it
04Choose the right chart and explain a finding in plain words
05Build a simple trend forecast and explain its limits
06Check AI-produced numbers and protect sensitive data
Skills for your resume
Data analysis
Data cleaning
Spreadsheet formulas
Python (pandas)
Data visualisation
AI-assisted analytics
Once you’ve earned the rank, list these in the Skills section of your resume and LinkedIn profile.
The syllabus
6 modules · 20 hours · 1,020 XP to collect. Every module ends with a practical project.
Module 1
Data basics for analysts
+120 XP
Lessons
Rows, columns, types and tidy data
Common data quality problems
Privacy: what data you can share with AI
Setting up a safe working copy
Practical projectAudit a messy dataset and list every quality issue.
Module 2
Cleaning data with AI help
+120 XP
Lessons
Fixing dates, duplicates and blanks
Splitting and combining columns
Asking AI for formulas, then testing them
Keeping a cleaning log
Practical projectClean a sales dataset and document each step.
Module 3
Exploring and summarising
+120 XP
Lessons
Descriptive statistics in plain words
Pivot tables and group-bys
Finding outliers
Asking better analytical questions
Practical projectAnswer five business questions from the cleaned data.
Module 4
Python for analysis, with an AI pair
+120 XP
Lessons
Notebooks and pandas basics
Reading AI-written code before running it
Merging and reshaping data
Testing results against the spreadsheet
Practical projectRecreate your spreadsheet analysis in a Python notebook.
Module 5
Charts and storytelling
+120 XP
Lessons
Picking the right chart
Clean, honest visuals
Writing the ’so what’
Building a one-page dashboard
Practical projectBuild a dashboard with four charts and three plain-language findings.
Module 6
Forecasting and checking
+120 XP
Lessons
Trends and seasonality
A simple forecast and its uncertainty
Cross-checking AI numbers
Common ways AI analysis goes wrong
Practical projectProduce a three-month forecast with a written note on its limits.
Capstone project · +300 XP
Show what you can do
Take a public dataset from start to finish: clean it, explore it, chart it, and write a two-page report with a recommendation. Include your cleaning log and the checks you ran on every AI-produced number.
Live viva, at launch. A recorded 5–10 minute walk-through with an assessor or teacher who can ask follow-up questions.
Process evidence. Submit drafts, notes or commit history, not just a finished file.
AI disclosure. If you used AI, say how. Hidden use can void the project.
Checks are a signal, not the verdict. AI-detection and similarity reviews help the assessor. They are never the only proof.
XP is just for fun. It tracks your progress, but it can never buy or skip a rank.
The Rank Trial
When you’ve finished every module and the capstone, the Apprentice Trial in Data Analysis with AI opens. The Guild runs it, not your instructor, so the rank means the same whoever taught you. It is a proctored, closed-book exam.
What’s assessed
Data cleaning and preparation
Analysis and choosing the right summary
Charts and explaining findings
Verifying AI output and protecting data
How it works
Format
Proctored online exam, closed notes
Questions
45, randomised bank of scenarios, lab tasks and short answers in your own words
Time
75 minutes, timed
Pass mark
70%
Identity
Verified account, ID check at launch
Re-sit
After 7 days if you don’t pass; a voided attempt may wait longer
AI in lessons
This is an AI course, so you will use AI tools in the lessons and projects where the module says so. That is part of the skill.
AI in the Trial
Never. The Trial is closed-book and proctored. No assistants, notes or other people.
AI in projects
You may use it only with a clear disclosure of what the tool did and what you did yourself.
Integrity · at launch
Built to stop easy AI cheating
Proctoring, identity checks and live labs start at launch. These are the rules the platform will enforce.
Webcam and screen shareYou share your camera and your screen for the whole sitting.
Locked-down browserThe Trial runs in a locked browser. Copy and paste, extra screens and leaving the tab are flagged.
ID checkYou sit it from a verified Guild account, with an identity check before the clock starts.
Randomised question bankEach attempt draws a fresh mix of questions, so a leaked paper or a chatbot answer key will not help.
Time-boxedThe sitting is timed. When the clock ends, the attempt is submitted as it stands.
Live sandbox labsPractical tasks use a live lab with data unique to you, not a question you can paste into an AI tool.
Ranks are earned. They can’t be bought, and no amount of XP can skip a Trial. Cheating voids the attempt and can revoke a rank already awarded.
Your path in Data Analysis with AI
ApprenticeThis course
JourneymanCourses coming
ExpertCourses coming
MasterCourses coming
The credential you earn
Example
Guild credential
Apprentice · Data Analysis with AI
Proctored
Awarded to
Your name
Course
AI for Data Analysis
Credential ID
GS-XXXX-XXXX
Awarded by
Guild of Skills
Assessment
Proctored Rank Trial
Check it at
guildofskills.com/verify
Example only. Each real rank gets its own ID, a Proctored badge and a verify page.
On your resume
Add it under Licences & Certifications: Apprentice, Data Analysis with AI · Guild of Skills, the month you passed, and your credential ID so employers can check it.
On LinkedIn
Open your profile and add a Licence or certification
Name: Apprentice, Data Analysis with AI. Issuing organisation: Guild of Skills
Add the issue date, your credential ID and your verify link
Add to LinkedInUnlocks when you pass the Trial
Your instructor
Guild-approved instructor coming soon
Every instructor is reviewed and approved by the Guild Council before they can teach, and every lesson and video link is checked before students see it.
Works with common spreadsheet tools and Python. A Guild credential is not a vendor certification.
Questions about this course
Do I need to install Python?
Not at first. The early modules use spreadsheets. For the Python module you can use a free online notebook, so nothing needs installing.
How much does it cost?
Pricing is announced at launch. Some courses may be free and some paid.
When can I start?
Enrolment is open now. Create a free account, confirm your email, then enrol from this page. Lessons, pricing and live cohorts are confirmed at launch.
Do I get a certificate just for finishing?
Finishing the course unlocks the Rank Trial. Your rank, certificate and verify page are awarded only when you pass the Trial.
Is this the same as an industry certification?
No. A Guild rank is a Guild of Skills credential with its own published standard and public verify page. It isn’t a vendor certification and doesn’t include any vendor exam.
Can I use AI in the Rank Trial?
No. The Trial is closed-book and proctored. AI assistants, notes and other people are not allowed. A flagged attempt can be voided.
Can I use AI while I learn?
Yes, where a module says so, especially in the AI courses, where using the tools is part of the skill. You must disclose any AI you use in a project or capstone.
What is a viva?
After you submit your capstone you walk an assessor or teacher through it, live, for five to ten minutes, and answer follow-up questions. The session is recorded. It starts at launch.
What happens if I cheat?
The attempt is voided. You wait to re-sit, at least seven days, and longer for a serious breach. A rank already awarded can be revoked, and the public verify page will show that.
Leads toApprentice rank in Data Analysis with AI
JourneymanCourses coming
ExpertCourses coming
MasterCourses coming
