QlikView Training Syllabus

                                         QlikView Training – 5 Days   

Prerequisites:

1. Data warehousing concepts.
2. Basic SQL Knowledge

(It Is mandatory to accomplish the training prerequisite conditions before nominating for the session)

Introduction:

QlikView Developer 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. QlikView Designer course focuses on QlikView application, objects such as sheets, list boxes and charts, working with scripts, best practices, loading data, deploying QlikView applications.

Who should attend?

Developers, Designers & Power End-Users.

Learning Objectives:

QlikView Developer:

By the end of this course, you will be able to:

• Create a data model in QlikView
• Build a QlikView document
• Resolve data structure issues
• Access the Debugger
• Define the advanced uses of the script editor
• Use transformative Functions in the script

QlikView Designer:

• Demonstrate basic knowledge of a QlikView data model in QlikView
• How to best layout and design your QlikView application
• Explain basic use of QlikView sheet objects
• Identify, based on data provided, which chart will provide the best visual representation of data to the viewer.

Attractions:

1. Real time project Application development.
2. Hands on practice data modelling with Star Schema (Link table) and Snow Flake schema.
3. Script level functions and chart level functions knowledge.
4. Design techniques and short cuts about the less time.

Course Outline

Day -1 (8 Hours)

1. Meet QlikView: USING QLIKVIEW 11.0 SR-2 PERSONAL EDITION
   1. Introduction to QlikView, history, features and architecture.
   2. Introduction to Multi-tier environment in QlikView, using Source Documents, User Documents and QVDs.
   3. QlikView advantages over conventional BI tools and differences.
   4. QlikView product offerings and Role of users.
   5. Starting QlikView, getting familiar with the interface.
   6. Basic Layout and Navigation
   7. Visualizations dashboard to get a look of UI in QlikView.

2.  SHEETS AND SHEET OBJECTS

1. Creating Your Workspace, creating your First Document.
2. Sheet Basics.

2.3.    Introduction to Script editor.
2.4.    Introduction to various steps to load data from different data sources.

1. Introduction to Data Set.

2.6.    Introduction to multi-tab architecture in script editor, using multiple tabs to segregate your script.
2.7.    Introduction to system variables.

1. Loading your first QVD.

2.9.    Sheet Objects, creating list boxes and making analysis.
Day -2 (8 Hours)

3.     DATA MODELLING

1. Script editing.

3.2.    Introduction to Load statements and adding more QVDs and building data models.

1. Edit Script Toolbar.

3.4.    Edit Script Menu Commands.
3.5.    Statements Area.
3.6.    Introduction to QlikView statements, keywords, fields, tables.

1. Naming conventions and colour schemes.

3.8.    Differences between star schema and snowflake schema.

1. Introduction to table viewer.

3.10. Embedding business logic in your data model.

1. Creating your first chart.
2. Chart nuances and properties.
3. Making Analysis happen.
4. More List boxes.
5. Designing your dashboard.
6. Setting Document properties.
7. Setting various user preferences and properties.
8. Creating different charts.
9. Loading more QVDs and creating tables.

4. DATA SOURCES
   1. Script generation.

4.2.    Creating a connection to the database.

1. Creating different types of connections.

4.4.    Reading the access database.
4.5.    Creating select statements.

1. Reading tables into QlikView.

4.7.    Scripting considerations and Data Modelling.
4.8.    Synthetic key, how to remove them.
4.9.    Circular references, Causes of circular references and their removal.

1. Loosely Coupled Tables.

STYLING UP: BUILDING DASHBOARDS

1. Deciding and creating a layout.
2. Setting sheets backgrounds, colours and font.

5.3.    Setting layout colour themes.
5.4.    The DAR principle.

1. Styling up the document.

5.6.    Creating different charts using available metrics.
5.7.    Introduction to charting in QlikView.

1. Creating Bar chart, straight tables, line charts, Combo charts.
2. Expression Overview Window.
3. Introduction to other QlikView objects, Container, Buttons, Current selections box, statistics box.
4. Creating Scatter charts, pie charts, gauge charts, text boxes.
5. Associating actions with objects.
6. Creating bookmarks.

Day -4 (8 Hours)

6. SCRIPTING
   1. Loading a text file in XML Format.

6.2.    Renaming fields by Alias and by using the Qualify statement.

1. Generating data in the QlikView script.
2. Resident Load.
3. Inline tables.

6.6.    AutoGenerate tables.
6.7.    Mapping tables. Using ApplyMap() to lookup values Month

1. Joins and concatenating tables.

6.9.    Advanced scripting techniques.
6.10. Cleaning up the table structure.

1. Creating calendar table.
2. Using total qualifier and Aggr function.
3. Most of the unknown qlikview functions.
4. Using report editor to create static reports.

Day 5 (8 Hours)

7. SECURITY and SET ANALYSIS
   1. Qlikview securities.
   2. Creating hidden scripts.
   3. Using include statement to include external script files and config files.
   4. Setting up section access and restricting access to document
   5. Hiding data, data reduction using section access.
   6. Set analysis.
   7. Syntax and semantics.
   8. Using set analysis to define data sets.
   9. Dynamic set analysis.
   10. Using variables in set analysis, Dollar sign expansion.
   11. Point in Time analysis.
   12. Benefits of set analysis.
   13. Alerts and triggers.
   14. Miscellaneous topics.

Certification Preparation:

For QlikView certification preparation, we cover specific aspects of certifications during the training.  QlikView certification is designed to test your knowledge, QlikView expertise.

QlikView certification is a journey, you will learn a lot on your way to certification.

Training cover all areas of tests during the training. It includes a exam of 70 questions which will enable the participant to judge his/her preparation for the test.  The test we conduct covers following areas

• Gather and Interpret Requirements
• Identify and Analyze Data Source
• Given a dataset, determine the relationships among data
• Determine the result of a given function or complex expression
• Identify where alternate uses of expressions are appropriate
• Given  a  scenario,  determine  the  appropriate  function  or  complex expression to use
• Explain how to implement Actions/Triggers in the QlikView interface
• Given a scenario, determine the appropriate object or chart type to use
• Explain the purpose/functionality of common object properties
• Given a scenario, determine the appropriate application User Interface performance tuning option to use
• Given user requirements, identify the appropriate screen resolution