Contact US

Latest Courses

Login

Retrieve Password
Back to login/register
OverViewCourse Content QlikView is very famous for transforming data into visually intutive dashboards quickly. the tool has additional capabilities to [...]

QlikView is very famous for transforming data into visually intutive dashboards quickly. the tool has additional capabilities to transform and clean raw data. Qliview process the data faster by using its in memory data analysis capabilities. Qlikview unique architecture has enabled the self service BI and have empowered the business user with data analysis capabilites. Coursedroid offers free QV course , signup to start the course.

1. QLIK VIEW OVERVIEW

  • Audience
  • Topics of this course
  • Prerequisite for course
  • Notes

2. QLIKVIEW ENVIRONMENT & ARCHITECTURE

  • QlikView Desktop & Server

QLIKVIEW DEVELOPMENT PROCESS

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

4.DEPLOYMENTS PROCESS

  • QlikView Publisher for distribution of dashboard
  • QlikView Server and Deployment of QVW
  • QlikView Standalone Application

5.DATA AND SCRIPTING

  • QlikView Script Overview
  • The QWT Secondary Data Files
  • The QWT Primary Data Source
  • Data Source Files
  • Data Structures in QlikView
  • Comparing Database Structures to QlikView Data Structures
  • Data Structures
  • Relational Databases

6. BASIC SCRIPT SYNTAX

  • Script Syntax

7. LOADING DATA FROM THE DATABASE INTO QLIKVIEW FILW

  • Script Debugging
  • How to comments in the Script
  • Script Generation with QV Syntax

8. STRUCTURING THE SCRIPT

  • Tabs in the QV Script

9. QV DATA MODEL AND TABLE VIEWER

  • Document Properties:
  • QV System Table
  • QV Table Viewer

10. QV DATA TRANSFORMATION

  • Using a Record Counter on Key Fields
  • Loading a Field into a Table Multiple Times
  • QV Example Predicament
  • Key Fields
  • Renaming Fields Using the Qualify Statement
  • Loading an XML File
  • QV Script Expressions
  • Renaming a Field in QV
  • Load Statement

11. ADDING TEXT DATA IN QV

  • Script generation using the File Wizard in QlikView
  • Offices Data
  • Employees Data

12. GENERATING DATA IN THE QLIKVIEW SCRIPT

  • The Master Calendar
  • Creating Variables in the Script
  • QlikView Autogenerate tables
  • Getting the Highest and Lowest Date from the Orders Table
  • Time Functions: Creating a Calendar
  • Include in QlikView
  • Using Orders to determine Sales Person.
  • QlikView Resident Load

13. QLIKVIEW SCRIPTING CONSIDERATIONS

  • Check the Numbers
  • Causes of Circular References
  • QlikView Circular References in data model
  • QlikView Synthetic Key Tables

14. QLIKVIEW DATA (QVD) FILES

  • QVD File Script Functions
  • Automatic Creation of a QVD File in the Script
  • Manual Creation of a QVD File in the Script
  • Creating QVD Files
  • Use of QVD Files
  • QVD File Format

15. REPORTING BUGS IN QLIKVIEW

16. ADDITIONAL INFORMATION

  • Data types in QlikView
  • QlikView Reference Materials

17. APPENDIX: LAYOUT BASICS FOR DEVELOPERS

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

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • FREE
  • UNLIMITED ACCESS
  • Course Certificate
22 STUDENTS ENROLLED
  • Profile photo of vignan
  • Profile photo of Admin
  • Profile photo of Madan
  • Profile photo of V Narasimha Rao Rayaprolu
  • Profile photo of Ranjan

Enroll For Demo Class






Key Features

Online Classes: 30 hrs
Project:

Support:
Lifetime Access:

All Rights Reserved © Coursedroid