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
  • Creating simple and crosstabs.
  • Basic actions and properties of simple and crosstabs.
  • Converting crosstab to chart.
  • Chart type.
  • Creating a chart with the "Instant Chart" wizard.
  • Creating a chart with the "Full Chart" wizard
  • Basic actions and graph properties.
  • Exercise: rnPractical exercises for creating interactive tables and graphs.
• 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.