Qlik View Course Content

INTRODUCTION TO QLIK VIEW

• Target Audience
• What You Will Learn in this Course
• Course Logistics
• Notes

QLIKVIEW ENVIRONMENT

• QlikView Desktop

QLIKVIEW DEVELOPMENT METHODOLOGIES

• Import/Export Sheet and Document Layouts as XML
• Qlik Wholesale Trade (QWT) Project Plan
• Project Plan Review
• SAFE Methodology

DEPLOYMENTS

• QlikView Standalone
• QlikView Server
• QlikView Publisher 

INTRODUCTIONS 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: 

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
• 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 (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

• 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 

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us