Overview of Qlikview Developer
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.
Duration
6 Days
Prerequisite for Qlikview Developer
- Basic knowledge of DWH / BI Concepts
- Dimensional Modeling /ER Modeling basics
- Basic T-SQL Query programming
Course Outline for Qlikview Developer
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
- Preparing the workspace
- Setting up the folder structure
- Creating the QlikView document
- Creating the app
- The requirements
- Constructing the data model
- Loading the fact table
- Playing with list boxes
- Associating additional tables
- Creating the dashboard tab
- Hands-on sessions on above topics
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
- Reporting
- The magic of Set Analysis
- Dynamic recordsets
- More assignment operators
- Set operators
- Point In Time Reporting
- The challenge
- Defining the set modifiers
- Storing set expressions into variables
- Portable set expressions
- Hands-on sessions on above topics
Advanced-Data Transformation
- Data architecture
- Two-stage architecture
- Three-stage architecture
- Setting up our environment
- Loading data already stored in QlikView
- Cloning a QlikView data model
- Loading from RAM
- Sorting tables
- Ordering the Order-By fields
- The Peek function
- Merging forces
- Hands-on sessions on above topics
More on Visual Design and User
- Experience
- Creating a consistent QlikView UI
- Screen resolution
- Background image
- Themes
- Additional interactivity
- Triggers
- Actions
- Advanced search expressions
- Dynamic bookmarks
- Alerts
- Conditionally showing and calculating objects
- Hands-on sessions on above topics
Security
- Hidden script
- Section access
- Section access fields
- Reduction fields
- Initial data reduction
- Omitting fields
- Document-level security
- Sheet-level security
- Hands-on sessions on above topics
Macros and Automation
- Using Automation Macros
- Internal Macro Interpreter
- Getting hold of a QlikView Document
- VB Script Functions
- Using macros in QV document
- Hands-on sessions on above topics
Mini Project
- Requirements Gathering
- Build a Qlikview Data Model
- Design Dashboard
- Scripting Functionality of Dashboard