qlikview by anis rebai

QlikView Training Course Guide Training Courses Version 9.0

Contents

Introduction to this guide .................................................................................................... 2 QlikView Designer I Version 9.0 ....................................................................................... 3 QlikView Designer II Version 9.0 ...................................................................................... 4 QlikView Developer I Version 9.0 ..................................................................................... 5 QlikView Developer II Version 9.0 .................................................................................... 6 QlikView Developer III Version 9.0 .................................................................................. 7 What’s New in Version 9.0 ................................................................................................. 8 System Management - Document Manager QlikView Version 9.0 ................................... 9 System Management - Enterprise Deployment QlikView Version 9.0 ............................ 10 SAP Connector.................................................................................................................. 11 E-learning Build your first QlikView ............................................................................... 12 E-learning QlikView Version 9.0 for End-Users .............................................................. 13 E-learning System Management - Overview .................................................................... 14 E-learning QlikView Designer I Version 9.0 ................................................................... 15 E-learning QlikView Developer I Version 9.0 ................................................................. 16

Page 1

Introduction to this guide This catalogue is a guide to the many training courses that QlikTech can offer. The purpose is to help and guide users in choosing the right course. Each course has a short overview, duration, any prerequisites, and the content of the course, and the objectives of the course, as well as the version of QlikView. It also recommends the typical user for the courses, such as System Administrators. The courses are broken down in a mix of classroom courses and e‐learning courses.

Page 2

QlikView Designer I Version 9.0 Course Description: QlikView Designer I is an introduction course. The course structure is a mixture of demonstrations and hands on exercises of the many QlikView components. Topics covered in this course, include fundamental user interface layout and design best practices, based on Stephen Few’s design recommendations. QlikView Designer I also covers how to create a QlikView application and objects such as sheets, list boxes and charts. All the basic knowledge required to get started with QlikView.

Total Duration: 1 day

Recommended Prerequisite Course(s): No special prerequisites

Who should attend: Business Analysts, Designers, Project Managers, Developers & End‐Users

Course Outline: ¾ Short introduction to QlikTech and QlikView. ¾ Layout and best application design practices. What should you think about when designing an application? ¾ How to use QlikView Desktop. ¾ What is a sheet, sheet object, list box and a table box? ¾ How do we create the QlikView objects mentioned above, how do we use them, including examples such as sorting data, entering data, exporting data. ¾ You will learn about charts objects, how to create them and the many functionalities, how to edit the format and layout. ¾ How to load data into QlikView.

What will you learn: ¾ At the end of the course you will have a fair understanding of QlikView as a product. ¾ You will have a basic understanding of good application and user interface design. ¾ You will have knowledge of how to build an application using sheets and some of the common QlikView objects such as list boxes and table boxes. ¾ You will also know how to search and analyse data in existing applications.

Page 3

QlikView Designer II Version 9.0 Course Description: This course complements the learning in the QlikView Designer I. The course structure is a mixture of demonstrations and hands on exercises of the many QlikView components. QlikView Designer II takes students to the next level, focusing on the user interface design and delivers a more detailed knowledge on layout, design, best practices and reporting. The course focus is on giving good product knowledge, especially adding and modifying objects such as gauges, multidimensional charts, tables and other application objects.

Total Duration: 1 day

Recommended Prerequisite Course(s): QlikView Designer I

Who should attend: Business Analysts, Designers & Developers

Course Outline: ¾ Overview of QlikView Desktop. ¾ Introduction to multi dimensional objects such as pivot tables, straight tables with multiple expressions. ¾ Advanced usage of the many QlikView charts and objects, such as tree views in list boxes and mini charts. ¾ Advanced calculations using set analysis and AGGR function. ¾ Gauges, buttons, actions – what are they and how do you develop them. ¾ Introduction to some other useful objects such as slider/calendar objects. ¾ QlikView reports and how do you create and manage them. ¾ Business case workshop.

What will you learn: ¾ You will have a good understanding of application design, and the many issues to bear in mind when designing the user interface for an application in QlikView. ¾ You will be able to develop complex reports and use the more advanced objects in your application design. ¾ You should know when and how time based analysis can be useful to use. ¾ You will know how to develop gauges, buttons, use actions and build an application. ¾ At the end of the course you will have a good chance of practicing all your new skills in a real business case to build an application on your own.

Page 4

QlikView Developer I Version 9.0 Course Description: QlikView Developer I gives users a good start in how to develop applications in QlikView. The course content is a mixture of demonstrations and hands on exercises of the many QlikView components. The focus in this course is on the development side, learning about the script, best practices, loading data and how to deploy QlikView applications. It also covers data modelling and database connectivity.

