Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Predictive Analytics using Rattle and Qlik Sense
  • Toc
  • feedback
Predictive Analytics using Rattle and Qlik Sense

Predictive Analytics using Rattle and Qlik Sense

By : Ferran Garcia Pagans, Fernando G Pagans
4 (5)
close
Predictive Analytics using Rattle and Qlik Sense

Predictive Analytics using Rattle and Qlik Sense

4 (5)
By: Ferran Garcia Pagans, Fernando G Pagans

Overview of this book

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 you have some basic knowledge of statistics and a spreadsheet editor such as Excel, but knowledge of QlikView is not required.
Table of Contents (11 chapters)
close
close
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
1. Getting Ready with Predictive Analytics
chevron up
1. Getting Ready with Predictive Analytics
Analytics, predictive analytics, and data visualization
Purpose of the book
Introducing R, Rattle, and Qlik Sense Desktop
Installing the environment
Downloading and installing Rattle
Installing Qlik Sense Desktop
Exploring Qlik Sense Desktop
Further learning
Summary
2
2. Preparing Your Data
2. Preparing Your Data
Datasets, observations, and variables
Loading data
Transforming data
Cleaning up
Exporting data
Further learning
Summary
3
3. Exploring and Understanding Your Data
3. Exploring and Understanding Your Data
Text summaries
Visualizing distributions
Correlations among input variables
Further learning
Summary
4
4. Creating Your First Qlik Sense Application
4. Creating Your First Qlik Sense Application
Customer segmentation and customer buying behavior
Loading data and creating a data model
Creating a simple data app
Associative logic
Creating charts
Analyzing your data
Further learning
Summary
5
5. Clustering and Other Unsupervised Learning Methods
5. Clustering and Other Unsupervised Learning Methods
Machine learning – unsupervised and supervised learning
Further learning
Summary
6
6. Decision Trees and Other Supervised Learning Methods
6. Decision Trees and Other Supervised Learning Methods
Partitioning datasets and model optimization
Decision Tree Learning
Entropy and information gain
Underfitting and overfitting
Using a Decision Tree to classify credit risks
Ensemble classifiers
Other models
Further learning
Summary
7
7. Model Evaluation
7. Model Evaluation
Cross-validation
Regression performance
Measuring the performance of classifiers
Further learning
Summary
8
8. Visualizations, Data Applications, Dashboards, and Data Storytelling
8. Visualizations, Data Applications, Dashboards, and Data Storytelling
Data visualization in Qlik Sense
Data analysis, data applications, and dashboards
Data storytelling with Qlik Sense
Further learning
Summary
9
9. Developing a Complete Application
9. Developing a Complete Application
Understanding the bike rental problem
Exploring the data with Qlik Sense
Creating a Qlik Sense App to control the activity
Using Rattle to forecast the demand
Model evaluation
Further learning
Summary
10
Index
Index

Installing the environment

In the examples, we'll use Rattle and Qlik Sense Desktop, but, as we've explained, Rattle is an R package and we need to install R too. We will follow these steps:

  1. Download and install R.
  2. Download and install Rattle.
  3. Download and install Qlik Sense Desktop.

Downloading and installing R

These steps must be followed for installing R:

  1. Go to the homepage of R Project for Statistical Computing at www.r-project.org.
  2. In the navigation bar, click on Comprehensive R Archive Network (CRAN) and you will be redirected to a list of CRAN mirrors. Choose a download mirror that is the closest to your geographic location, as shown here:
    Downloading and installing R
  3. You will reach a different page; choose Download R for Windows, and in the following page click on install R for the first time.
  4. Finally, you will reach the download page. As of writing this book, the latest version for Windows was 3.1.2. Click on Download R 3.1.2 for Windows to download the installation program, as shown in this screenshot:
    Downloading and installing R
  5. Run the installation program, R-3.1.2-win.exe, to start the process. Depending on the level of security of your system, it will ask you for permission to execute the program and to make modifications on your system. You have to allow this to start the process.
  6. In the next step, you have to choose a language; choose English. For the rest of the installation process, leave the default options.
  7. When the installation process finishes, you will have two new icons on your desktop—R i386 3.1.2 and R x64 3.1.2; use the first one if you are using a 32-bit computer and the second one if you are using a 64-bit computer:
    Downloading and installing R

Starting the R Console to test your R installation

The R Console is a window used to interact with R language; you can type commands and functions here, and you will see the results in the same window. We will not focus on R, so we'll only learn the commands needed to work with Rattle.

The following steps are needed to start and close R Console:

  1. Double-click the R icon to start the R Console.
  2. To exit the R Console, type q() and press Enter, as shown here:
    Starting the R Console to test your R installation
End of Section 5
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete