28,14 €
Mehr erfahren.
- Herausgeber: Packt Publishing
- Kategorie: Wissenschaft und neue Technologien
- Sprache: Englisch
A step-by-step approach to building stunning dashboards with QlikView
Key Features
- Perform effective storytelling through interactive dashboards built with QlikView
- Create different types of visualizations from a variety of data sources
- Includes tips, tricks, and best practices to perform effective Business Intelligence using QlikView
Book Description
QlikView is one of the market leaders when it comes to building effective Business Intelligence solutions. This book will show how you can leverage its power to build your own dashboards to tell your own data story.
The book starts with showing you how to connect your data to QlikView and create your own QlikView application. You will learn how to add data from multiple sources, create a data model by joining data, and then review it on the front end. You will work with QlikView components such as charts, list boxes, input boxes, and text objects to create stunning visualizations that help give actionable business insights. You will also learn how to perform analysis on your data in QlikView and master the various types of security measures to be taken in QlikView.
By the end of this book, you will have all the essential knowledge required for insightful data storytelling and creating useful BI dashboards using QlikView.
What you will learn
- Learn to use the latest and newest features of QlikView
- Connect QlikView to various data sources, such as databases and websites
- Create a fully featured data model without circular references
- Display your data in maps, charts, and text across multiple sheets
- Apply set analysis to your data in QlikView expressions
- Secure your data based on the various audience types
Who this book is for
This book is best suited for BI professionals, data analysts and budding QlikView developers who wish to build effective dashboards using QlikView. Some basic understanding of the data visualization concepts and Business Intelligence is required.
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
Seitenzahl: 106
Veröffentlichungsjahr: 2019
Ähnliche
Hands-On Dashboard Development with QlikView
Copyright © 2019 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 author, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to have been caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
Commissioning Editor: Amey VarangaonkarAcquisition Editor: Devika BattikeContent Development Editor: Nathanya DiasTechnical Editor: Joseph SunilCopy Editor: Safis EditingProject Coordinator: Kirti PisatProofreader: Safis EditingIndexer: Rekha NairGraphics: Jisha ChirayilProduction Coordinator: Saili Kale
First published: March 2019
Production reference: 1150319
Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK.
ISBN 978-1-83864-611-0
www.packtpub.com
Mapt is an online digital library that gives you full access to over 5,000 books and videos, as well as industry leading tools to help you plan your personal development and advance your career. For more information, please visit our website.
Why subscribe?
Spend less time learning and more time coding with practical eBooks and Videos from over 4,000 industry professionals
Improve your learning with Skill Plans built especially for you
Get a free eBook or video every month
Mapt is fully searchable
Copy and paste, print, and bookmark content
Packt.com
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.packt.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at [email protected] for more details.
At www.packt.com, you can also read a collection of free technical articles, sign up for a range of free newsletters, and receive exclusive discounts and offers on Packt books and eBooks.
Contributor
About the author
Abhishek Agarwal has 12+ years' experience in developing analytical solutions. He is a seasoned business intelligence (BI) professional with expertise in multiple technologies. He has been teaching BI technologies for the past 5+ years, working in a similar domain. He uses QlikView, Power BI, Tableau, and a couple of other technologies for end-to-end analytical solution development in his current work.
Packt is searching for authors like you
If you're interested in becoming an author for Packt, please visit authors.packtpub.com and apply today. We have worked with thousands of developers and tech professionals, just like you, to help them share their insight with the global tech community. You can make a general application, apply for a specific hot topic that we are recruiting an author for, or submit your own idea.
Table of Contents
Title Page
Copyright and Credits
Hands-On Dashboard Development with QlikView
About Packt
Why subscribe?
Packt.com
Contributor
About the author
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Reviews
Getting Started with QlikView
Prerequisites
Installing QlikView
Exploring QlikView
Creating a document
Saving the document
Important terminologies in QlikView
QlikView selections
QlikView architecture
Exploring data in QlikView
Summary
Getting Data in QlikView and Creating Your First App
Setting up the structure
Creating an app
Importing data from Excel
Reviewing the data
Understanding facts and dimensions
Dimensions and measures
Best practices for dimensions and facts
Understanding list boxes
Selections in list boxes
Creating new tabs
Adding filters to the app
Summary
Creating Data Models
Creating a star schema
Implementing the star schema
Getting data from databases
Getting data from QVD files
Analyzing the resulting model
Information density
Subset ratio
Tags
Creating a QVD file
Summary
Components in QlikView
List boxes
Layout of columns
Ordering of data
Showing frequency of values
QlikView charts
Changing the chart type
Multi boxes
Properties of multi box
Bookmarks
Properties of bookmarks
Input boxes
Text objects
Summary
Building a Dashboard
Adding KPIs
Adding charts
Block chart
Scatter chart
Pivot table chart
Adding dynamic chart displays
Auto-minimize
Different types of expressions
Group expressions
Drill-down expressions
Containers
Buttons
Summary
Set Analysis
The basics of set analysis
What set analysis means
Set analysis syntax structure
Assignment operators
Assignment operators in action
Set operators
Set operators in action
Element functions
Element functions in action
Summary
Adding Security
Security scripts
Best practices for enabling a security script
Understanding various types of securities
Configuring security
Advanced security
Troubleshooting issues in QlikView
Summary
Other Books You May Enjoy
Leave a review - let other readers know what you think
Preface
QlikView is one of the market leaders when it comes to building effective business intelligence (BI) solutions. This book will show you how you can leverage its power to build your own dashboards to tell your own data story.
The book starts with showing you how to connect your data to QlikView and create your own QlikView application. You will learn how to add data from multiple sources, create a data model by joining data, and then review it on the frontend. You will work with QlikView components, such as charts, list boxes, input boxes, and text objects, to create stunning visualizations that help give actionable business insights. You will also learn how to perform analysis on your data in QlikView and master the various types of security measures to be taken in QlikView.
By the end of this book, you will have all the essential knowledge required for insightful data storytelling and creating useful BI dashboards using QlikView.
Who this book is for
This book is best suited for BI professionals, data analysts, and budding QlikView developers who wish to build effective dashboards using QlikView. Some basic understanding of data visualization concepts and BI is required.
What this book covers
Chapter 1, Getting Started with QlikView, takes us through the architecture of QlikView, its selection methodology, and a quick overview for understanding course coverage and objectives. Finally, we'll see how we can create a new app or document in QlikView.
Chapter 2, Getting Data in QlikView and Creating Your First App, shows us that bringing data into the QlikView system is the first step for dashboard development. In this chapter, you'll create an app and filters to get yourself acquainted with QlikView selection terminologies.
Chapter 3, Creating Data Models, teaches us about data modeling and why it is important for fast and scalable dashboards. In this chapter, you'll create a data model by joining data and then review it in the frontend.
Chapter 4, Components in QlikView, takes us through various QlikView components and their configurations. Some of these components are essential when it comes to using an interactive and user-friendly dashboard.
Chapter 5, Building a Dashboard, shows us how to build a dashboard by adding multiple KPIs and charts. This chapter helps you to understand how you can create dynamic dashboards as well.
Chapter 6, Set Analysis, shows us that set analysis is a powerful way to achieve business metrics. In this chapter, we'll see how we can apply it in QlikView expressions.
Chapter 7, Adding Security, shows you how to secure your data based on the various audience types. Here, you'll learn how you can reduce the data for a particular user based on their credentials.
To get the most out of this book
Some prior knowledge of SQL is preferred when it comes to reading this book. A keen interest in data analytics is also beneficial.
Download the example code files
You can download the example code files for this book from your account at www.packt.com. If you purchased this book elsewhere, you can visit www.packt.com/support and register to have the files emailed directly to you.
You can download the code files by following these steps:
Log in or register at
www.packt.com
.
Select the
SUPPORT
tab.
Click on
Code Downloads & Errata
.
Enter the name of the book in the
Search
box and follow the onscreen instructions.
Once the file is downloaded, please make sure that you unzip or extract the folder using the latest version of:
WinRAR/7-Zip for Windows
Zipeg/iZip/UnRarX for Mac
7-Zip/PeaZip for Linux
The code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/Hands-On-Dashboard-Development-with-QlikView. In case there's an update to the code, it will be updated on the existing GitHub repository.
We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!
Download the color images
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: http://www.packtpub.com/sites/default/files/downloads/9781838646110_ColorImages.pdf.
Conventions used
There are a number of text conventions used throughout this book.
CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "Mount the downloaded WebStorm-10*.dmg disk image file as another disk in your system."
A block of code is set as follows:
='Passengers' & Chr(10) & Chr(10) & Sum(PASSENGERS)
Bold: Indicates a new term, an important word, or words that you see on screen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "So, if these are the three KPIs that you want to track, what you're going to do is right-click on the first object and go to Properties."
Get in touch
Feedback from our readers is always welcome.
General feedback: If you have questions about any aspect of this book, mention the book title in the subject of your message and email us at [email protected].
Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book, we would be grateful if you would report this to us. Please visit www.packt.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details.
Piracy: If you come across any illegal copies of our works in any form on the internet, we would be grateful if you would provide us with the location address or website name. Please contact us at [email protected] with a link to the material.
If you are interested in becoming an author: If there is a topic that you have expertise in, and you are interested in either writing or contributing to a book, please visit authors.packtpub.com.
Reviews
Please leave a review. Once you have read and used this book, why not leave a review on the site that you purchased it from? Potential readers can then see and use your unbiased opinion to make purchase decisions, we at Packt can understand what you think about our products, and our authors can see your feedback on their book. Thank you!
For more information about Packt, please visit packt.com.
