Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

QlikView Online Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: Gotomeeting

Course ID: 25265

Course type: Online Instructor led Course

Platform: Gotomeeting

Students Interested 1 (Seats Left 0)

₹ 12,000

No Reviews Yet

Date and Time

Not decided yet.

Amit Kumar picture
Amit Kumar

B-TECH, MBA

8 Years of Experience

About Amit Kumar

I am Amit, an expert QlikView professional. Having competencies of providing online and classroom training to Individuals and corporate companies both in Indian and oversees clients. If you are looking for a QlikView trainer please get in touch with me to discuss about pricing and a free demo training schedule on: trainer.qv (Skype id)
No reviews currently Be the First to Review

About the Course

Online training on qlikview.

Topics Covered

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 AND ADVANCE SCRIPT SYNTAX

1.Syntax

LOADING DATA FROM THE DATABASE

1.Script Generation

2.Comments in the Script

3.Script Debugging

4. Integration with following databases, such as:

Text
CSV
XLS
QVD
QVX
Oracle
SQL Server
ERP
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.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

1. Bug addressing and fixing

ADDITIONAL INFORMATION

1.Reference Materials

2.Data types in QlikView

APPENDIX:

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

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.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

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

Who should attend

Graduate engineers, BI professionals, Software developers, Business analyst. Data warehousing professional and other who interested to grow with IT

Pre-requisites

Knowledge on basic SQL

What you need to bring

Laptop"

Key Takeaways

internet

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 1 (Seats Left 0)

₹ 12,000

Post your requirement and let us connect you with best possible matches for Qlikview Training Post your requirement now
₹ 12,000 Enquire

Enquire

Submit your enquiry for QlikView Online Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Amit

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer