KINTAVORProfessional Data Analyst

KINTAVOR · Private, self-paced training

Excel, SQL, Power BI and applied AI · Four portfolio projects · Independent PL-300 pathway

Turn business data into clear decisions.

Learn Excel, SQL, Power Query, modelling, DAX and Power BI by building four portfolio projects.

An online, self-paced pathway without videos, from foundations to dashboards, security, applied AI and independent PL-300 preparation.

Explore the programmeCreate my first dashboard for free

78 estimated hours with the bonus (76 h 50 min without the optional bonus) · 12 months of access · One-off payment · No live classes

Professional analyst comparing dashboards and a star schema on two monitors
You will learn to clean, query, model, visualise and explain data with evidence.
56complete lessons
120automatically marked practice activities
8 + 2assessments and mock exams
4portfolio projects

Analysis is not about decorating charts.

You will start with a business question, check data quality, choose the level of detail and justify every KPI, relationship, measure and visual.

The aim is to produce reproducible analyses, explain their limitations and propose reasonable actions. The training does not promise employment or present itself as training to become a Data Scientist.

Data qualityExcel and SQLETLStar schemaDAXStorytelling

A complete pathway, with no hidden gaps.

Fourteen blocks connect explanations, business examples, procedures, practice, assessment and projects. The Python/Pandas bonus is optional.

  1. 01

    Start with sound judgement

    1. 00 · Orientation and diagnostic assessment
      Campus, technical requirements, diagnostic, study plan and portfolio.
    2. 01 · Analytical thinking and KPIs
      Business questions, metrics, context, quality and bias.
  2. 02

    Work with data

    1. 02 · Excel for analysis
      Tables, cleaning, formulae, lookups, dates, pivot tables and charts.
    2. 03 · SQL from scratch
      SELECT, filters, aggregation, JOIN, CTEs, window functions and business queries.
  3. 03

    Transform and model

    1. 04 · Power Query and ETL
      Profiling, transformations, appending, merging, parameters and the M language.
    2. 05 · Data modelling
      Granularity, cardinality, star schema, calendar and performance.
  4. 04

    Calculate and visualise

    1. 06 · DAX
      Contexts, CALCULATE, filters, time, running totals and debugging.
    2. 07 · Power BI and dashboards
      Visuals, interaction, navigation, mobile, accessibility and performance.
  5. 05

    Publish and secure

    1. 08 · Analysis and storytelling
      Trends, anomalies, forecasting, hierarchy and recommendations.
    2. 09 · Power BI Service and security
      Publishing, updates, permissions, RLS and governance.
  6. 06

    Communicate and prepare

    1. 10 · Applied AI
      Assisted SQL and DAX, verification, privacy and Copilot.
    2. 11 · Portfolio and interviews
      Documentation, presenting decisions, CV and cases.
  7. 07

    Expand your toolkit

    1. 12 · Independent PL-300 pathway
      Current domains, mock exams and a six-week plan.
    2. B · Python and Pandas bonus
      Reading, cleaning, grouping, combining and exporting.

Unsure where to start? The free 25-question diagnostic suggests priorities by competency.

Take the diagnostic

Honest automated marking.

The platform validates only what it can safely check: choices, matches, orders, figures, normalised formulae within a limited grammar and structured configurations.

It is not presented as a complete DAX or Power Query engine and never promises to mark a PBIX automatically.

SQL queries run on a disposable synthetic database inside the browser, never against production MySQL.

20
isolated SQL practice activities
20
structured DAX practice activities
16
Power Query practice activities
64
practice activities for the other competencies

Four complete business cases.

Each project includes valid CSV and XLSX files, a dictionary, quality issues, indicative SQL, Power Query, a model, DAX measures, a wireframe, rubric, solution and portfolio text. No unverified PBIX is included.

  1. 01

    Retail sales

    Sales, products, synthetic customers, sales representatives, targets and returns.

  2. 02

    Finance

    Budget versus actuals, profit and loss statement and variances.

  3. 03

    Marketing

    Campaigns, spending, leads, conversion, CAC, ROAS and basic attribution.

  4. 04

    Logistics and transport

    Shipments, routes, vehicles, costs, incidents, punctuality and OTIF.

Explore the projects

Projects are built on your computer.

