Mydral_dataacademy_Blanc

Mydral Data Academy is a training centre with expert consultants. Our expertise is built on more than 10 years of projects for clients, at the heart of creating value from data.

By training with Mydral, you get 360° training to transform your company, and solid skills to easily use and analyse your data.

picto

Complete
training paths for
all levels

picto

+4000
Data analysts/
scientists trained

picto

Learn from our experts

picto

Hands-on exercises and tips

picto

In French and in English

picto

On site or remote

YOUR PATHS TO SUCCESS

We have the solution! Practical and effective, our training paths on Tableau and Knime are comprehensive and varied, to help you become Data experts. Our range includes courses to learn the basics or to deepen your expertise. The Data Academy brings together our best experts to support you during the training. You will have all the keys to transform your company through analytics.

Logo Tableau
Logo knime
Logo Tableau
Tableau data analyste
Tableau data prep
Tableau data engineer
Tableau visual
Tableau server

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

This module is for anyone in the company who produces reports in Tableau Software. It covers how to use data from various sources and offers different customisation and optimisation methods. The module ends with a lesson on publishing data to a server.

DATA IMPORT AND MANIPULATION

This section covers importing data into Tableau Software from various sources and mastering the different ways of working with it:

  • Excel connections, Access databases, flat files and web page content
  • Turning measures into dimensions
  • Working with geographic and time data

OPTIMISING ANALYSES

The different techniques for optimising analyses in Tableau applications:

  • Selection on a report
  • Time dimensions
  • Creating hierarchies

GRAPHICAL OPTIMISATION

Users will learn how to apply different graphical optimisations using the calculated fields available in Tableau Software.

FORMATTING YOUR WORKFLOWS

To avoid the tedious documentation step, we will see how to format and describe each process:

  • Using comments

DATA EXPORT

The training ends with two modules on data sharing.

  • Storytelling
  • Building advanced dashboards (filters, actions, etc.)

Fr | En - 2 days

↑

↑

For anyone in the company who will use Tableau PREP, this training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data formats.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Tableau PREP works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Filtering results
  • Running calculations
  • Cleaning data

DATA ENRICHMENT

In this section, you will get familiar with joins to enrich your data, and with data formatting

  • Joins
  • Data preparation and formatting

FORMATTING YOUR WORKFLOWS

To avoid the tedious documentation step, we will see how to format and describe each process:

  • Using comments

DATA EXPORT

In this section, users will go through the different ways to export data to various formats

  • Tableau Data Extract
  • Hyper
  • Tableau Server

Fr | En - 1 day

When presenting figures, an activity analysis or reporting, presenting information well matters as much as presenting accurate information. This module will help you improve the usability and presentation of your Tableau Software applications with Good Visualisation techniques.

GRAPHIC PRINCIPLES

This section lays the foundations of visualisation techniques. The key points of graphical representation are covered:

  • Principles of visual perception
  • Managing graphic guidelines
  • Layout concepts / proportions

USING GRAPHIC THEMES

In Tableau Software, you can use graphic themes and apply corporate brand guidelines. This module explains how to make the most of them in Tableau Software.

PLACING OBJECTS

This module gives trainees best practices for laying out navigation, display and analysis objects within a Tableau Software sheet.

SCREEN AND BANNER LAYOUT

In screen design, it is important to separate banners from the screen areas used for navigation and for displaying analysis results. This section presents best practices in this area.

USING FONTS AND COLOURS

For an application to be pleasant to use, colours and fonts need to be in harmony. An overly glossy application can put off a corporate audience, and high contrast can cause headaches. This section shares the latest academic research on human vision with trainees.

SCRIPTING THE STORY

Just like in cinema, a Tableau Software application should tell a story, with a beginning and an end. Film techniques serve the presentation (storytelling, scripting & an introduction to corporate data journalism).

Fr | En - 1 day

When presenting figures, an activity analysis or reporting, presenting information well matters as much as presenting accurate information. This module will help you improve the usability and presentation of your Tableau Software applications with Good Visualisation techniques.

