Qlikview Online Training Concepts :
INTRODUCTION
✔Target Audience
✔What You Will Learn in this Course
✔Course Logistics
✔Notes
QLIKVIEW ENVIRONMENT
✔QlikView Desktop
QLIKVIEW DEVELOPMENT METHODOLOGY
✔Import/Export Sheet and Document Layouts as XML
✔Qlik Wholesale Trade (QWT) Project Plan
✔Project Plan Review
✔SAFE Methodology
DEPLOYMENT
✔QlikView Standalone
✔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 QWT Primary Data Source
✔The QWT 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
✔Is it Correct?
ADDING TEXT DATA
✔Employees
✔Offices
✔Script generation using the File Wizard
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
✔Autogenerate 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
ADDITIONAL INFORMATION
✔Reference Materials
✔Data types in QlikView 137
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_II
INTRODUCTION
✔Installing the Course Materials
✔Program versions
✔Text formats
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
DATA MODEL OPTIMIZATION
✔Performance Tuning
✔Best Practices for QlikView File Optimization
✔Creating Incremental Loads
DAILY AND TRANSACTION BALANCES
✔Overview
✔Example: Balances at Specific Dates
✔Example: Balances for Transactions (in/out)
QLIKVIEW SECURITY 1
✔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
BUSINESS CASE WORKSHOP
✔Scenario
✔Data Structure
QLIKVIEW_Server_Publisher_I
INTRODUCTION
✔Target Audience
✔Introduction
✔Course Logistics
✔Notes
QLIKVIEW DEPLOYMENT CONFIGURATIONS
✔Company Requirements
✔User Requirements
✔What configuration to choose?
✔QlikView Standalone
✔QlikView Server
✔QlikView Server & Publisher
INSTALLING QLIKVIEW SERVER
✔Components of the QlikView Server installation file 13
✔Prerequisites and preparations for installation
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
SETTINGS OF QLIKVIEW SERVER, THE QEMC
✔Settings of the QEMC
✔Status
✔System
✔Users
✔Documents
SECURITY
✔General Concept of Security
✔Security in QlikView
QLIKVIEW SERVER COLLABORATION
✔Sharing objects
✔How Server Collaboration works
✔Management of Server Collaboration
✔More granular control of Server Collaboration
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
0 comments
Post a Comment