Online data analysis course for UK beginners
A written, practical pathway for professionals who need to organise, query, model and communicate data without becoming a Data Scientist.
- Excel, SQL and Power BI
- 120 automatically marked practice activities
- Four portfolio projects
At a glance
Start with a business question, check the data, then learn Excel, SQL and Power BI as parts of one workflow. KINTAVOR’s written course starts from the foundations and includes guided practice and four projects. It is suitable for self-paced study alongside work, with 12 calendar months of access.
Professional Data Analyst · £83.24 · 12 calendar months
Online, self-paced written lessons and practical activities. 14 modules, 56 lessons, 120 practice activities and four portfolio projects.
Microsoft licences, Windows and the official PL-300 exam are not included.
Enrol in the full Data Analyst courseA practical starting point for a UK business report
Imagine a weekly sales report for a small UK retailer: the useful question is which product groups contributed to margin, rather than which chart looks most impressive. Write down the reporting period, whether values include tax, and what a returned order means before calculating anything.
When adapting your own work, distinguish a pound sign used for display from an actual currency conversion. Keep the source currency and date interpretation explicit. The supplied course projects use synthetic data; these UK examples help you transfer the method without uploading customer records.
- Choose one decision and one reporting period
- Check date types and missing values before grouping
- Explain the calculation and one limitation alongside the result
Start with the question, not the chart
Learning analysis is not about memorising buttons. First translate a business need into an objective, population, period, dimensions and measures. Then check whether the data can answer it.
Sales, finance, marketing and logistics help distinguish data, metrics, KPIs and insights. Each claim is tied to its calculation, context and limitations.
- Define a testable question
- Identify insufficient granularity and quality
- Distinguish correlation, comparison and causation
A connected progression across tools
Excel helps you recognise clean tables, formulae and pivot tables. SQL turns questions into reproducible queries. Power Query records transformations. The star schema and DAX enable consistent analysis. Power BI brings everything together in an accessible report.
A single case requires you to decide whether each transformation belongs in the source, ETL, model or a measure.
- Controlled formulas and validations
- Read-only SQL on synthetic data
- Justified transformations, relationships and measures
Practice with honest marking
Activities that can be validated receive structured marking: results, options, step order or normalised expressions. Tasks requiring Power BI Desktop are checked through checkpoints and rubrics; the platform does not claim to inspect a PBIX.
Attempts record time, hints and errors. The notebook turns an error into a scheduled review and a reusable explanation.
A professional result, without employment promises
The four projects include a brief, synthetic data, a dictionary, quality issues, SQL, Power Query, a model, DAX, a wireframe, a rubric and reference conclusions.
KINTAVOR does not promise employment or a PL-300 pass. The certificate is private, attests to internal criteria and does not replace Microsoft certification.
A process you can repeat for every challenge
Understanding, implementing and checking are parts of the same task.
- 01
Question
Define the decision, scope, period and KPI.
- 02
Prepare
Profile, clean and document quality.
- 03
Model
Build consistent relationships and measures.
- 04
Explain
Present evidence, limitations and a recommendation.
Frequently asked questions
Specific answers about this learning pathway.
Do I need previous experience?
No. The diagnostic identifies your starting point, and the pathway begins with analytical thinking and well-structured tables.
Is this a Data Science course?
No. It focuses on business analysis; Python and Pandas appear as an optional bonus.
Can I study with just a Mac?
Some of the content, yes, but Power BI Desktop requires compatible Windows supplied by the student.
Are licences or the exam included?
No. Windows, Microsoft 365, Excel, Power BI Pro and PL-300 are obtained and paid for separately.
Can I fit the course around a UK working week?
The lessons are written and self-paced, so there are no scheduled classroom sessions to attend. Access lasts 12 calendar months; your completion time depends on previous experience and the time you set aside for practice.
Primary sources and further reading
- Microsoft: data types and regional interpretation in Power Query
- Microsoft: installing Power BI Desktop and system requirements
Source links checked on 15 September 2026. Official software requirements and exam objectives can change; use the linked publisher pages when planning your study.
Build your analysis skills in one connected course
£83.24 once for 12 calendar months of access to the complete Professional Data Analyst course. No automatic renewal.
MYSERVEAI TECHNOLOGIES SL. is an independent educational platform. It is not affiliated with, authorised, sponsored or endorsed by Microsoft. Microsoft, Power BI and PL-300 are trademarks of their respective owners and are used solely descriptively.
Editorial lead: KINTAVOR editorial team · Educational product management · Content updated: 2026-09-15.