QlikView

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.