Duration: Hours

QlikView is a leading Business Discovery Platform. It is unique in many ways as compared to the traditional BI platforms. As a data analysis tool, it always maintains the relationship between the data and this relationship can be seen visually using colors. It also shows the data that are not related.

Training Mode: Online

Description

QlikView lets you rapidly develop and deliver interactive guided analytics applications and dashboards. You can ask and answer your own questions and follow your own paths to insight. You and your colleagues can reach decisions collaboratively.

1. Introduction to Business Intelligence (BI)

–  What is Business Intelligence (BI)

–  Features of Business Intelligence (BI)

–  Traditional Business Intelligence(BI)

2. QlikView

–   Introductio

–   Features of QlikView

–   Pros and cons of QV

–  QlikView navigation

–   Concept of Association in QV

3. Data Warehouse Concepts

–  Concept of Facts and Dimension

–  The fact table and Dimension table

4. Schemas

–  Star Schema

–  Snowflake Schema

5. Starting of QV

–  Installation of QV

–  How to start the QV

–  Script Edit ( Cntrl +E)

–   Reload (Cntrl +R)

–   Loading Data from files

–   Creation of QVD file

–    Load and Store of QVD file in QV

6. QVD Files

–  Purpose

–  Create QVD files

–   Reading Data from QVD files

7. Joins in QV

–   How to use joins in QV

–   Left, Right, Inner, Outer

8. Concept of DSN

–  What is DSN

–  How to create the DSN

–  ODBC and OLEDB

–  Loading Data from Database

–  Loading Data from QVDs

9. Staging Structure (Architecture)

–   What is staging

–   What is Folder Structure

–   Why it is necessary

–   Standard folder Structure

 

For more inputs on QlikView you can connect here.
Contact the L&D Specialist at Locus IT.

Reviews

There are no reviews yet.

Be the first to review “QlikView”

Your email address will not be published.