Course : QlikView DesignerBusiness intelligence and data visualization
Practical course - 2d
- 14h00 - Ref. LIE
|
Download in PDF format
Share this course by email
 | Navigating the QlikView application |
| Loading data into QlikView |
| Managing sheets in a QlikView document |
| Manipulate sheet objects to select or display data |
| Organizing objects on the sheet |
| Create a graph to highlight data |
Intended audience
Consultants, developers, business analysts and experts, project management assistants.
Prerequisites
No special knowledge required.
Practical details
Teaching methods
Learn how to manipulate data and enrich documents by creating crosstabs or graphs in QlikView.
Course schedule
1 Introduction
- Introducing Qliktech.
- Overview of QlikView features and benefits.
Demonstration
Examples of use cases.
2 Basic handling of a QlikView application
- Interface presentation.
- QlikView principles and terminology.
- Open existing documents.
- Manipulate data using combinations of selections.
- Search for values or texts.
- Add favorites.
- Document registration.
- Export data to a file.
Exercise
Practical exercises to manipulate existing files.
3 Document editing
- Add sheet and sheet properties, links between sheets.
- Add descriptive text object, add selection list.
- Selection list properties, format, sorting.
- Statistics area added.
- Add a multiple list.
- Addition of a table zone.
- Basic action on sheet objects (add, modify, format).
- Using the toolbar "Design".
Exercise
Practical exercises in enriching QlikView documents.
4 Data representation
- Create simple tables and crosstabs.
- Basic actions and properties of simple and crosstab tables.
- Convert pivot tables to graphs.
- Graphic type.
- Create a chart with the "Instant chart" wizard.
- Create a graph with the "Complete graph" wizard.
- Basic actions and chart properties.
Exercise
Practical exercises to create interactive charts and graphs.
5 Getting started with data loading
- How to load data into QlikView.
- Create a QlikView document from data in a text file or a table in a relational database.
- Addition of a second file and impact on the document.
- Use the table viewer.
- Managing model fields and basic actions.
Exercise
Exercises in creating a QlikView application from a file and a relational connection.
6 Conclusion
- What should we remember?
- Going further with QlikView.
PARTICIPANTS
Consultants, developers, business analysts and experts, project management assistants.
PREREQUISITES
No special knowledge required.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Consultants, developers, business analysts and experts, project management assistants.
PREREQUISITES
No special knowledge required.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.