Stop doing courses. Start getting experience.
Work as a junior data analyst on two client accounts for four weeks, with a senior analyst as your manager and deliverables due every Friday. You finish with real experience, a portfolio and a CV that gets interviews.
- One-to-one with a senior analyst
- SQL, Excel, Power BI
- Portfolio & career support
Your internship includes
- 4 weeks working on two client accounts
- Weekly reviews from a senior analyst
- 7 portfolio deliverables you keep
- CV rewrite & interview preparation
The price is set in US dollars. Choose your currency to see an estimate.
Secure checkout in US dollars; your bank converts it. Your onboarding details arrive by email automatically after payment.
Why it works
A job, done properly.
Employers don't hire certificates. They hire people who have done the work. That's the gap this internship closes.
A typical online course
- Follow along with someone else's screen
- Clean, ready-made practice data
- No deadlines, no one checking your work
- A certificate, but nothing to show
This internship
- A client brief and a deadline every Friday
- Messy databases you audit and fix yourself
- A senior analyst reviewing and challenging your decisions
- Seven pieces of real work for your portfolio
Week by week
Four weeks that feel like the job.
Each week ends with a deliverable on Friday, reviewed by your manager the way it would be at work.
Simulated client accounts built on industry-standard Microsoft sample databases.
- Week 1Data discovery & audit
Profile two client databases in SQL Server, document data quality issues and deliver a formal data audit report. Then build a recurring weekly sales report in Excel, automated with Power Query.
- Week 2Power BI dashboard
Gather requirements from the client brief, design a star schema model, write DAX measures and build a three-page dashboard, published to the Power BI Service.
- Week 3Advanced SQL
Answer harder business questions with CTEs and window functions: supplier performance analysis and customer churn tracking.
- Week 4Analytics & storytelling
Forecasting, What-If parameters and AI visuals, then a 10-slide executive presentation delivered live to a panel.
- LaunchCareer launch
Turn the work into results: CV rewrite, LinkedIn profile, interview preparation and a certification pathway guide.
What you'll leave with
A portfolio that proves it.
Seven deliverables to share with employers and talk through in interviews.
- 01SQL query library50+ queries you wrote and can explain
- 02Automated Excel reportSQL-connected sales report with a written SOP
- 03Power BI dashboardA three-page dashboard published to the Power BI Service
- 04Analytics reportsSupplier and customer churn analysis
- 05Executive presentation10 slides, presented live to a panel
- 06Data dictionary & auditA formal audit report and documented data model
- 07Updated CVPlus answers to five real interview questions
The toolkit
The tools employers actually ask for.
Everything runs on a Windows laptop and is free to download. Excel 2016 or Microsoft 365 is all you need to buy.
- SQL Server & SSMSQuery, profile and audit real databases
- Microsoft ExcelReporting, analysis and automation
- Power Query (M)Repeatable data cleaning and refresh
- Power BIData modelling, DAX and dashboards
- PowerPointExecutive-ready storytelling
How to join
Start in three steps.
- 1ApplyClick apply and enter your name and email on our secure checkout.
- 2Pay securelyPayment confirms your place straight away.
- 3Start Week 1Your onboarding email arrives automatically, with everything you need to begin.
I went from oil and gas engineering to a UK data analyst role in six months. What made the difference was practical, real-world experience.
Who's behind it
Built by analysts, for future analysts.
Intelligence With Data is a UK data consultancy. Our founder, Hakeem Falade, is a Senior Data Analyst, a Microsoft Certified Professional and a member of BCS, The Chartered Institute for IT. The internship mirrors how analytics work is done for our clients.
Questions
Good to know
How is this different from a Udemy or YouTube course?
A course shows you how to follow along. This internship puts you in a data analyst role: you get a client brief, a deadline every Friday and a senior analyst who reviews your work and challenges your decisions, just like a real job.
Is it online or in person?
Fully online and one-to-one, by video call, so you can join from the UK, Canada, Europe, Africa or anywhere else.
Will this help me get a job?
The biggest problem for new analysts is having nothing to show an employer. You finish with real experience to talk about in interviews, a portfolio of seven deliverables, a rewritten CV and interview preparation.
What computer do I need?
A Windows laptop or desktop. SQL Server Management Studio and Power BI Desktop are Windows applications and are free to download. You'll also need Excel 2016 or Microsoft 365.
What happens after I pay?
Your place is confirmed straight away and your onboarding details arrive by email automatically, so you can get set up and start Week 1.
Is this the same as the internship add-on on the Saturday programmes?
The Saturday programmes teach the skills in a live group class; the internship is where you use them on client work. If you're joining a Saturday cohort, you can add the internship when you apply on the programmes page.
Limited places
Ready to stop studying and start working?
Places are one-to-one, so each cohort is small. Apply now to secure yours.