Qlikview

Home  >>  Courses  >>  Qlikview

QlikView is the most flexible Business Intelligence platform for turning data into knowledge. More than 24,000 organisations worldwide have enabled their users to easily consolidate, search, and visually analyse all their data for unprecedented business insight using QlikView’s simplicity.

COURSE CONTENT

1. Introduction to Qlikview

  • Target Audience
  • What you will learn in this course
  • Course Logistics
  • Notes

2. Qlikview Environment

  • Qlikview Desktop

3. Deployments

  • Qlikview Standalone
  • Qlikview Server
  • Qlikview Publisher

4. Development Methodologies

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

5. Introduction to Data & 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

6. Loading Data from Database

  • Script Generation
  • Comments in the script
  • Script Debugging
  • Structuring the script – Creating Tabs

7. Basic Data Model & Table Viewer

  • The Table Viewer
  • The System Table
  • Document Properties

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

9. Adding Text Data

  • Employees
  • Offices
  • Script Generation using File Wizard

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

11. Scripting Consideration

  • Synthetic Key Tables
  • Circular References
  • Causes of Circular References
  • Check the Numbers

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

13. Additional Information

  • Reporting Bugs in Qlikview
  • Reference Materials
  • Data Types in Qlikview
  • Appendix: The Completed Script

14. Appendix: Layout Basics for Developers

  • User Friendly Design
  • Natural Human Behavior
  • Chart and Object Choices in QlikView
  • Import/Export Sheet and Document Layouts

Related Tags

qlikview online training videos
qlikview online training hyderabad
qlikview training cost

Request Free Demo Details

Please wait...