Book Image

Predictive Analytics Using Rattle and Qlik Sense

By : Ferran Garcia Pagans, Fernando G Pagans
Book Image

Predictive Analytics Using Rattle and Qlik Sense

By: Ferran Garcia Pagans, Fernando G Pagans

Overview of this book

Table of Contents (16 chapters)
Predictive Analytics Using Rattle and Qlik Sense
About the Author
About the Reviewers


Today, a lot of organizations are investing in improving their analytics skills and tools. They know that, by analyzing their data, they can improve the performance of their business process and achieve real value from that.

The objective of this book is to introduce you to predictive analytics and data visualization by developing some example applications. We'll use R and Rattle to create the predictive model and Qlik Sense to create a data application that allows business users to explore their data.

We use Rattle and Qlik Sense to avoid learn programming and focus on predictive analytics and data visualizations concepts.

What this book covers

Chapter 1, Getting Ready with Predictive Analytics, explains the key concepts of predictive analytics and how to install our learning environments, such as Qlik Sense, R, and Rattle.

Chapter 2, Preparing Your Data, covers the basic characteristics of datasets, how to load a dataset into Rattle, and how to transform it. As data is the basic ingredient of analytics, preparing the data to analyze it is the first step.

Chapter 3, Exploring and Understanding Your Data, introduces you to Exploratory Data Analysis (EDA) using Rattle. EDA is a statistical approach to understanding data.

Chapter 4, Creating Your First Qlik Sense Application, discusses how to load a dataset into Qlik Sense, create a data model and basic charts, and explore data using Qlik Sense. Using Exploratory Data Analysis and Rattle to understand our data is a very mathematical approach. Usually, business users prefer a more intuitive approach, such as Qlik Sense

Chapter 5, Clustering and Other Unsupervised Learning Methods, covers machine, supervised, and unsupervised learning but focuses on unsupervised learning We create an example application using K-means, a classic machine learning algorithm. We use Rattle to process the dataset and then we load it into Qlik Sense to present the data to the business user.

Chapter 6, Decision Trees and Other Supervised Learning Methods, focuses on supervised learning. It helps you create an example application using Decision Tree Learning. We use Rattle to process the data and Qlik Sense to communicate with it.

Chapter 7, Model Evaluation, explains how to evaluate the performance of a model. Model evaluation is very useful to improve the performance.

Chapter 8, Visualizations, Data Applications, Dashboards, and Data Storytelling, focuses on data visualization and data storytelling using Qlik Sense.

Chapter 9, Developing a Complete Application, explains how to create a complete application. It covers how to explore the data, create a predictive model, and create a data application.

What you need for this book

To install our learning environment and complete the examples, you need a 64-bit computer:

  • OS: Windows 7, Windows 8, or 8.1

  • Processor: Intel Core2 Duo or higher

  • Memory: 4 GB or more

  • .NET Framework: 4.0

  • Security: Local admin privileges to install R, Rattle, and Qlik Sense.

Who this book is for

If you are a business analyst who wants to understand how to improve your data analysis and how to apply predictive analytics, then this book is ideal for you. This book assumes that you to have some basic knowledge of QlikView, but no knowledge of implementing predictive analysis with QlikView. It would also be helpful to be familiar with the basic concepts of statistics and a spreadsheet editor, such as Excel.


In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "After you have downloaded it, type library(rattle) and R will load the Rattle package into memory, and you will be able to use it."

A block of code is set as follows:

If Purpose = 'Education' AND Sex = 'male' AND Age > 25 Then No Default
If Purpose = 'Education' AND Sex = 'male' AND Age < 25 Then Yes Default

New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "Don't be afraid, we will use two software tools Rattle and Qlik Sense Desktop in order to avoid complex code."


Warnings or important notes appear in a box like this.


Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or disliked. Reader feedback is important for us as it helps us develop titles that you will really get the most out of.

To send us general feedback, simply e-mail , and mention the book's title in the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide at

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Downloading the example code

You can download the example code files from your account at for all the Packt Publishing books you have purchased. If you purchased this book elsewhere, you can visit and register to have the files e-mailed directly to you.

Downloading the color images of this book

We also provide you with a PDF file that has color images of the screenshots/diagrams used in this book. The color images will help you better understand the changes in the output. You can download this file from


Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you could report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting, selecting your book, clicking on the Errata Submission Form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded to our website or added to any list of existing errata under the Errata section of that title.

To view the previously submitted errata, go to and enter the name of the book in the search field. The required information will appear under the Errata section.


Piracy of copyrighted material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works in any form on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors and our ability to bring you valuable content.


If you have a problem with any aspect of this book, you can contact us at , and we will do our best to address the problem.