QlikView Certification Training Course

Checking...

Ouch! There was a server error.
Retry »

Sending message...

Enquiry Now


time-icon-vector-png_125592-removebg-preview

Course Duration

50 Days.

833px-PDF_file_icon.svg

Download Course Curriculum

ABOUT COURSE

QlikView Online Training makes you an expert in Business Analytics using QlikView tool and learn all that is required to create real world Analytical Visualizations with the QlikView.The QlikView courses training content is a mixture of demonstrations and hands on exercises of many QlikView components.

Qlikview Certification helps in saving time and effective decision making by providing data insights in a visually attractive and interactive way, that too in a few minutes. It also makes it easy to explore and locate the data which can’t be located using query based tools. Qlikview is usually simple enough for most of the user to pick up without having to do any extra work on their programming skills. No special skills are required before using this tool.

Benefits of Attending QlikView Training

Why Kasha Training Education?

Feedback from our Participants

COURSE CURRICULUM

  • Target Audience
  • What You Will Learn in this Course
  • Course Logistics
  • Notes
  •  
  • QlikView Desktop
  •  
  • Import/Export Sheet and Document Layouts as XML
  • Qlik Wholesale Trade (QWT) Project Plan
  • Project Plan Review
  • SAFE Methodology
  •  
  • QlikView Standalone
  • QlikView Server
  • QlikView Publisher
  •  
  • Relational Databases
  • Other Data Structures
  • Comparing Database Structures to QlikView Data Structures
  • ata Structures in QlikView
  • Data Source Files
  • The QWT Primary Data Source
  • The QWT Secondary Data Files
  • Introduction to Scripting
  •  
  • Script Generation
  • Comments in the Script
  • Script Debugging
  •  
  • Creating Tabs in the Script
  •  
  • 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?
  •  
  • Employees
  • Offices
  • Script generation using the File Wizard
  •  
  • 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
  •  
  • Synthetic Key Tables
  • Circular References
  • Causes of Circular References
  • Check the Numbers
  •  
  • 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
  • Reference Materials
  • Data types in QlikView 137
  •  
  • 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
  • Installing the Course Materials
  • Program versions
  • Text formats
  • Troubleshooting
  • The Debugger
  •  
  • Mapping Quarters to the Orders table
  • Month Year
  • Cleaning up the table structure
  • Reading Cross Tables
  • Condition on a field in a table
  • Aggregating Data
  • Joining tables
  • Concatenation
  • Preceding Load on Preceding Load
  •  
  • Set Analysis
  • Dollar-Sign Expansion
  • AGGR Function
  • Link Tables and Concatenated Tables
  • Calculating net change within a field
  • Functions In Date, Data & Date Islands
  • Aggr()
  • Class()
  • Dynamic Aggregation
  • Interval Match
  •  
  • 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
  •  
  • Overview
  • Example: Balances at Specific Dates
  • Example: Balances for Transactions (in/out)
  •  
  • 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
  •  

WHO CAN LEARN?

FAQ

Most frequent questions and answers

Click on Enquire now and register.

Yes we do provide Demo session and one free class that will help you to decide.

Yes all relevant material would be provided.

Yes all relevant material would be provided.

About Us

Kasha Training is one of the world’s leading Online training providers, helping professionals across industries and sectors develop new expertise and bridge their skill gap for recognition and growth in the corporate world.

Copyright © 2023 Kasha Training. All Rights Reserved

Need Help? Chat with us