Book description
Perform Interactive Data Analysis with Smarter Visualizations and Support your Enterprise-wide Analytical Needs
About This Book
- Get a practical demonstration of discovering data for sales, human resources, and more using Qlik Sense
- Create dynamic dashboards for business intelligence and predictive analytics
- Create and collaborate comprehensive analytical solutions using Rattle and Qlik Sense
Who This Book Is For
This course is for anyone who wishes to understand and utilize the various new approaches to business intelligence actively in their business practice. Knowing the basics of business intelligence concepts would be helpful when picking up this course, but is not mandatory.
What You Will Learn
- Build simple visualization models with Rattle and Qlik Sense Desktop
- Get to grips with the life cycle and new visualization functions of a Qlik Sense application
- Discover simple ways to examine data and get it ready for analysis
- Visualize your data with Qlik Sense's engaging and informative graphs
- Build efficient and responsive Associative Models
- Optimize Qlik Sense for sales, human resources, and demographic data discovery
- Explore various tips and tricks of navigation for the Qlik Sense® front end
- Develop creative extensions for your Qlik Sense® dashboard
In Detail
Qlik Sense is powerful and creative visual analytics software that allows users to discover data, explore it, and dig out meaningful insights in order to make a profit and make decisions for your business. This course begins by introducing you to the features and functions of the most modern edition of Qlik Sense so you get to grips with the application.
The course will teach you how to administer the data architecture in Qlik Sense, enabling you to customize your own Qlik Sense application for your business intelligence needs. It also contains numerous recipes to help you overcome challenging situations while creating fully featured desktop applications in Qlik Sense. It explains how to combine Rattle and Qlik Sense Desktop to apply predictive analytics to your data to develop real-world interactive data applications. The course includes premium content from three of our most popular books:
- Learning Qlik Sense: The Official Guide Second Edition
- Qlik Sense Cookbook
- Predictive Analytics using Rattle and Qlik Sense
On completion of this course, you will be self-sufficient in improving your data analysis and will know how to apply predictive analytics to your datasets. Through this course, you will be able to create predictive models and data applications, allowing you to explore your data insights much deeper.
Style and approach
The course will follow a practical approach with rich set of examples through which it will demonstrate its concepts, features and its implementation. The course will also feature numerous solutions which will cover entire spectrum of BI use cases.
Table of contents
-
Qlik Sense: Advanced Data Visualization for Your Organization
- Table of Contents
- Qlik Sense: Advanced Data Visualization for Your Organization
- Credits
- Preface
-
1. Module 1
- 1. Qlik Sense® and Data Discovery
- 2. Overview of a Qlik Sense® Application's Life Cycle
- 3. Empowering Next Generation Data Discovery Consumers
- 4. Contributing to Data Discovery
- 5. Authoring Engaging Applications
- 6. Building Qlik Sense® Data Models
- 7. Qlik Sense® Apps in the Cloud
- 8. Extending the Qlik® Analytic Platform
- 9. Administering Qlik Sense®
- 10. Sales Discovery
- 11. Human Resource Discovery
- 12. Travel Expense Discovery
- 13. Demographic Data Discovery
-
2. Module 2
-
1. Getting Started with the Data
- Introduction
- Extracting data from databases and data files
- Extracting data from Web Files
- Activating the Legacy Mode in Qlik Sense® desktop
- Extracting data from custom databases
- Invoking help while in the data load editor or the expression editor
- Previewing data in the Data model viewer
- Creating a Master Library from the Data model viewer
- Using a Master Library in the Edit mode
-
2. Visualizations
- Introduction
- Creating Snapshots
- Creating and adding content to a story
- Adding embedded sheets to the story
- Highlighting the performance measure in a bar chart
- Associating persistent colors to field values
- Using the ColorMix1 function
- Composition
- Relationships
- Comparison
- Distribution
- Structuring visualizations
-
3. Scripting
- Introduction
- Structuring the script
- Efficiently debugging the script
- Packaging the code in script files
- How to use sub routines in Qlik Sense®
- Optimizing the UI calculation speed
- Optimizing the reload time of the application
- Using a For Each loop to load data from multiple files
- Using the Concat function to store multiple field values in a single cell
-
4. Managing Apps and User Interface
- Introduction
- Publishing a Qlik Sense® application created in Qlik Sense® desktop
- Creating private, approved, and community sheets
- Publishing a Qlik Sense® application to Qlik Sense® cloud
- Creating geo maps in Qlik Sense®
- Reference lines in Sales versus Target gauge chart
- Effectively using the KPI object in Qlik Sense®
- Creating Tree Maps
- Creating dimensionless bar charts in Qlik Sense®
- Adding Reference Lines to trendline charts
- Creating text and images
- Applying limitations to charts
- Adding thumbnails – a clear environment
- Navigating many data points in a scatter chart
-
5. Useful Functions
- Introduction
- Using an extended interval match to handle Slowly Changing Dimensions
- Using the Previous() function to identify the latest record for a dimensional value
- Using the NetworkDays() function to calculate the working days in a calendar month
- Using the Concat() function to display a string of field values as a dimension
- Using the Minstring() function to calculate the age of the oldest case in a queue
- Using the Rangesum() function to plot cumulative figures in trendline charts
- Using the Fractile() function to generate quartiles
- Using the FirstSortedValue() function to identify the median in a quartile range
- Using the Declare and Derive functions to generate Calendar fields
- Setting up a moving annual total figure
- Using the For Each loop to extract files from a folder
- Using the Peek() function to create a currency Exchange Rate Calendar
- Using the Peek() function to create a Trial Balance sheet
-
6. Set Analysis
- Introduction
- Cracking the syntax for Set Analysis
- Using flags in Set Analysis
- Using the = sign with variables in Set Analysis
- Point in time using Set Analysis
- Using comparison sets in Set Analysis
- Using embedded functions in Set Analysis
- Creating a multi-measure expression in Set Analysis
- Using search strings inside a set modifier
- Capturing a list of field values using a concat() function in Set Analysis
- Using the element functions P() and E() in Set Analysis
- 7. Extensions in Qlik Sense®
-
8. What's New in Version 2.1.1?
- Introduction
- Using the visual exploration capability in Qlik Sense® 2.1.1
- Defining variables in Qlik Sense®
- Exporting stories to MS PowerPoint
- Using the Qlik Dev Hub in Qlik Sense® 2.1.1
- Using Extension editor in Qlik Dev Hub
- Using Qlik Dev Hub to generate mashups
- Embedding Qlik Sense® application on a website using a single configurator
- Using the Qlik DataMarket
- Creating dynamic charts in Qlik Sense®
- Using Smart Search
- Using smart data load profiling
- Conclusion
- A. Appendix
-
1. Getting Started with the Data
-
3. Module 3
- 1. Getting Ready with Predictive Analytics
- 2. Preparing Your Data
- 3. Exploring and Understanding Your Data
- 4. Creating Your First Qlik Sense Application
- 5. Clustering and Other Unsupervised Learning Methods
- 6. Decision Trees and Other Supervised Learning Methods
- 7. Model Evaluation
- 8. Visualizations, Data Applications, Dashboards, and Data Storytelling
- 9. Developing a Complete Application
- A. Bibliography
- Index
Product information
- Title: Qlik Sense: Advanced Data Visualization for Your Organization
- Author(s):
- Release date: December 2017
- Publisher(s): Packt Publishing
- ISBN: 9781788994927
You might also like
book
Practical Big Data Analytics
Get command of your organizational Big Data using the power of data science and analytics About …
book
Hands-On Data Visualization
Tell your story and show it with data, using free and easy-to-learn tools on the web. …
book
Hands-On Business Intelligence with DAX
Implement business intelligence (BI), data modeling, and data analytics within Microsoft products such as Power BI, …
book
Data Science for Business
Written by renowned data science experts Foster Provost and Tom Fawcett, Data Science for Business introduces …