Description

This internship will allow you to use the main functionalities of QlikView, a very effective Business Intelligence tool. In particular, it will teach you how to create a QlikView application from text files or a relational database.

Who is this training for ?

For whom ?

Consultants, developers, analysts and business experts, project management assistants.

Prerequisites

Training objectives

Navigate the QlikView application

Load data into QlikView

Manage sheets in a QlikView document

Manipulate sheet objects to choose or render data

Organize objects on the sheet

Create a chart to highlight the data

Training program

• Introduction
  • - Qliktech company overview.
  • - Overview of QlikView features and benefits.
  • - Demo Use case examples.
• Basic manipulation of a Qlikview application
  • - Presentation of the interface.
  • - QlikView principle and terminology.
  • - Opening existing documents.
  • - Manipulating data by combinations of selections .
  • - Perform a search for values ​​or texts.
  • - Adding favorites.
  • - Saving documents.
  • - Export data to a file.
  • - Exercise: Practical exercises for handling existing files.
• Editing documents
  • - Addition of sheet and properties of a sheet, links between sheets.
  • - Addition of descriptive text object, addition of a selection list.
  • - Properties selection lists, format, sort.
  • - Addition of a statistics zone.
  • - Addition of a multiple list.
  • - Addition of a zone table.
  • - Basic action on sheet objects (adding, modifying, formatting).
  • - Using the "Design" toolbar.
  • - Exercise: Practical exercises for enriching QlikView documents.
• Data representation

  - n'as pas encore du programme

• Getting started with loading data
  • - Principle of loading data into QlikView.
  • - Creation of a QlikView document from data in a text file or a table in a relational database.
  • - Adding a second file and impact on the document.
  • - Using the table viewer.
  • - Managing model fields and basic actions.
  • - Exercise: Exercises for creating a QlikView application from a file and a relational connection.
• Conclusion
  • - What to remember? Go further with QlikView.