QlikView Training

  • Price $410
  • Course Type Online
  • Rating

| +

Course Overview

Qlikview is one of the most popular BI Tools available in the market. It is getting more popular due to its uniques features like In-Memory Analysis, Associative Database and QVDs and so many other features.
The course follows the design and development of a complete QlikView application for a fictional company and introduces each new concept with a set of business requirements. By the end of the course you will have your first QlikView project under your belt, and have built a complete QlikView application yourself that you can take away with you for future reference.

Trainer

Curriculum

1. QLIKVIEW ENVIRONMENT

Topics - QlikView Desktop


2. INTRODUCTION TO DATA AND SCRIPTING

Topics - Relational Databases, Other Data Structures, Comparing Database, Structures to QlikView Data Structures, Data Structures in QlikView, Data Source Files, The QVD Primary Data Source, Secondary Data Files, Introduction to Scripting.


3. BASIC SCRIPT SYNTAX

Topics - Syntax


4. LOADING DATA FROM THE DATABASE

Topics - Script Generation, Comments in the Script, Script Debugging.


5. STRUCTURING THE SCRIPT

Topics - Creating Tabs in the Script


6. BASIC DATA MODEL AND TABLE VIEWER

Topics - The Table Viewer, The System Table, Document Properties: Tables page


7. BASIC DATA TRANSFORMATION

Topics - Load Statement, Renaming a Field, Script Expressions, Loading an XML File, Renaming Fields Using the Qualify Statement, Key Fields, Example Predicament, How Does this Affect You?, Loading a Field into a Table Multiple Times, Using a Record Counter on Key Fields.


8. GENERATING DATA IN THE QLIKVIEW SCRIPT

Topics - Resident Load, Using Orders to determine Sales Person, Include, Time Functions: Creating a Calendar, Getting the Highest and Lowest Date from the Orders Table, Autogenerate tables, Creating Variables in the Script, The Master Calendar.


9. SCRIPTING CONSIDERATIONS

Topics - Synthetic Key Tables, Circular References, Causes of Circular References, Check the Numbers.


10. QLIKVIEW DATA (QVD) FILES

Topics - QVD File Format, Use of QVD Files, Creating QVD Files, Manual Creation of a QVD File in the Script, Automatic Creation of a QVD File in the Script, QVD File Script Functions.


11. REPORTING BUGS IN QLIKVIEW :ADDITIONAL INFORMATION

Topics - Reference Materials, Data types in QlikView


12. APPENDIX: LAYOUT BASICS FOR DEVELOPERS

Topics - User Friendly Design, Natural Human Behavior, Chart and Object Choices in QlikView, Import/Export Sheet and Document Layouts, APPENDIX: The Completed Script, QLIKVIEW_Developer


13. DEVELOPER TOOLS

Topics - Troubleshooting, The Debugger


14. MAPPING TABLES

Topics - Mapping Quarters to the Orders table, Month Year, Cleaning up the table structure


15. LOADING BUDGET DATA

Topics - Reading Cross Tables


16. ADVANCED SCRIPTING

Topics - Condition on a field in a table, Aggregating Data, Joining tables, Concatenation, Preceding Load on Preceding Load


17. ADVANCED CALCULATIONS IN SHEET OBJECTS

Topics - Set Analysis, Dollar-Sign Expansion, AGGR Function


18. SCRIPTING AND DATA MODELING CHALLENGES

Topics - Link Tables and Concatenated Tables, Calculating net change within a field, Functions InDate, Data & DateIslands, Aggr(), Class(), Dynamic Aggregation, IntervalMatch


19. DATA MODEL OPTIMIZATION

Topics - Performance Tuning, Best Practices for QlikView File Optimization, Creating Incremental Loads


20. QLIKVIEW SECURITY

Topics - Access control, Access levels, Access control database, Inherited access restrictions, Hidden script, Adding Section Access, Access control for certain commands, Further access control, Unattended Command Line Reload Considerations, Access restrictions on selected field values, Field value limitation in Section Access


21. ADVANCED DATABASE CONNECTIVITY

Topics - Custom Data, SAP Connector


22. QLIKVIEW SERVER & PUBLISHER : QLIKVIEW DEPLOYMENT CONFIGURATIONS

Topics - Company Requirements, User Requirements, What configuration to choose?, QlikView Standalone, QlikView Server, QlikView Server & Publisher


23. LICENSES AND SERVER TYPES

Topics - License Overview, Server, Client Access Licenses, Publisher, Local Clients


24. INTERACTION OF SERVER AND PUBLISHER COMPONENTS

Topics - Workflow and architecture of Document Management & Display, Document Levels: Script, Data & Layout, Overall Architecture QlikView 10, technical point of view, Functional overview of main components, Deployment of application in QEMC


25. TROUBLESHOOTING

Topics - AccessPoint does not work, The QlikView Web Server service can’t be started, AccessPoint displays no content, Details can’t be displayed in the QEMC or QMC, The QEMC or QMC don’t work at all


Trainer Details

Rithisha Information Systems Pvt.Ltd has been committed to providing the highest quality, needs-based training interventions to its clients, both locally and internationally, Rithisha is a renowned for superior training programs delivered by an enviable team of qualified, expert and highly experienced trainers in the area of Information Technology. Rithisha provides organizations and individuals with a complete and comprehensive suite of training offerings including online and classroom training's.


Rating
Post a Rating
Post a Rating
by Pavan
The training was very informative and helped me a lot in understanding QlikView development topics. Instructor is well organized and knows his domain well. I learned a lot by doing each exercise and following tutor instructions. If you are new to QlikView development, I highly recommend this course.
by Sreekar
This course covers all QlikView topics for a beginner. I am enjoying the course and am impressed with instructor's deep knowledge of QlikView. Thanks a lot for excellent teaching and helping me whenever I have questions. Thank you very much for your training, help and support!

Register For Demo

Register For Demo

Goals & Objectives

  • Script level functions and chart level functions knowledge
  • Design techniques and shortcuts about the less time
  • se graphs, charts and pivot tables to represent your sales and business data
  • You will be able to start building QlikView data models after completing this course

Suggested Courses

ServiceNow Administrator
by Rithisha InformationSystems
Tableau Course
by Rithisha InformationSystems
Build and Release Engineer
by Rithisha InformationSystems
DevOps Boot Camp
by Rithisha InformationSystems
About Us

VIBLOO is a platform for teaching and learning on the web. Trainers can offer Video, Online & Classroom courses on Vibloo.


Read More