Total Duration: 1 day

Recommended Prerequisite Course(s): QlikView Designer I It also highly recommended but not a prerequisite to have attended QlikView Designer II

Who should attend: Developers, Designers & Power End‐Users

Course Outline: ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾

The QlikView environment. Overview of QlikView development methodology, SAFE. How to deploy QlikView, standalone, Server and Publisher. Introduction to data and scripting, relational databases and other data structures. Connecting to ODBC and also OLEDB data sources. Introduction to the underlying scripting language and best practices in how to use this, including the use of time functions and creating variables. Overview of data preparation required before starting to develop a QlikView application. Basic data model overview and understanding of QlikView table viewer. How to resolve abnormalities in the data structure, such as synthetic keys. QlikView QVD file and how to create them and use them.

What will you learn: ¾ You will be able to navigate in the script editor, use functions, and write script as well as best practices on how to structure your scripts. ¾ How to use time specific functions and create variables. ¾ Understand the issues of data models and loading data into QlikView and resolving data structure abnormalities, and how to use the table viewer to view your data. ¾ You will have an idea of what the QlikView methodology SAFE means. ¾ Connecting to data sources using ODBC or OLEDB. ¾ You will know about QVD files, how to create them and use them. © 1996-2009 QlikTech International

Page 5

QlikView Developer II Version 9.0 Course Description: This course complements the learning in QlikView Developer I. The QlikView Developer II course structure is a mixture of demonstrations and hands on exercises, with the focus on advanced scripting and more complex data modelling issues. The course also includes a new business case study for students to practice their new found skills in building an application from scratch based on KPI’s.

Total Duration: 2 days

Recommended Prerequisite Course(s): QlikView Developer I

Who should attend: Developers

Course Outline: ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾

Learn about the debugger and troubleshooting. How to add text data and how to generate data in the QlikView script. Mapping tables and cleaning up a data structure. How to load budget data. Script language and how to aggregate data, joining tables, concatenation, functions, interval match and other scripting features. Analyze data over time using Set analysis and Aggr Function. Data model optimization and performance tuning and how to create incremental loads. Overview of QlikView security and various access settings and levels. Advanced database connectivity. To finish it off a case study ‐ each student gets to develop a QlikView application, which includes: loading in data, resolving data issues and building the UI with the help of business KPI.

What will you learn: ¾ You will have a good understanding of the scripting language used in QlikView, and how to load data into QlikView, and how to connect your application to a database. ¾ You will have a good understanding of resolving data structure issues. ¾ You will have a good overview of time based analysis, how to compare data over time using the very powerful set analysis techniques. ¾ You will know how to work with profit and loss issues. ¾ You will know of various functions, how to build advanced expressions as well as troubleshooting and using the debugger. ¾ You will also work on a case study to practice all your newfound QlikView skills. © 1996-2009 QlikTech International

Page 6

QlikView Developer III Version 9.0 Course Description: QlikView Developer III is an advanced workshop course. Through a combination of demonstrations and exercises, students will master scripting, data modeling, performance and design concepts to take their QlikView developer skills to the highest level. This course is recommended for QlikView Developers with at least six months hands‐on experience building QlikView applications.

Total Duration: 1 day

Recommended Prerequisite Course(s): Designer I, Designer II (recommended) Developer I, Developer II (required)

Who should attend: Senior QlikView Application Developers

Course Outline: ¾

Data Modelling in QlikView o QlikView Associated logic o Best practices o Point‐in‐time ¾ Expressions and Calculations o Advanced Set Analysis o Advanced AGGR o Hierarchies o Dynamic variables ¾ Performance and Design o Performance tuning o Development techniques

What will you learn: ¾

Upon completion, you will have hands‐on experience with the most important and useful advanced QlikView application development tools and functions ¾ You will have a solid understanding of data modeling and table integration approaches ¾ You will have a good grasp of performance tuning and techniques based on design and development best practices ¾ You will have grounded this knowledge in specific business‐case examples and sample data.

Page 7

What’s New in Version 9.0 Course Description: This course gives users a good understanding of new functionalities in QlikView version 9.0. The course is structured around six themes: Usability and Simplicity, Enterprise Manageability, Integrated Reporting, QlikView Everywhere, Developer Experience and Real Time Information. What’s new in Version 9.0 is a mixture of demonstrations and hands on exercises, but also updates and information on how version 9.0 is different, compared to earlier versions.

Total Duration: 1 day

Recommended Prerequisite Course(s): Previous QlikView knowledge is an advantage

Who should attend: QlikView users with knowledge of previous versions

