Qlikview Online Training :
INTRODUCTION
- 1.Target Audience
- 2.What You Will Learn in this Course
- 3.Course Logistics
- 4.Notes
QLIKVIEW ENVIRONMENT
- 1.QlikView Desktop
QLIKVIEW DEVELOPMENT METHODOLOGY
- 1.Import/Export Sheet and Document Layouts as XML
- 2.Qlik Wholesale Trade (QWT) Project Plan
- 3.Project Plan Review
- 4.SAFE Methodology
DEPLOYMENT
- 1.QlikView Standalone
- 2.QlikView Server
- 3.QlikView Publisher
INTRODUCTION TO DATA AND SCRIPTING
- 1.Relational Databases
- 2.Other Data Structures
- 3.Comparing Database Structures to QlikView Data Structures
- 4.Data Structures in QlikView
- 5.Data Source Files
- 6.The QWT Primary Data Source
- 7.The QWT Secondary Data Files
- 8.Introduction to Scripting
BASIC SCRIPT SYNTAX
- 1.Syntax
LOADING DATA FROM THE DATABASE
- 1.Script Generation
- 2.Comments in the Script
- 3.Script Debugging
STRUCTURING THE SCRIPT
- 1.Creating Tabs in the Script
BASIC DATA MODEL AND TABLE VIEWER
- 1.The Table Viewer
- 2.The System Table
- 3.Document Properties: Tables page
BASIC DATA TRANSFORMATION
- 1.Load Statement
- 2.Renaming a Field
- 3.Script Expressions
- 4.Loading an XML File
- 5.Renaming Fields Using the Qualify Statement
- 6.Key Fields
- 7.Example Predicament
- 8.How Does this Affect You?
- 9.Loading a Field into a Table Multiple Times
- 10.Using a Record Counter on Key Fields
- 11.Is it Correct?
ADDING TEXT DATA
- 1.Employees
- 2.Offices
- 3.Script generation using the File Wizard
GENERATING DATA IN THE QLIKVIEW SCRIPT
- 1.Resident Load
- 2.Using Orders to determine Sales Person.
- 3.Include
- 4.Time Functions: Creating a Calendar
- 5.Getting the Highest and Lowest Date from the Orders Table
- 6.Autogenerate tables
- 7.Creating Variables in the Script
- 8.The Master Calendar
SCRIPTING CONSIDERATIONS
- 1.Synthetic Key Tables
- 2.Circular References
- 3.Causes of Circular References
- 4.Check the Numbers
QLIKVIEW DATA (QVD) FILES
- 1.QVD File Format
- 2.Use of QVD Files
- 3.Creating QVD Files
- 4.Manual Creation of a QVD File in the Script
- 5.Automatic Creation of a QVD File in the Script
- 6.QVD File Script Functions
REPORTING BUGS IN QLIKVIEW ADDITIONAL INFORMATION
- 1.Reference Materials
- 2.Data types in QlikView
- LAYOUT BASICS FOR DEVELOPERS
- 1.User Friendly Design
- 2.Natural Human Behavior
- 3.Chart and Object Choices in QlikView
- 4.Import/Export Sheet and Document Layouts
- 5.The Completed Script
- 6.QLIKVIEW_Developer_II
INTRODUCTION
- 1.Installing the Course Materials
- 2.Program versions
- 3.Text formats
DEVELOPER TOOLS
- 1.Troubleshooting
- 2.The Debugger
MAPPING TABLES
- 1.Mapping Quarters to the Orders table
- 2.MonthYear
- 3.Cleaning up the table structure
LOADING BUDGET DATA
- 1.Reading Cross Tables
ADVANCED SCRIPTING
- 1.Condition on a field in a table
- 2.Aggregating Data
- 3.Joining tables
- 4.Concatenation
- 5.Preceding Load on Preceding Load
ADVANCED CALCULATIONS IN SHEET OBJECTS
- 1.Set Analysis
- 2.Dollar-Sign Expansion
- 3.AGGR Function
SCRIPTING AND DATA MODELING CHALLENGES
- 1.Link Tables and Concatenated Tables
- 2.Calculating net change within a field
- 3.Functions InDate, Data & DateIslands
- 4.Aggr()
- 5.Class()
- 6.Dynamic Aggregation
- 7.IntervalMatch
DATA MODEL OPTIMIZATION
- 1.Performance Tuning
- 2.Best Practices for QlikView File Optimization
- 3.Creating Incremental Loads
DATA MODEL OPTIMIZATION
- 1.Performance Tuning
- 2.Best Practices for QlikView File Optimization
- 3.Creating Incremental Loads
DAILY AND TRANSACTION BALANCES
- 1.Overview
- 2.Example: Balances at Specific Dates
- 3.Example: Balances for Transactions (in/out)
QLIKVIEW SECURITY 1
- 1.Access control
- 2.Access levels
- 3.Access control database
- 4.Inherited access restrictions
- 5.Hidden script
- 6.Adding Section Access
- 7.Access control for certain commands
- 8.Further access control
- 9.Unattended Command Line Reload Considerations
- 10.Access restrictions on selected field values
- 11.Field value limitation in Section Access
ADVANCED DATABASE CONNECTIVITY
- 1.Custom Data
- 2.SAP Connector
BUSINESS CASE WORKSHOP
- 1.Scenario
- 2.Data Structure
QLIKVIEW_Server_Publisher_I
INTRODUCTION
- 1.Target Audience
- 2.Introduction
- 3.Course Logistics
- 4.Notes
QLIKVIEW DEPLOYMENT CONFIGURATIONS
- 1.Company Requirements
- 2.User Requirements
- 3.What configuration to choose?
- 4.QlikView Standalone
- 5.QlikView Server
- 6.QlikView Server & Publisher
INSTALLING QLIKVIEW SERVER
- 1.Components of the QlikView Server installation file 13
- 2.Prerequisites and preparations for installation
LICENSES AND SERVER TYPES
- 1.License Overview
- 2.Server
- 3.Client Access Licenses
- 4.Publisher
- 5.Local Clients
INTERACTION OF SERVER AND PUBLISHER COMPONENTS
- 1.Workflow and architecture of Document Management & Display
- 2.Document Levels: Script, Data & Layout
- 3.Overall Architecture QlikView 10, technical point of view
- 4.Functional overview of main components
SETTINGS OF QLIKVIEW SERVER, THE QEMC
- 1.Settings of the QEMC
- 2.Status
- 3.System
- 4.Users
- 5.Documents
SECURITY
- 1.General Concept of Security
- 2.Security in QlikView
QLIKVIEW SERVER COLLABORATION
- 1.Sharing objects
- 2.How Server Collaboration works
- 3.Management of Server Collaboration
- 4.More granular control of Server Collaboration
TROUBLESHOOTING
- 1.AccessPoint does not work
- 2.The QlikView Web Server service can’t be started
- 3.AccessPoint displays no content
- 4.Details can’t be displayed in the QEMC or QMC
- 5.The QEMC or QMC don’t work at all
Our Qlikview Online Training batches start every week and we accommodate your flexible timings.
The blog is so interactive and Informative , you should write more blogs like this
ReplyDeleteQlikview Online Training
Qlikview Training