Course Overview
Qlikview allows users to swiftly build and position analytic apps without the need for professional development skills, steering faster response to changing business requirements, less time to value, and more insight throughout the organization.
In this course, you’ll learn about system management with data visualization and design best practices for building better experiences with guided analytics.
Requirements
- Basic knowledge of DWH / BI Concepts
- Dimensional Modeling /ER Modeling basics
- Basic T-SQL Query programming
Curriculum
-
QlikView Introduction
- What is QlikView
- Exploring data with QlikView
- Getting QlikView
- QlikView Architecture
- Navigating the document
- Slicing and dicing your data
- The technology and components behind
- QlikView
- The way the data flows
- When QlikView use expands
- Create content
- Reload, publish, and distribute content
- Consume content
- Hands-on sessions on above topics
-
Basic QlikView Design
-
OLTP Data Sources
- Using ODBC and OLE DB drivers
- Accessing custom data sources
- Third-party custom connectors
- Reading table files
- Extracting data—two hands-on examples
- Extracting data from MS Access
- The resulting data model
- Loading a table file
- QVD and QVX files
- Loading an Inline table
- Hands-on sessions on above topics
-
Data Modeling
- Dimensional data modeling
- Relational databases and ER modeling
- The star schema
- The snowflake schema
- Dimensional models in QlikView
- The associative data model
- Guidelines for table associations
- How associations are created
- Avoiding data model conflicts
- The Table Viewer window
- Hands-on sessions on above topics
-
Styling Up
- Design requirements
- The Document Properties window
- The Sheet Properties dialog
- Setting the object properties
- Caption colors and style
- Propagating the object appearance
- Setting the default Sheet Object Style
- Hiding captions
- Working with list boxes
- The General tab
- 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
- Making selections from the Current Selections
- Box
- Adding a Bookmark Object
- Aligning and resizing sheet objects
- Selecting objects
- Moving objects
- Resizing objects
- Resizing a Multi Box
- Aligning sheet objects
- Do a little housekeeping
- Creating and applying a default color map
- Defining chart colors
- Setting the default color map
- Hands-on sessions on above topics
-
Building Dashboards
- User types
- Dashboard users
- Analysts
- Report users
- Creating the Analysis sheet
- Creating the new Dashboard sheet
- Creating the Reports sheet
- Variables
- Pivot tables
- Auto minimize
- The Report Editor window
- Hands-on sessions on above topics
- Other charts
- Radar Chart
- Mekko Chart
- Grid Chart
- Funnel Chart
- Block Chart
- Trellis Chart
-
Scripting
- The Script Editor
- Menu and toolbar
- Script pane
- Tool Pane
- Script statements
- Manipulating tables
- Conditional functions
- Dealing with different data types
- Debugging script
- Standardizing and organizing the script
- Re-using scripts
- Managing file locations and connection strings
- Hands-on sessions on above topics
-
Basic Data Transformation
- Changing the source table structure
- Cleansing a dirty table
- File contents
- Working with the Transformation Step wizard
- The final result
- Other transformation tricks
- Loading a Crosstable
- A Crosstable example
- Working with the Crosstable Wizard
- Expanding a hierarchy
- Working with the Hierarchy Wizard
- The tree-view list-box
- Generic load
- Loading a generic table into QlikView
- Hands-on sessions on above topics
-
Advanced Expressions
- Using variables
- Creating a variable
- Using variables in charts
- Interactively changing a variable’s value
- Using variables based on expressions
- Using variables to store expressions
- Variable naming convention
- The Dollar Sign Expansion syntax
- Using the TOTAL qualifier
- The Aggr function
- Using Aggr for nested aggregation
- Conditional functions
- The If function
- The Class function
- The Pick function
- Hands-on sessions on above topics
-
Set Analysis and Point in Time
-
Advanced Data Transformations
-
More on Visual Design and User
-
Security
-
Macros and Automation
-
Mini Project