Course Outline: ¾ Learn about the new display objects and graphs in version 9.0 such as mini charts, search objects, tree list box, clickable URL’s, how to change a background dynamically, trellis charts, how actions can be used to trigger different events, including document chaining. ¾ Real time information and the developer experience including the new table viewer, indirect set analysis and how the new Clear button can make life easier for the developers. ¾ We talk about the Enterprise manageability, and the new management consoles in the server/publisher part. ¾ How QlikView personal Edition is different.

What will you learn: ¾ You will know about the new objects that are part of the usability and simplicity theme in QlikView Version 9.0. ¾ You will know about the new enhanced and improved developer experience in QlikView Version 9.0. ¾ You will know about the Real time functionality. ¾ You will know about the Enterprise functionality changes in QlikView Version 9.0.

Page 8

System Management ‐ Document Manager QlikView Version 9.0 Course Description: QlikView System Management ‐ Document Manager focuses on managing QlikView Server and Publisher. Targeting the System Administrator responsible for the day‐to‐day set‐up, operation and on‐going management of the environment for the purpose of disseminating QlikView documents.

Total Duration: 1 day Recommended Prerequisite Course(s): System Management Overview (e‐Learning Course)

Who should attend: QlikView System Administrators

Course Outline: ¾ Understand and configure the QlikView Server environment ¾ Understand and deploy options and development methods ¾ Review the standard installation and upgrade process ¾ Review QlikView Server ¾ Review QlikView Publisher ¾ Review QlikView clients ¾ Explore the QlikView Enterprise Management Console in detail ¾ Introduce new capabilities, QlikView Server 9.00 ¾ Manage the QlikView document life‐cycle and dissemination What will you learn: This is a technical course for QlikView System Administrators. At the conclusion, you will have experience with (and a good understanding of): ¾ The QlikView environment ¾ The QlikView development process methodology ¾ QlikView deployment options ¾ QlikView Version 9.0 functionality and upgrading from previous versions ¾ The QlikView Enterprise Management Console ¾ The new capabilities of QlikView Server version 9.0 ¾ Hands‐on exercises covering the QlikView document life‐cycle and dissemination

Page 9

System Management ‐ Enterprise Deployment QlikView Version 9.0

Course Description: QlikView System Management ‐ Enterprise Deployment focuses on managing QlikView Server and Publsiher. Targeting the System Administrator responsible for the configuration, security and advanced scalability and connectivity of larger, more complex enterprise deployments.

Total Duration: 2 days

Recommended Prerequisite Course(s): System Management ‐ Document Manager

Who should attend: QlikView System Administrators, Enterprise

Course Outline: ¾ ¾ ¾ ¾ ¾ ¾ ¾

Explore computing environment considerations Explain security set‐up Introduce functional architecture and logging Understand the options for scaling the environment Define advanced QlikView Server Work through advanced installation and clustering architecture Monitor the QlikView Server environment

What will you learn: ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾

Computing environment considerations Security set‐up Functional architecture and logging Scaling the environment Working with QlikView Server Working with Publisher Advanced installation and clustering architecture Monitoring the Server environment

Page 10

SAP Connector Course Description: This one day course will give the participant hands on experience regarding the usage of and maintaining/administering the SAP Connector. Participants will train in a SAP environment using routine installation procedures etc.

Total Duration: 1 day

Recommended Prerequisite Course(s): No special prerequisites

Who should attend: This course is designed for QlikView Developers who will be involved in the deployment of QlikView in a SAP environment.

Course Outline: ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾ ¾

SAP Overview Connector overview Installation Guide Transactions ERP Security alternatives + SNC SQL connector Templates at QlikOpedia OLAP connector ODS Connector

What will you learn: ¾ By the end of this course you will be able to use, deploy and administer the QlikView SAP Connector.

Page 11

E‐learning Build your first QlikView Course Description: This e‐Learning course is a 30 minutes introduction to how to build your first QlikView application. The course structure is broken down into four modules, starting with processing data, loading data, building the end‐user interface and how to distribute QlikView documents within an organization.

Total Duration: 30 minutes

Recommended Prerequisite Course(s): No special prerequisites

Who should attend: Business Analysts, Project Managers, Designers & Developers

Course Outline: ¾ ¾ ¾ ¾ ¾ ¾ ¾

The process of creating a QlikView document. What to consider when listing requirements from a real life example. Extract data from a basic data source. Basic transformation of data in Script. Load the data into QlikView. Create a QlikView document interface. Ways of distributing a QlikView document in an organization.

