Qlik Sense Cookbook
Second Edition
Over 80 recipes on data analytics to solve business intelligence challenges
Pablo Labbe
Philip Hand
Neeraj Kharpate
BIRMINGHAM - MUMBAI
Qlik Sense CookbookSecond Edition
Copyright 2018 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(s), nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been 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.
Commissioning Editor: Sunith Shetty
Acquisition Editor: Prachi Bisht
Content Development Editor: Amrita Noronha
Technical Editor: Sneha Hanchate
Copy Editor: Safis Editing
Project Coordinator: Namrata Swetta
Proofreader: Safis Editing
Indexer: Priyanka Dhadke
Graphics: Jisha Chirayil
Production Coordinator: Aparna Bhagat
First published: November 2015
Second edition: August 2018
Production reference: 1280818
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.
ISBN 978-1-78899-705-8
www.packtpub.com
mapt.io
Mapt is an online digital library that gives you full access to over 5,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.
Why subscribe?
- Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals
- Improve your learning with Skill Plans built especially for you
- Get a free eBook or video every month
- Mapt is fully searchable
- Copy and paste, print, and bookmark content
PacktPub.com
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 service@packtpub.com 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.
Contributors
About the authors
Pablo Labbe is a BI consultant with over 20 years' experience. In 2008 he was introduced to Qlikview, a former product by Qlik and the seed for Qlik Sense. Since then, he has focused on delivering BI solutions in a new way. Now he is the Principal of ANALITIKA Inteligencia, delivering BI projects and training on Qlik products and other technologies that embrace the self-service BI. Pablo is an active member of the Qlik community and other social media sites.
I want to thank the people who have been close to me and supported me, especially my wife, Daniela, and my children.
Philip Hand is a senior BI consultant who has worked with QlikView in the BI space for over 7 years. He has implemented end-to-end solutions in a wide variety of enterprises and for large business customers. He has spent many years consulting on business and QlikView solutions. His belief is that such a role proves invaluable to hone your skills through exposure to many different businesses, problems, technologies, industries, and people.
Neeraj Kharpate works as an independent BI consultant providing services to clients from various industries. Neeraj embarked on his journey with Qlik in mid-2007. He has over 10 years of experience working with clientele from multiple sectors, ranging from banks and insurance to retail. Neeraj has been closely following the developments in Qlik Sense ever since it was launched in 2014 and is actively involved with its enterprise-wide implementations.
About the reviewer
Marcio Lins was born in Guarabira, Brazil, on June 21, 1983. He is the founder of the IMWTI (2012), a Qlik solution provider partner, a Certified Scrum Master, and a Qlik developer leader. He has worked more than 10 ERP and other technologies (PHP, C#, and Clipper). He specializes in the Qlik API, from bots to integration with corporate systems.
Packt is searching for authors like you
If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.
Preface
Qlik Sense is a powerful, self-servicing business intelligence (BI) tool for data discovery, analytics, and visualization. It allows you to create personalized BI solutions from raw data and get actionable insights from it.
This book is an excellent guide for all aspiring Qlik Sense developers. It will take you from the basics, right through to the use of more advanced functions. With the recipes in this book, you will be empowered to create fully featured desktop applications in Qlik Sense.
Starting with a quick refresher on obtaining data from data files and databases, this book moves on to the more refined features of Qlik Sense, including visualization, scripting, set analysis, advanced aggregation, and useful extensions. The tips and tricks provided will help you to overcome challenging situations while developing your applications in Qlik Sense. This and more will help you to deliver engaging dashboards and reports efficiently.
By the end of the book, you will be an expert user of Qlik Sense and will be able to use its features effectively for business intelligence in an enterprise environment.
Who this book is for
The book is for anyone who has been exposed to Qlik Sense and wants to start using it actively for BI. Anybody with prior knowledge of its sister product, QlikView, will also benefit from this book. Familiarity with the basics of BI is a prerequisite.
What this book covers
, Getting Started with the Data, introduces the reader to different methods of loading data into Qlik Sense from various sources, such as relational databases, data files, FTP server, and web services. We will also delve into the creation and usage of Master Library in Qlik Sense and Data Manager for data preparation without code.
Next page