Mastering QlikView Data Visualization

294 Pages·2016·3.93 MB·English

by  Karl Pover

[ 1 ]
Mastering QlikView Data
Visualization
Take your QlikView skills to the next level and
master the art of creating visual data analysis
for real business needs
Karl Pover
professional expertise distilled
P U B L I S H I N G
BIRMINGHAM - MUMBAI
Mastering QlikView Data Visualization
Copyright © 2016 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval
system, or transmitted in any form or by any means, without the prior written
permission of the publisher, except in the case of brief quotations embedded in
critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy
of the information presented. However, the information contained in this book is
sold without warranty, either express or implied. Neither the author, nor Packt
Publishing, and its dealers and distributors will be held liable for any damages
caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the
companies and products mentioned in this book by the appropriate use of capitals.
However, Packt Publishing cannot guarantee the accuracy of this information.
First published: April 2016
Production reference: 1200416
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78217-325-0
www.packtpub.com
Credits
Author Project Coordinator
Karl Pover Izzat Contractor
Reviewers Proofreader
Ralf Becher Safis Editing
Miguel Ángel García
Michael Tarallo Indexer
Monica Ajmera Mehta
Commissioning Editor
Kartikey Pandey Graphics
Kirk D'Penha
Disha Haria
Acquisition Editor
Tushar Gupta
Production Coordinator
Conidon Miranda
Content Development Editor
Rohit Singh
Cover Work
Conidon Miranda
Technical Editor
Siddhesh Patil
Copy Editor
Priyanka Ravi
About the Author
Karl Pover is the owner and principal consultant of Evolution Consulting, which
provides QlikView consulting services throughout Mexico. Since 2006, he has been
dedicated to providing QlikView presales, implementation, and training for more
than 50 customers. He is the author of Learning QlikView Data Visualization, and he
has also been a Qlik Luminary since 2014. You can follow Karl on Twitter
(@karlpover) or on LinkedIn (https://mx.linkedin.com/in/karlpover).
He also blogs at http://poverconsulting.com/.
First and foremost, I would like to thank my wife, Pamela. I owe you
several long weekends.
Thanks to the team at Evolution Consulting, especially Julian
Villafuerte, Carlos Reyes, and Jaime Aguilar, for taking on more
responsibility. A special thanks to Julian for taking the time to
review the final version of this book, and Alejandro Morales for
helping me develop a few extensions.
As always, thanks to my parents, Judy and Bill, for their love and
support throughout my life.
I am grateful to all the technical reviewers, and especially Ralf
Becher, who contributed material to this book. I also appreciate the
work done by Rohit Kumar Singh and the rest of the Packt team,
who gave me a little extra time to make this a great book.
Last, but not least, thanks to all the customers, past and present,
who have always asked for the impossible.
About the Reviewers
Ralf Becher has worked as an IT system architect and as an IT consultant since
1989 in the areas of banking, insurance, logistics, automotive, and retail. He founded
TIQ Solutions in 2004 with partners. Based in Leipzig, his company specializes
in modern, quality-assured data management. Since 2004, his company has been
helping its customers process, evaluate, and maintain the quality of company data,
helping them introduce, implement, and improve complex solutions in the fields
of data architecture, data integration, data migration, master data management,
metadata management, data warehousing, and business intelligence.
Ralf is an internationally-recognized Qlik expert with a strong position in the Qlik
community. He started working with QlikView in 2006, and he has contributed to
QlikView and Qlik Sense extensions. He has also contributed add-on solutions for
data quality and data integration, especially for connectivity in the Java and Big Data
realm. He runs his blog at http://irregular.bi/.
Miguel Ángel García is a business intelligence consultant and QlikView solutions
architect. Having worked through many successful QlikView implementations from
inception to implementation and performed across a wide variety of roles on each
project, his experience and skills range from presales to application development
and design, technical architecture, and system administration, as well as functional
analysis and overall project execution.
Miguel is the coauthor of the book QlikView 11 for Developers, published in November
2012, and its corresponding translation to Spanish, QlikView 11 para Desarrolladores,
published in December 2013. He has also participated as a technical reviewer in
several other QlikView books.
Miguel runs a QlikView consultancy, AfterSync (http://aftersync.com/), through
which he helps customers discover the power of the Qlik platform. He currently has
the QlikView Designer, QlikView Developer, and QlikView System Administrator
certifications, issued by Qlik, for versions 9, 10, and 11.
Michael Tarallo is a senior product marketing manager at Qlik. He has more than
17 years of experience in the Data Integration and Business Intelligence space from
both open source and proprietary BI companies. Currently at Qlik, he is responsible
for a broad spectrum of Marketing and Sales enablement activities for QlikView and
Qlik Sense. He is best known for working with the Qlik Community and providing
its members with valuable information to get them started with Qlik Sense, which
includes the creation of high-quality video content. He has produced numerous
videos ranging from promotional to instructional. Prior to Qlik, Mike worked for
UPS, Information Builders, Pentaho, and Expressor. His career has spanned from
data analysis, customer support, and account management to a solution architect and
leader, crafting customer solutions, and painting visions of the "art of the possible"
with the companies' software. He humbly admits that he is "a confident jack of all
trades but a master of many."
www.PacktPub.com
eBooks, discount offers, and more
Did you know that Packt offers eBook versions of every book published, with PDF
and ePub files available? You can upgrade to the eBook version at www.PacktPub.
com and as a print book customer, you are entitled to a discount on the eBook copy.
Get in touch with us at [email protected] for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign
up for a range of free newsletters and receive exclusive discounts and offers on Packt
books and eBooks.
TM
https://www2.packtpub.com/books/subscription/packtlib
Do you need instant solutions to your IT questions? PacktLib is Packt's online digital
book library. Here, you can search, access, and read Packt's entire library of books.
Why subscribe?
• Fully searchable across every book published by Packt
• Copy and paste, print, and bookmark content
• On demand and accessible via a web browser
Instant updates on new Packt books
Get notified! Find out when new books are published by following @
PacktEnterprise on Twitter or the Packt Enterprise Facebook page.

Table of Contents
Preface vii
Chapter 1: Data Visualization Strategy 1
Data exploration, visualization, and discovery 2
Data teams and roles 4
Data research and development 5
Data governance team 8
Agile development 10
User story 11
Minimum Viable Product 11
QlikView Deployment Framework 14
Exercise 1 15
Summary 15
Chapter 2: Sales Perspective 17
Sales perspective data model 18
Exercise 2.1 19
Data quality issues 22
Missing dimension values 22
Missing fact values 24
Data formatting and standardization 26
Case 26
Unwanted characters 27
Dates and time 27
Master calendar 28
Customer stratification. 30
Pareto analysis 30
Exercise 2.2 31
Exercise 2.3 34
[ i ]