GRAPHIC PRINCIPLES

This section lays the foundations of visualisation techniques. The key points of graphical representation are covered:

  • Principles of visual perception
  • Managing graphic guidelines
  • Layout concepts / proportions

USING GRAPHIC THEMES

In Tableau Software, you can use graphic themes and apply corporate brand guidelines. This module explains how to make the most of them in Tableau Software.

PLACING OBJECTS

This module gives trainees best practices for laying out navigation, display and analysis objects within a Tableau Software sheet.

SCREEN AND BANNER LAYOUT

In screen design, it is important to separate banners from the screen areas used for navigation and for displaying analysis results. This section presents best practices in this area.

USING FONTS AND COLOURS

For an application to be pleasant to use, colours and fonts need to be in harmony. An overly glossy application can put off a corporate audience, and high contrast can cause headaches. This section shares the latest academic research on human vision with trainees.

SCRIPTING THE STORY

Just like in cinema, a Tableau Software application should tell a story, with a beginning and an end. Film techniques serve the presentation (storytelling, scripting & an introduction to corporate data journalism).

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

↑

↑

↑

↑

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

↑

↑

↑

↑

↑

For anyone in the company who will use Tableau PREP, this training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data formats.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Tableau PREP works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Filtering results
  • Running calculations
  • Cleaning data

DATA ENRICHMENT

In this section, you will get familiar with joins to enrich your data, and with data formatting

  • Joins
  • Data preparation and formatting

FORMATTING YOUR WORKFLOWS

To avoid the tedious documentation step, we will see how to format and describe each process:

  • Using comments

DATA EXPORT

In this section, users will go through the different ways to export data to various formats

  • Tableau Data Extract
  • Hyper
  • Tableau Server

Fr | En - 1 day

For anyone in the company who will use Tableau PREP, this training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data formats.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Tableau PREP works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Filtering results
  • Running calculations
  • Cleaning data

DATA ENRICHMENT

In this section, you will get familiar with joins to enrich your data, and with data formatting

  • Joins
  • Data preparation and formatting

FORMATTING YOUR WORKFLOWS

To avoid the tedious documentation step, we will see how to format and describe each process:

  • Using comments

DATA EXPORT

In this section, users will go through the different ways to export data to various formats

  • Tableau Data Extract
  • Hyper
  • Tableau Server

Fr | En - 1 day

For anyone in the company who will use Tableau PREP, this training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data formats.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Tableau PREP works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Filtering results
  • Running calculations
  • Cleaning data

DATA ENRICHMENT

In this section, you will get familiar with joins to enrich your data, and with data formatting

  • Joins
  • Data preparation and formatting

FORMATTING YOUR WORKFLOWS

To avoid the tedious documentation step, we will see how to format and describe each process:

  • Using comments

DATA EXPORT

In this section, users will go through the different ways to export data to various formats

  • Tableau Data Extract
  • Hyper
  • Tableau Server

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

This one-day module is for anyone in the company who will use TABLEAU SOFTWARE and needs to master its core functions. It lets users explore and analyse data, and easily share dashboards in a visual and interactive format.

DATA MANAGEMENT AND BASICS

To understand how Tableau Software works, you need to work with the tool’s core concepts. This section gives users the following hands-on skills:

  • Drag and drop
  • Grouping data
  • Principles of graphical representation
  • Managing dimensions and measures

BASIC FUNCTIONS AND FILTERING METHODS

This section helps you get familiar with Tableau Software’s functions and learn filtering techniques to take your analysis further.

  • Aggregating measures
  • Using calculated fields
  • Using hierarchies
  • Filtering in tables or charts

USING « Show Me »

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

Users will learn how to apply different customisations in Tableau Software. The following topics are covered:

  • Data formatting
  • Fonts and colours
  • Adding text or labels
  • Zoom/Drill down

EXPORT

The different ways to export data and share dashboards:

  • Dashboarding
  • Package Workbook (.twbx)
  • Other formats: PDF, XLS

