QlikView Online Training

QlikView Online Training

10:20
QlikView is the most flexible Business Intelligence platform for turning data into knowledge. More than 24,000 organizations around the world have enabled their users to easily consolidate & visually analyze all their data for unprecedented business insight using QlikView’s simplicity.

Qlikview training helps you in making selection in Qlikview, you don’t need any previous knowledge of databases or search routines.
Qlikview Online Training

Qlikview Online Training Course Concepts

Qlikview Introduction 

  • What is Qlikview?
  • Why Qlikview?
  • Unique Features compared to Traditional BI Tools

Qlikview Environments 

  • Qlikview Desktop
  • Qlikview Server
  • Qlikview Publisher

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 (qvw) 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
  • Month Year
  • 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 In Date, Data & Date Islands 
  • Aggr() 
  • Class() 
  • Dynamic Aggregation 
  • Interval Match 

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 

  • Access Point does not work 
  • The QlikView Web Server service can’t be started 
  • Access Point displays no content 
  • Details can’t be displayed in the QEMC or QMC 
  • The QEMC or QMC don’t work at all 
Next
« Prev Post
First
Subscribe to: Post Comments (Atom)