About QlikView Training
QlikView is one of the fastest evolving Business Intelligence and data visualisation tool in the market. It is robust, very fast to deploy, easy to learn and very intuitive to use for a customer. So, if you want to improve data visualisation practices, then Qlikview is the perfect tool to start with.
Prince Tech solutions is one of the best QlikView training providing company in India. Here we provide the following,
- Qlikview Online Training ,Qlikview Corporate Training and Recordings for Qlikview Self learning courses
- We provide you with well researched advanced training course contents/Syllabus.
- Resume & Interviews Preparation Support.
- We provide on job support to professionals
- We focus on the needs of the QlikView community.
- We offer QlikView education for students and working professionals.
- Prince Tech solutions provides free QlikView training materials of soft copy and hard copy.
Discover best QlikView training in India at Prince Tech solutions. Here our aim is to provide a learning path to all those, who are new to QlikView. This path will help you to learn QlikView in a structured approach. If you already have some background, or don’t need all the components, feel free to adapt your own paths and let us know how have you made the changes in the path.
Our QlikView training courses helps to students / professional to get placement immediately after course completion. Our practical, real time QlikView project scenarios training helps to work on QlikView projects. Our QlikView training program helps every student / professionals to achieve their goal in QlikView career.
QlikView – Course Content
QLIKVIEW ENVIRONMENT
- QlikView Desktop
INTRODUCTION TO DATA AND SCRIPTING
- 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
BASIC SCRIPT SYNTAX
- Syntax
LOADING DATA FROM THE DATABASE
- Script Generation
- Comments in the Script
- Script Debugging
STRUCTURING THE SCRIPT
- Creating Tabs in the Script
BASIC DATA MODEL AND TABLE VIEWER
- The Table Viewer
- The System Table
- Document Properties: Tables page
BASIC DATA TRANSFORMATION
- 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
GENERATING DATA IN THE QLIKVIEW SCRIPT
- Resident Load
- Using Orders to determine Sales Person.
- Include
- Time Functions: Creating a Calendar
- Getting the Highest and Lowest Date from the Orders Table
- Auto generate tables
- Creating Variables in the Script
- The Master Calendar
SCRIPTING CONSIDERATIONS
- Synthetic Key Tables
- Circular References
- Causes of Circular References
- Check the Numbers
QLIKVIEW DATA (QVD) FILES
- 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
REPORTING BUGS IN QLIKVIEW
ADDITIONAL INFORMATION
- Reference Materials
- Data types in QlikView
APPENDIX: LAYOUT BASICS FOR DEVELOPERS
- User Friendly Design
- Natural Human Behavior
- Chart and Object Choices in QlikView
- Import/Export Sheet and Document Layouts
- APPENDIX: The Completed Script
- QLIKVIEW_Developer
DEVELOPER TOOLS
- Troubleshooting
- The Debugger
MAPPING TABLES
- Mapping Quarters to the Orders table
- MonthYear
- Cleaning up the table structure
LOADING BUDGET DATA
- Reading Cross Tables
ADVANCED SCRIPTING
- Condition on a field in a table
- Aggregating Data
- Joining tables
- Concatenation
- Preceding Load on Preceding Load
ADVANCED CALCULATIONS IN SHEET OBJECTS
- Set Analysis
- Dollar-Sign Expansion
- AGGR Function
SCRIPTING AND DATA MODELING CHALLENGES
- Link Tables and Concatenated Tables
- Calculating net change within a field
- Functions InDate, Data & DateIslands
- Aggr()
- Class()
- Dynamic Aggregation
- IntervalMatch
DATA MODEL OPTIMIZATION
- Performance Tuning
- Best Practices for QlikView File Optimization
- Creating Incremental Loads
QLIKVIEW SECURITY
- 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
ADVANCED DATABASE CONNECTIVITY
- Custom Data
- SAP Connector
QLIKVIEW SERVER & PUBLISHER
QLIKVIEW DEPLOYMENT CONFIGURATIONS
- Company Requirements
- User Requirements
- What configuration to choose?
- QlikView Standalone
- QlikView Server
- QlikView Server & Publisher
LICENSES AND SERVER TYPES
- License Overview
- Server
- Client Access Licenses
- Publisher
- Local Clients
INTERACTION OF SERVER AND PUBLISHER COMPONENTS
- 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
TROUBLESHOOTING
- 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