Fr | En - 1 day

Logo knime
Knime Data prep
Knime Engineer
Knime Data Analyst
Knime Scientist
Knime Server administrator

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 1 day

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 1 day

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 1 day

↑

↑

↑

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source.

DATA IMPORT

In this section, you will learn how to import data:

  • From files
  • From the web (using web services)

And how to manage paths with « Workflow Dependencies »

DATA CLEANING

To better understand how Knime works, you need to work with its concepts. This section shows you how to clean data:

  • Dynamic renaming
  • Data Cleansing
  • Advanced formulas (If, left, regex…)

DATA ENRICHMENT

To cross-reference your analyses, in this section you will work on analytical enrichment techniques:

  • Multiple joins
  • Cross Tab / Transpose
  • Generate rows
  • Distance calculation (geospatial)

USING MACROS

Knime metanodes let you encapsulate, simplify and modularise your workflows. In this section, you will learn the various features of the interface menu:

  • Loop
  • Flow variable
  • Widget

EXPORT / PUBLISHING

In this section, you will go through the different ways to export data:

  • To various formats

You will also learn how to:

  • Publish a workflow to the server
  • Automate / schedule its execution

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source.

DATA IMPORT

In this section, you will learn how to import data:

  • From files
  • From the web (using web services)

And how to manage paths with « Workflow Dependencies »

DATA CLEANING

To better understand how Knime works, you need to work with its concepts. This section shows you how to clean data:

  • Dynamic renaming
  • Data Cleansing
  • Advanced formulas (If, left, regex…)

DATA ENRICHMENT

To cross-reference your analyses, in this section you will work on analytical enrichment techniques:

  • Multiple joins
  • Cross Tab / Transpose
  • Generate rows
  • Distance calculation (geospatial)

USING MACROS

Knime metanodes let you encapsulate, simplify and modularise your workflows. In this section, you will learn the various features of the interface menu:

  • Loop
  • Flow variable
  • Widget

EXPORT / PUBLISHING

In this section, you will go through the different ways to export data:

  • To various formats

You will also learn how to:

  • Publish a workflow to the server
  • Automate / schedule its execution

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source.

DATA IMPORT

In this section, you will learn how to import data:

  • From files
  • From the web (using web services)

And how to manage paths with « Workflow Dependencies »

DATA CLEANING

To better understand how Knime works, you need to work with its concepts. This section shows you how to clean data:

  • Dynamic renaming
  • Data Cleansing
  • Advanced formulas (If, left, regex…)

DATA ENRICHMENT

To cross-reference your analyses, in this section you will work on analytical enrichment techniques:

  • Multiple joins
  • Cross Tab / Transpose
  • Generate rows
  • Distance calculation (geospatial)

USING MACROS

Knime metanodes let you encapsulate, simplify and modularise your workflows. In this section, you will learn the various features of the interface menu:

  • Loop
  • Flow variable
  • Widget

EXPORT / PUBLISHING

In this section, you will go through the different ways to export data:

  • To various formats

You will also learn how to:

  • Publish a workflow to the server
  • Automate / schedule its execution

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source.

DATA IMPORT

In this section, you will learn how to import data:

  • From files
  • From the web (using web services)

And how to manage paths with « Workflow Dependencies »

DATA CLEANING

To better understand how Knime works, you need to work with its concepts. This section shows you how to clean data:

  • Dynamic renaming
  • Data Cleansing
  • Advanced formulas (If, left, regex…)

DATA ENRICHMENT

To cross-reference your analyses, in this section you will work on analytical enrichment techniques:

  • Multiple joins
  • Cross Tab / Transpose
  • Generate rows
  • Distance calculation (geospatial)

USING MACROS

Knime metanodes let you encapsulate, simplify and modularise your workflows. In this section, you will learn the various features of the interface menu:

  • Loop
  • Flow variable
  • Widget

EXPORT / PUBLISHING

In this section, you will go through the different ways to export data:

  • To various formats

