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

Related Content you might be interested in

Current Title:

Small book image
Predictive Analytics Using Rattle and Qlik Sense
Ferran Garcia Pagans | Fernando G Pagans
Jun, 2015 | 242 pages
No titles found
Table of Contents (16 chapters)
Predictive Analytics Using Rattle and Qlik Sense
Predictive Analytics Using Rattle and Qlik Sense
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Getting Ready with Predictive Analytics
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
Preparing Your Data
Preparing Your Data
Datasets, observations, and variables
Loading data
Transforming data
Cleaning up
Exporting data
Further learning
Summary
3
Exploring and Understanding Your Data
Exploring and Understanding Your Data
Text summaries
Visualizing distributions
Correlations among input variables
Further learning
Summary
4
Creating Your First Qlik Sense Application
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
Clustering and Other Unsupervised Learning Methods
Clustering and Other Unsupervised Learning Methods
Machine learning – unsupervised and supervised learning
Further learning
Summary
6
Decision Trees and Other Supervised Learning Methods
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
Model Evaluation
Model Evaluation
Cross-validation
Regression performance
Measuring the performance of classifiers
Further learning
Summary
8
Visualizations, Data Applications, Dashboards, and Data Storytelling
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
Developing a Complete Application
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
Index
Index

Loading data

In Rattle, you have to explicitly declare the role of each variable. A variable can have five different roles:

  • Input: The prediction process will use input variables to predict the value of the target variable.

  • Target: The target variable is the output of our model.

  • Risk: The risk variable is a measure of the target variable.

  • Ident or Identifier: An identifier is a variable that identifies a unique occurrence of an object. In our preceding example, the variable Person is an identifier that identifies a unique person.

  • Ignore: A variable marked Ignore will be ignored by the model. We'll come back to this role later-some variables can create noise and decrease the performance of your predictive model.

Rattle can load data from many data sources. Here are some options:

  • Use the Spreadsheet option to load data from a Comma Separated Value (CSV) file.

  • Open Database Connectivity (ODBC) is a standard to define database connectivity. Using this standard, you can load from most common databases...

Previous Section
End of Section 3
Next Section