Skip to content
Sidéral Technologies

Data Analyst Essentials

From Excel structure to a Power BI dashboard.

A progressive path to trust data, automate preparation and report to decide.

Organize training in my company

Objective

  • Trust the data
  • Automate preparation
  • Report to decide

Who it is for

Business, control, analysts

  • Business teams
  • Control
  • Analysts

Outcome skills

  • Structure Excel
  • Transform with Power Query
  • Build a dashboard
  • Tell the data story

Progression

  1. Start

    Start

  2. M1

    Excel

  3. M2

    Power Query

  4. M3

    Power BI

  5. M4

    Data Storytelling

  6. Practice

    Reporting case

  7. Project

    Capstone dashboard

  8. Outcome

    Actionable reporting

Included trainings

  • Excel & productivityIntermediate

    Advanced Excel & automation

    Structure, clean and automate Excel files for reliable reporting.

    3 days / 21 hours · In person · Remote · In-company

    Controllers

    • Import and clean data
    • Transform with Power Query
    • Build a simple model
    View training
  • Data & BIIntermediate

    Power BI — from data to dashboard

    Go from a data extract to a readable, actionable Power BI dashboard.

    3 days / 21 hours · In person · Remote · In-company

    Analysts

    • Import data
    • Transform
    • Build a model
    View training
Duration
Progressive path · 4 weeks
Format
In-company · Hybrid
Assessment
Capstone dashboard and short review.
  • Structured files
  • Automatable reporting
  • Readable dashboard

Want to train several team members?

We build an in-company program from your roles, tools and objectives.

Organize training in my company