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

Creating a Qlik Sense App to control the activity

In the previous chapter, we explored the DAR approach to develop Qlik Sense applications; in this section, we will use the same approach.

We'll start with the dashboard. At the center, we'll place the most important information or measures. The most important details are the average number of users and the total number of users; these KPIs will occupy the main area of our application. The number of registered and casual users is also important, and we'll keep space for them in the dashboard, as shown here:

During our analysis, we discovered that, in 2012, the number of users increased, and that, during the colder months, we had a lack of activity. I've used a bar chart to show you the difference between 2011 and 2012 and the lack of activity during the winter.

After the dashboard, you will need an analysis sheet to analyze the months that have a lack of activity. In this analysis sheet, we'll include charts with just two metrics—the average...

End of Section 3
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