Tutorials: Load

INTRODUCTION TO LEANALYSER

This is an introduction to LEANalyser, an in-memory based self service analytics tool that suits both the part time and professional analysts. It gives you an overview of the work flow in the tool when loading, preparing and analysing data.

Data used in the tutorial:

HOW TO ACHIEVE ANALYSIS FLOW?

The three different modes within LEANalyser, Load – Prepare – Analyse, take the user from the import of data to the complete analysis. By enabling alla steps of the analysis process within one single tool, a state of flow can be obtained.

Data used in the tutorial:

CONNECTING TO DATABASES

In this tutorial you will learn how to connect LEANalyser to an external database, for instance a SQL server. It will explain how the tool interprets SQL syntax and how to export wrangled data back to the server. 

LOAD TRANSACTIONS

This tutorial will go through some advanced load functionality within LEANalyser. It will explain how to automatically add new transactions into already existing tables via so called actions.

TRANSPOSE & UNPIVOT

In this tutorial you will learn the importance of structure in tables. To be able to modify a structure, two functions will be used: transpose and unpivot. 

Data used in the tutorial:

IMPORTING DATA FROM EXCEL

In this tutorial you will learn how to import Excel files into LEANalyser.

Data used in the tutorial:

IMPORTING DATA FROM EXCEL - ADVANCED

In this tutorial you will learn how to import Excel files into LEANalyser and how to automate the process.

Data used in the tutorial:

Close Menu