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
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
chevron up
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

Cleaning up

The Cleanup option in the Transform tab allows you to delete columns and observations from your dataset, as shown in this screenshot:

Cleaning up

The following are the different available cleanup options:

  • Delete Ignored: This will delete variables marked as ignore
  • Delete Selected: This will delete the selected variables
  • Delete Missing: This will delete all variables with any missing values
  • Delete Obs with Missing: This will delete observations with missing values in the selected variable

You've learned how to transform variables. When Rattle transforms a variable, it doesn't modify the original one. It creates a new variable with the corresponding modification. If you apply a transformation to the variable Age, you will have the variable Age and the new one. Your algorithms only need one variable, the original or the transformed, so you have to change the role of the one not to be used to Ignore. By default, after the transformation, Rattle sets the original variable to Ignore. In the...

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