You will also learn how to:

  • Publish a workflow to the server
  • Automate / schedule its execution

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source.

DATA IMPORT

In this section, you will learn how to import data:

  • From files
  • From the web (using web services)

And how to manage paths with « Workflow Dependencies »

DATA CLEANING

To better understand how Knime works, you need to work with its concepts. This section shows you how to clean data:

  • Dynamic renaming
  • Data Cleansing
  • Advanced formulas (If, left, regex…)

DATA ENRICHMENT

To cross-reference your analyses, in this section you will work on analytical enrichment techniques:

  • Multiple joins
  • Cross Tab / Transpose
  • Generate rows
  • Distance calculation (geospatial)

USING MACROS

Knime metanodes let you encapsulate, simplify and modularise your workflows. In this section, you will learn the various features of the interface menu:

  • Loop
  • Flow variable
  • Widget

EXPORT / PUBLISHING

In this section, you will go through the different ways to export data:

  • To various formats

You will also learn how to:

  • Publish a workflow to the server
  • Automate / schedule its execution

Fr | En - 2 days

↑

↑

↑

↑

↑

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 2 days

For anyone in the company who will use Knime. This training shows how to rebuild your company’s business processes with just the mouse, and how to connect to any data source. Results can be saved directly in Tableau’s native data format (TDE) or Hyper.

DATA IMPORT

In this section, users will learn how to import data from an EXCEL file:

  • Exploring the interface
  • Importing data
  • Documenting the process

BASICS

To better understand how Knime works, you need to work with its concepts. This section gives users the following hands-on skills:

  • Sorting results
  • Filtering results
  • Running calculations
  • Cleaning data

FORMATTING WORKFLOWS

This section teaches you how to automatically detect the most suitable chart type for your data:

  • Principles of graphical representation
  • Using the « Show Me » assistant

CUSTOMISATION

In this section, you will get familiar with joins to enrich your data, and with data formatting:

  • Joins
  • Data preparation and formatting
  • Date formatting box

EXPORT

In this section, users will go through the different ways to export data:

  • To various formats
  • With various options (overwrite the file, incremental, etc.)

Fr | En - 2 days

Image de mise en avant

DISCOVER OUR TRAINING COURSES 


Do you think our training courses could help you in your day-to-day work?

We are here for all your requests: our full training offer starts at €1,500 per day for in-house sessions and €550 per day for inter-company sessions.

Fill in our form today to choose your learning path, and we will get back to you quickly.

Certifications

Since 2020, the Mydral Data Academy training organisation has been certified Qualiopi and listed on Datadock.

Qualiopi which serves as a quality certification in the training sector.

Qualiopi logo

Quality approach & results

Through a continuous improvement plan, Mydral constantly evolves its learning paths, develops its trainers’ skills and strengthens its expertise as the field evolves.

Our satisfaction indicators are updated once a year, based on trainee evaluation questionnaires and surveys of our clients.

Details of these indicators are available on request.

CLIENT STORY

REX Philippe Minier Kaufman & Broad

Meet Philippe MINNIER, Chief Information Officer at KAUFMAN & BROAD, who chose Mydral to train his employees.

<< The Mydral training was very informative. The consultant listened to usand adapted to our pace and needs. Through clear examples and precise ones, we upskilled quickly >>

DATA ACADEMY TRAINING BODY

Quality approach & results

Through a continuous improvement plan, Mydral constantly evolves its learning paths, develops its trainers’ skills and strengthens its expertise as the field evolves.

Our satisfaction indicators are updated once a year, based on trainee evaluation questionnaires and surveys of our clients.

Details of these indicators are available on request.

CLIENT STORY

REX Philippe Minier Kaufman & Broad

Meet Philippe MINNIER, Chief Information Officer at KAUFMAN & BROAD, who chose Mydral to train his employees.

<< The Mydral training was very informative. The consultant listened to usand adapted to our pace and needs. Through clear examples and precise ones, we upskilled quickly >>

DATA ACADEMY TRAINING BODY