Download the datasets, work in Excel, an SQL editor and Power BI Desktop, and record verifiable checkpoints in the campus.

The platform does not execute arbitrary code, macros or PBIX files. The included XLSX files are genuine and contain no macros.

  1. 1
    AuditQuality, types and granularity
  2. 2
    TransformExcel, SQL and Power Query
  3. 3
    ModelRelationships and DAX measures
  4. 4
    CommunicateDashboard, insights and limitations
Professional checking a table's data quality before creating a dashboard

Start for free: create your first dashboard from Excel.

Three lessons, an original dataset and a guided activity to prepare the table, calculate indicators and present a visible result.

  • 45–60 minutes
  • Downloadable CSV and XLSX
  • Four control results
  • No card required
Open the mini course

Optional AI tutor, with visible limits.

When the administrator configures OpenAI, the tutor uses validated course content, cites verified sources and requires diagnosis and hints before a minimal solution.

It can explain SQL and DAX, document a model and highlight possible errors, but does not claim a project is correct without evidence.

It does not receive sensitive data, reveal keys or replace actual validation. If unconfigured or the API fails, it shows an alternative based on lessons and hints.

PL-300 pathway aligned with the current guide.

The version effective from 20 April 2026 divides the exam into preparing data, modelling, visualising and analysing, and managing and securing Power BI.

Includes an administrative objectives matrix, two original 50-question mock exams and a six-week plan. They are an educational approximation: KINTAVOR does not know or reproduce real exam questions.

View the independent preparation

A technical requirement to know before paying.

Power BI Desktop requires a compatible Windows system. There is no full native version for macOS.

If you use a Mac, you must provide your own Windows computer, compatible virtual machine or remote access. KINTAVOR does not include or guarantee third-party virtualisation configurations.

KINTAVOR does not include Windows, Microsoft 365, Excel, Power BI Pro or other licences. Power BI Service, collaboration, publishing or Copilot may require a Microsoft account, licence or capacity. The PL-300 exam is booked and paid for separately.

Read all technical requirements

Transparency about testimonials.

The initial version does not publish testimonials because it has no verified reviews from real students.

We do not invent names, companies, pass rates or employment outcomes. To assess the approach, you can review the mini course, complete the diagnostic and consult the exact inventory.

Try the approach with the mini course

One-off payment. Twelve months of access.

Complete course, datasets, practice activities, assessments, projects, mock exams, version updates and a private certificate of completion.

£83.24launch price£126.15 standard price
  • No subscription or automatic renewal
  • One account and one main browser
  • PL-300 exam and licences not included
  • Private certificate, not a Microsoft certificate
Review requirements and purchase

Before Stripe, you must confirm Windows, licences and the exam.

Private, independent training.

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.

The KINTAVOR certificate is private. Employment, salary, passing the exam or obtaining official certification are not guaranteed.

Frequently asked questions

Essential information before deciding.

Can I start from scratch?

Yes. The pathway starts with analytical thinking and data structure before progressing to SQL, Power Query, modelling, DAX and Power BI. It is not an advanced Data Science course.

Do I need Windows?

Power BI Desktop requires a compatible Windows system. There is no complete native version for macOS. If you use a Mac, you must provide your own Windows computer, compatible virtual machine or remote Windows access.

Are licences included?

No. KINTAVOR does not include Windows, Microsoft 365, Excel, Power BI Pro or other licences. Service, collaboration, publishing or Copilot may require a Microsoft account, licence or capacity.

Is the PL-300 exam included?

No. The official PL-300 exam is booked and paid for separately. The KINTAVOR pathway is private, independent preparation.

Does the course have videos or live classes?

No. Version 1.0 is self-paced and has no videos: written lessons, diagrams, datasets, practice activities, assessments, projects and mock exams.

Is a PBIX file marked automatically?

No. PHP does not inspect PBIX files. Projects are tracked through checkpoints, control values, structured answers and rubrics.

What does the AI tutor do?

When configured, it offers a lesson-based sequence of diagnosis and hints, with verified citations. It does not independently validate a project, and the campus keeps working if the API fails.

Is the certificate official?

No. It is a private KINTAVOR certificate of completion. It is not Microsoft certification, does not replace PL-300 and does not guarantee employment or an exam pass.