QlikView for Developers

Drive value and insight by developing business critical applications with QlikView 12

QlikView for Developers

This ebook is included in a Mapt subscription
Miguel Ángel García, Barry Harmsen

Drive value and insight by developing business critical applications with QlikView 12
$10.00
$64.99
RRP $51.99
RRP $64.99
eBook
Print + eBook
Access every Packt eBook & Video for just $100
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Find Out More
 
Preview in Mapt

Book Details

ISBN 139781786469847
Paperback546 pages

Book Description

QlikView is one of the most flexible and powerful Business Intelligence platforms around. If you want to build data into your organization, build it around QlikView. Don't get caught in the gap between data and knowledge – find out how QlikView can help you unlock insights and data potential with ease.

Whether you're new to QlikView or want to get up to speed with the features and functionality of QlikView, this book starts at a basic level and delves more deeply to demonstrate how to make QlikView work for you, and make it meet the needs of your organization. Using a real-world use-case to highlight the extensive impact of effective business analytics, this book might well be your silver bullet for success.

A superb hands-on guide to get you started by exploring the fundamentals of QlikView before learning how to successfully implement it, technically and strategically. You'll learn valuable tips, tricks, and insightful information on loading different types of data into QlikView, and how to model it effectively.

You will also learn how to write useful scripts for QlikView to handle potentially complex data transformations in a way that is simple and elegant. From ensuring consistency and clarity in your data models, to techniques for managing expressions using variables, this book makes sure that your QlikView projects are organized in a way that's most productive for you and key stakeholders.

Table of Contents

Chapter 1: Meet QlikView
What is QlikView?
Exploring data with QlikView
The technology and components behind QlikView
Meet HighCloud Airlines
Summary
Chapter 2: What's New in QlikView 12?
How is QlikView 12 different from QlikView 11?
What is new in the Qlik product portfolio?
How do the products in the Qlik product portfolio fit together?
What is new in QlikView 12 for Developers?
Summary
Chapter 3: Seeing is Believing
What is a SiB?
Preparing the workspace
Creating the app
Summary
Chapter 4: Data Sources
Using ODBC and OLE DB drivers
Extracting data – two hands-on examples
Loading a table file
QVD and QVX files
Loading an Inline table
Summary
Chapter 5: Data Modeling
Dimensional data modeling
The associative data model
The Table Viewer window
Summary
Chapter 6: Styling Up
Design requirements
The Document Properties window
The Sheet Properties dialog
Setting the object properties
Working with listboxes
The Multi Box
The Current Selections Box
Adding a Bookmark Object
Aligning and resizing sheet objects
Creating and applying a default color map
Summary
Chapter 7: Building Dashboards
User types
Applying the DAR principle to Airline Operations
Creating the Analysis sheet
Creating the new Dashboard sheet
Creating the Reports sheet
Other charts
Summary
Chapter 8: Scripting
The Script Editor
Script statements
Conditional functions
Dealing with different data types
Debugging script
Standardizing and organizing script
Re-using scripts
Managing file locations and connection strings
Summary
Chapter 9: Data Modeling Best Practices
Data consistency
Reducing storage requirements
Design challenges of data modeling
The master calendar
A final note on data modeling
Summary
Chapter 10: Basic Data Transformation
Changing the source table structure
Summary
Chapter 11: Advanced Expressions
Using variables
Using the TOTAL qualifier
The Aggr function
Conditional functions
A tip on copying expressions
Summary
Chapter 12: Set Analysis and Point In Time Reporting
The magic of Set Analysis
Point In Time Reporting
Comparative analysis with alternate states
Always validate
Summary
Chapter 13: Advanced Data Transformation
Data architecture
Loading data already stored in QlikView
Aggregating data
Sorting tables
The Peek function
Merging forces
Dealing with slowly changing dimensions
Ordering, peeking, and matching all at once
Incremental loads
Summary
Chapter 14: More on Visual Design and User Experience
Creating a consistent QlikView UI
Additional interactivity
Summary
Chapter 15: Security
Hidden script
Section access
Document-level security
Sheet-level security
Summary

What You Will Learn

  • Understand important changes made in QlikView 12
  • Learn the techniques and best practices to transform data in QlikView via scripts
  • Load data from disparate sources to build an associative Data Model
  • Build robust data models and overcome common modeling challenges
  • Designing data visualization objects to present performance measures with charts and tables
  • Learn to use dimensions and expressions in QlikView objects
  • Utilize QlikView's built-in aggregation functions to achieve complex calculations
  • Create Point In Time reporting and achieving complex calculations using Set Analysis
  • Create a consistent and interactive user interface
  • Ensure your QlikView applications and data are protected
  • Optimize the QlikView Data Model
  • Constructing a data architecture that supports scalable QlikView deployments
  • Learn time-saving techniques for making your QlikView development more efficient

Authors

Table of Contents

Chapter 1: Meet QlikView
What is QlikView?
Exploring data with QlikView
The technology and components behind QlikView
Meet HighCloud Airlines
Summary
Chapter 2: What's New in QlikView 12?
How is QlikView 12 different from QlikView 11?
What is new in the Qlik product portfolio?
How do the products in the Qlik product portfolio fit together?
What is new in QlikView 12 for Developers?
Summary
Chapter 3: Seeing is Believing
What is a SiB?
Preparing the workspace
Creating the app
Summary
Chapter 4: Data Sources
Using ODBC and OLE DB drivers
Extracting data – two hands-on examples
Loading a table file
QVD and QVX files
Loading an Inline table
Summary
Chapter 5: Data Modeling
Dimensional data modeling
The associative data model
The Table Viewer window
Summary
Chapter 6: Styling Up
Design requirements
The Document Properties window
The Sheet Properties dialog
Setting the object properties
Working with listboxes
The Multi Box
The Current Selections Box
Adding a Bookmark Object
Aligning and resizing sheet objects
Creating and applying a default color map
Summary
Chapter 7: Building Dashboards
User types
Applying the DAR principle to Airline Operations
Creating the Analysis sheet
Creating the new Dashboard sheet
Creating the Reports sheet
Other charts
Summary
Chapter 8: Scripting
The Script Editor
Script statements
Conditional functions
Dealing with different data types
Debugging script
Standardizing and organizing script
Re-using scripts
Managing file locations and connection strings
Summary
Chapter 9: Data Modeling Best Practices
Data consistency
Reducing storage requirements
Design challenges of data modeling
The master calendar
A final note on data modeling
Summary
Chapter 10: Basic Data Transformation
Changing the source table structure
Summary
Chapter 11: Advanced Expressions
Using variables
Using the TOTAL qualifier
The Aggr function
Conditional functions
A tip on copying expressions
Summary
Chapter 12: Set Analysis and Point In Time Reporting
The magic of Set Analysis
Point In Time Reporting
Comparative analysis with alternate states
Always validate
Summary
Chapter 13: Advanced Data Transformation
Data architecture
Loading data already stored in QlikView
Aggregating data
Sorting tables
The Peek function
Merging forces
Dealing with slowly changing dimensions
Ordering, peeking, and matching all at once
Incremental loads
Summary
Chapter 14: More on Visual Design and User Experience
Creating a consistent QlikView UI
Additional interactivity
Summary
Chapter 15: Security
Hidden script
Section access
Document-level security
Sheet-level security
Summary

Book Details

ISBN 139781786469847
Paperback546 pages
Read More

Read More Reviews