Qlikview

Week-1

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

Week-2

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

Week-3

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

Week-4

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

Week-5

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
<!--[endif]-->

Week-6

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
Hands on project, interview preparation