- 188 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Creating Stunning Dashboards with QlikView
About this book
Bring real business insights to your company through effective and engaging dashboards in QlikView
About This Book
- Build outstanding dashboards that respond to your company's information needs
- Present the data in efficient and innovative ways to promote insights
- Unleash the true power of QlikView by creating engaging visualizations
Who This Book Is For
This book is focused on QlikView developers with basic knowledge of scripting and layouts who want to improve their designing skills and build effective, eye-catching dashboards that deliver tangible value to their business.
What You Will Learn
- Build a comprehensive library of QlikView components to speed up your developments
- Define a practical roadmap that will help you build business-driven dashboards
- Explore the most effective and engaging ways to present data
- Apply the best practices in the field of data visualization
- Avoid common pitfalls when creating bar, line and pie charts
- Create robust visualizations such as heat maps, histograms and scatter plots
In Detail
QlikView is one of the most powerful analytical tools in the market. Based on an in-memory associative model, it lets users freely navigate through the data, spot trends and make better decisions. This platform is capable of integrating a wide range of data sources like ERP systems, data warehouses or spreadsheets into a single application in order display dashboards with state-of-the-art visualizations.
Creating Stunning Dashboards with QlikView is an easy to follow handbook that guides you through the process of creating an effective and engaging dashboard that delivers tangible value to the business. It starts with the identification of the business needs and the definition of the main KPIs, and takes you all the way to the application rollout.
Throughout the book, you will learn how to apply some of the best practices in the field of data visualization, create a robust navigation schema, chose the best chart types for each scenario and many other things that will help you create effective dashboards that uncover all the stories behind the data.
Style and approach
This easy-to-follow compilation of best practices, tips, and tricks will help you leverage your QlikView developments. Each section presents practical guidelines to help you create dashboards that are not only functional, but also engaging and compelling.
Tools to learn more effectively
Saving Books
Keyword Search
Annotating Text
Listen to it instead
Information
Creating Stunning Dashboards with QlikView
Table of Contents
Creating Stunning Dashboards with QlikView
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Instant updates on new Packt books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Know Your Battlefield, Devise Your Strategy
Dashboards in perspective
Step 1 – define your audience
Step 2 – spot the business need
Step 3 – choose the right KPIs
Metrics that matter
Step 4 – get to know your data sources
Step 5 – tell a story
Step 6 – enjoy the process
Creating the perfect dashboard
Don't overdo it
Embrace simplicity
Timely feedback
Summary
2. All about Dashboard Design Best Practices
Dashboard design best practices
Gestalt principles
Giving context to the data
Data-Ink Ratio
Avoiding chart junk
Balance
Excessive precision
3-D charts
Sorting
Alignment and distribution
Animations
Avoid scroll bars
Consistency
White space
Applying makeup
Meaningless variety
Choosing your weapon
Level of accuracy
Types of analysis
Bar charts
Dot plots
Line charts
Stacked area charts
Combo charts
Slope charts
Radar charts
Pie charts
Other area charts
Stacked bar charts
Scatter plots
Tables
Gauges and other forms of display for KPIs
Other representations
Summary
3. First Things First – The Dashboard Structure
Dashboard style
Document style
Fonts
Colors
Backgrounds
Design resolution
Layout and distribution
Filter panes
Filter presentation
Hidden Filter Pane
Current selections
General navigation
Tab row
Showing and hiding objects
Logos
Summary
4. It's Not Only about Charts
Text objects
More than simple labels
Displaying KPIs
Creating hierarchies
Selection prerequisites
Controlling variables
Transparent buttons
Creating switches
Interactive KPI display
Unconventional visualizations
Handcrafted dashboards
Tables
Spicing up tables
Adding colors
The visual cues tab
Expression attributes
Custom Format Cell
Traffic lights and icons
Traffic light gauges
Icons and images
Loading images to QlikView
Other visual cues
Embedding charts
Sparklines
Linear gauges
Mini bar charts
Tips and tricks – tables
Minimalistic tables
Spacing
Dimensionless tables
Removing zeroes and nulls
Stripes
Leave the hashtags for Twitter
Ad hoc analysis
Accumulation
Quirky tables
Reducing functionality
Summary
5. Handling "The Classics"
About "the classics"
Structure
Chart orientation
Formatting chart axes
Forced zero axis
Unwanted selections
Limited dimensions and scroll bars
To stack or not to stack
Changing the classic perspectives
Defending the indefensible – pie charts
Special icons
Let the color talk
Legen… wait for it… dary
Labeling best practices
Enhancing the classics: tips and tricks
Twin bar chart
Completion chart
Dot plot
Waterfall chart
Waterfall chart – Vol. 2
Control chart
Slope chart
Variance highlight
Line styles
Bar heat map
Summary
6. Creating Complex Visualizations
Histograms
Scatter plots
How to read this chart
Color highlight
Gauges, gauges, gauges!
Geographic representations
Is that a table?
The waffle chart
Table infographics
Heat maps
Overlapping objects
Range charts
Overlapping charts – other examples
Crusted line chart
Pie gauge
Area infographics
Extensions
Summary
7. Enhance Your QlikView Experience
Folder structure
Opening and closing scripts
Subroutines
Variables – making your life easier
Formulas and Set Analysis
Handling colors with variables
Backgrounds
Icons, symbols, and buttons
Color palettes
The object repository
Keeping in shape
Summary
8. Before You Go
Before the rollout
Locking objects
The application datasheet
In-chart help
The dashboard cover
Dashboard testing
Documentation and backups
The 10 commandments of QlikView design
After the rollout
Sell it!
Dashboard navigation course
Maintenance
Summary
Index
Creating Stunning Dashboards with QlikView
Copyright © 2015 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the au...
Table of contents
- Creating Stunning Dashboards with QlikView
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access Creating Stunning Dashboards with QlikView by Julian Villafuerte in PDF and/or ePUB format, as well as other popular books in Computer Science & Entreprise Applications. We have over one million books available in our catalogue for you to explore.