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.
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
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