What will you learn: ¾ You will learn the steps involved in building a QlikView application. ¾ You will learn how to extract data from a basic data source. ¾ You will have the knowledge of how to load data into QlikView and create a simple document user interface. ¾ You will also have a good understanding of how to distribute a document in an organization.

Page 12

E‐learning QlikView Version 9.0 for End‐Users Course Description: This e‐Learning course consists of three modules, starting with an overview of how QlikView works, how you navigate in QlikView and how you generate reports in QlikView. It is an excellent introduction for end‐users who want to learn to navigate and get started in QlikView.

Total Duration: 30 minutes

Recommended Prerequisite Course(s): No special prerequisites

Who should attend: End‐users

Course Outline: ¾ ¾ ¾ ¾ ¾

How to make a selection in QlikView. How to navigate in QlikView and using it to analyse your data. How to recognize and interact with common QlikView objects. How to use QlikView reporting. How to use the bookmark and alerts facility in QlikView.

What will you learn: ¾ You will know how to navigate and find your way round in a QlikView application and recognizing the most common objects and how to interact with them. ¾ You will know how to make a selection in QlikView. ¾ You will know how to use QlikView reporting. ¾ You will know how to use bookmark and alert facility in QlikView.

Page 13

E‐learning System Management ‐ Overview Course Description: This e‐Learning module gives an overview of QlikView Server and components in QlikView Version 9.0.

Total Duration: 20 minutes

Recommended Prerequisite Course(s): No special prerequisites

Who should attend: System Administrators & Document Managers

Course Outline: ¾ Overview of the QlikView suite with the different components and client options. ¾ Demo of Server standard edition.

After having gone through this e‐Learning module you will be able to: ¾ Give an overview of the QlikView suite. ¾ Run a standard installation of QlikView Server. ¾ List the components and their roles. ¾ List client options.

Page 14

E‐learning QlikView Designer I Version 9.0 Course Description: QlikView Designer I is an introduction course. The course structure is a mixture of demonstrations and hands on exercises of the many QlikView components. Topics covered in this course, include fundamental user interface layout and design best practices, based on Stephen Few’s design recommendations. QlikView Designer I also covers how to create a QlikView application and objects such as sheets, list boxes and charts. All the basic knowledge required to get started with QlikView.

Total Duration: 1 ½ hours e‐Learning 1½ hours exercises

Recommended Prerequisite Course(s): No special prerequisites

Who should attend: Business Analysts, Designers, Project Managers, Developers & End‐Users

Course Outline: ¾ ¾ ¾ ¾ ¾

Short introduction to QlikTech and QlikView. Layout and best application design practices. Guides for designing an application? How to use QlikView Desktop. What is a sheet, sheet object, list box and a table box? How do we create the QlikView objects mentioned above, how do we use them, including examples such as sorting data, entering data, exporting data. ¾ You will learn about charts objects, how to create them and the many functionalities, how to edit the format and layout. ¾ How to load data into QlikView.

What will you learn: ¾ At the end of the course you will have a fair understanding of QlikView as a product. ¾ You will have a basic understanding of good application design and user interface. ¾ You will have knowledge of how to build an application using sheets and some of the common QlikView objects such as list boxes and table boxes. ¾ You will also know how to search and analyse data in existing applications.

Page 15

E‐learning QlikView Developer I Version 9.0 Course Description: QlikView Developer I gives users a good start in how to develop applications in QlikView. The course content is a mixture of demonstrations and hands on exercises of the many QlikView components. The focus in this course is on the development side, learning about the script, best practices and loading data. It also covers data modelling and related issues such as database connectivity.

Total Duration: 2 hours e‐Learning + 2 hours exercises

Recommended Prerequisite Course(s): QlikView Designer I It also highly recommended but not a prerequisite to have attended QlikView Designer II

Who should attend: Developers, Designers & Power End‐Users

Course Outline: ¾ ¾ ¾ ¾

The QlikView environment. Introduction to data and scripting, relational databases and other data sources. Connecting to ODBC and also other OLEDB data sources. Introduction to the underlying scripting language and best practices in how to use this, including time functions and how to create variables. ¾ Overview of data preparation required before starting to develop a QlikView application. ¾ Basic data model overview and understanding of QlikView data structure, including synthetic keys. ¾ QlikView QVD file and to create them and use them.

What will you learn: ¾ You will be able to navigate in the script editor, use functions and write script as well as best practices on how to structure your scripts. ¾ How to use time specific functions and create variables. ¾ Understand the issues of data models and loading data into QlikView and resolving data structure abnormalities, and how to use the table viewer to view your data. ¾ Connecting to data sources using ODBC or OLEDB. ¾ You will know about QVD files, how to create them and use them.

Page 16