ISO 29993 logo
Data and Automation

Data Analysis with AI

AI as an acceleration layer on top of Excel, Power BI and analysis tools.

An intensive 8-hour programme for people who already analyse data and want to use AI to explore, document, generate DAX and automate recurring analysis safely.

In person or live online8 hoursOpen enrolment and in companyUp to 25 participants per classApriori certificate
Book my spot Request a corporate proposal
Duration
8 hours
Modality
Hybrid
Format
Individual and Corporate
Level
Advanced
Who this training is for

For people who analyse data and need more speed.

An intensive programme for analytical profiles already working with Excel and Power BI who want to add AI as a speed layer, without losing rigour or control over the data.

Applicable to
  • Data and business analysts
  • Controllers and planning teams
  • Reporting and BI leads
  • Finance teams with recurring analysis
  • Managers who produce their own analysis
The problem it solves

Much of an analysis team's time is consumed by mechanical tasks: exploring new tables, documenting fields, writing formulas and repeating the same analysis every month.

Meanwhile management questions wait, and the analysis arrives too late to influence the decision.

AI comes in as an accelerator: it explores data faster, generates and validates DAX code, suggests hypotheses and automates what repeats, always with human validation.

Prerequisites

Basic knowledge of AI.

Skills developed
AI for data exploration
Assisted documentation of databases and fields
AI for generating DAX code
Critical validation of results
Faster analysis in Excel
Automation of recurring analysis
Detecting anomalies and patterns
Good practice with sensitive data
Programme

Training programme

01

AI applied to analysis

Where AI genuinely accelerates analytical work and where it should not be used.

02

AI and Excel

Exploring, cleaning and building formulas with the support of AI assistants.

03

AI, Power BI and DAX

Generating, explaining and validating DAX measures and speeding up model documentation.

04

Automation and analytical agents

Automating recurring analysis and alerts on critical indicators.

Practical, hands-on methodology

The programme runs on real cases with anonymised data, focused on immediate analytical productivity.

Every technique comes with a validation step, so the speed of AI never compromises the reliability of the analysis.

Tools and resources
ExcelPower BIAI assistants
What happens in the room
  • Real cases with anonymised data
  • Assisted exploration of unfamiliar databases
  • DAX generation and validation
  • Automating a recurring analysis
  • Rules for handling sensitive data
  • Result validation checklist
Certification

Apriori certificate of attendance

Trainer

Carlos Araújo

Expected outcomes

What the company gains.

Analysis delivered in less time
Less mechanical work in data exploration
DAX measures created and documented faster
Recurring analysis automated
Clear criteria for validating results
Safe handling of sensitive data
Deliverables

What is included in the programme.

  • Delivery of the programme, in person or live online
  • Support material and exercise datasets
  • A library of analytical prompts
  • An example of automated analysis
  • Apriori certificate of attendance
  • Post-training executive report when contracted as a corporate programme

Speed up your analysis without losing rigour.

Book your place or request an in company proposal with cases built on your company's own data.

Book my placeRequest a corporate proposal