QLIKVIEW

Duration of Training: 6 weekends

Qlikview Syllabus

What is QlikView?

How does QlikView differ from traditional BI?

Exploring data with QlikView

Navigating the document

Slicing and dicing your data

List-boxes

Selections in charts

Search

Bookmarking selections

Undoing selections

Cyclic Groups

Drill down Groups

Containers

The technology and components behind QlikView and the way the data flows

Reload, publish, and distribute content 25

Project

What is a SiB?

Preparing the workspace

Setting up the folder structure

Creating the QlikView document

Creating the app

Constructing the data model

What is a data model?

Loading the fact table

Playing with listboxes

Creating the dashboard tab

Creating and positioning the filters and user controls

One chart and multiple analyses with cyclic expressions

Adding a time drill-down group

Data Sources

Accessing custom data sources

Third-party custom connectors

Reading table files

Extracting data

Creating the OLE DB connection string

Querying the database

Reloading the script

The transformation

Refining the input table

QVD and QVX files

QVD files

QVX files

Loading an Inline table

Data Modeling

Dimensional data modeling

Relational databases and ER modeling

Dimensional modeling

The star schema

The snowflake schema

Creating the dimensional model

Dimensional models in QlikView

The associative data model

How associations are created

Avoiding data model conflicts

Table information

Field information

Table preview

Table viewer menu

Styling Up

Design requirements

The Document Properties window

The Sheet Properties dialog

Setting the object properties

Caption colors and style

Changing the caption colors

Setting the caption font

Setting the content font

Setting the global font

Propagating the object appearance

Setting the default Sheet Object Style

Hiding captions

Working with listboxes

Adding listboxes

The Expressions tab

The Sort tab

The Presentation tab

The Number tab

The Font tab

The Layout tab

The Caption tab

The Multi Box

The Current Selections Box

Adding a Bookmark Object

Aligning and resizing sheet objects

Selecting objects

Moving objects

Aligning sheet objects

Defining chart colors

Setting the default color map

Building Dashboards

Expressions and the Edit Expression window

The Edit Expression window

Auto minimize 200

The Report Editor window

Other charts

Radar Chart

Mekko Chart

Grid Chart

Funnel Chart

Block Chart
Trellis Chart