Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Implementing Qlik Sense

You're reading from Implementing Qlik Sense Design, Develop, and Validate BI solutions for consultants

Product type Paperback

Published in Oct 2017

Publisher Packt

ISBN-13 9781786460448

Length 438 pages

Edition 1st Edition

Tools

Qlik Sense

Concepts

Business Intelligence

Authors (2):

Solanki

Hegde

View More author details

Table of Contents (18) Chapters

Title Page

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Customer Feedback

Preface

1. Consultant - An Introduction

2. Preparing for the Project FREE CHAPTER

3. Prerequisites to Start a Project

4. Requirement Gathering

5. Architecture Design

6. Development

7. Validation, UAT and Go-Live

8. Post Go-Live

9. Avoiding Common Pitfalls

10. Knowledge Sets

11. A Real Life Case-Study

Data extraction process

The process of fetching the data from various source databases for further transformation and utilization in development of dashboard is the Data Extraction Process for Qlik Sense projects.

Data extraction is the starting step towards building the Qlik Sense dashboards. This process involves fetching the data from one or more databases, and merging and transforming them in such a way that it can be visualized graphically and an analysis can be done on that.

Qlik Sense uses the Extract, Transform, and Load (ETL) process to prepare the data for dashboard usage. Let us have a detailed look at the ETL process.

Extract, Transform, and Load (ETL)

ETL is the process used to create a data mart and data warehouse. In this process, the data is pulled from various data sources, then transformed into the required format by applying the business logic, and then stored back in the destination database, which could be the data warehouse.

Note

The main element of this process is the staging...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at £13.99/month. Cancel anytime

Authors (2)

Solanki

Solanki

Kaushik Solanki is a computer engineer by profession. He is working at Predoole Analytics Pvt Ltd as Qlik Architect & Delivery Manager. He holds overall 9 years of experience working on Qlik technology. His passion is to educate everyone about "Data Literacy" and "Qlik". He loves to spend time on Qlik community to help Qlik developers to learn and excel. He has a great understanding of project delivery right from the business requirement to final implementation. His experience in various domains has helped business to take valuable business decisions.

See other products by Solanki

Hegde

Hegde

Ganapati Hegde is an engineer by background. He carries an overall IT experience of over 16 years. He is very passionate about technology and is always looking out to learn newer technologies. He started his IT career with SK International where he headed Software Services and worked with myriad of technologies, including programming, databases, IT security, application virtualization, and cloud services. During his stint with SK International, he was involved in lot of integration projects and thus has good knowledge on API/SDK. He was instrumental in setting up practices such as RSA, Citrix, Oracle, and Salesforce. He is currently working with Predoole Analytics, an award winning Qlik partner in India, in the presales role. He has worked on BI projects in several industry verticals and works closely with customers, helping them in their BI strategies. His experience in other aspects of IT, like application design and development, cloud computing, networking, and IT Security, helps him to design perfect BI solutions. He conducts workshops to increase user awareness and drive adoption. He works on analysis of unstructured time stamped data and IOT as well, allowing customer to get business insights and help improve efficiency. This is being done with the help of big data platform Khika, which does real time co-relation of log data across sources. This helps customers mitigate risk and help in IT Audit and Compliance. Ganapati is now working on improving his knowledge of advanced analytics using technologies like R and python.

See other products by Hegde

Other recommended products

Related to this chapter

Hands-On Business Intelligence with Qlik Sense

Hands-On Business Intelligence with Qlik Sense

This book is an excellent entry-level guide for all aspiring Qlik Sense developers to create applications in Qlik Sense Desktop to obtain daily insights at work. You'll be able to implement what you've learned to overcome in day-to-day stumbling blocks faced in the BI domain.

Feb 2019 14h 44m

Qlik Sense Cookbook

Qlik Sense Cookbook

An expert Qlik Sense user can use its features for business intelligence in an enterprise environment effectively. This book is for people who are looking to create fully featured desktop applications to gain additional business insights in the workplace. It also includes features added recently to Qlik Sense such as Aggr and Data stories.

Aug 2018 11h 8m

Mastering Qlik Sense

Mastering Qlik Sense

This book is your one-stop guide to mastering Qlik Sense, catering for all your organizational BI needs. You'll see how you can seamlessly navigate through tons of organizational data from multiple sources and create smart visualizations that meet your unique business needs.

Mar 2018 17h 8m

QlikView for Developers

QlikView for Developers

QlikView is a BI platform for end-to-end business analytics. This hands-on guide will help you to implement QlikView, load different types of data into it, and model it effectively. You'll also write scripts for handling complex data transformations and organize QlikView projects in a way that's most productive for all stakeholders.

Jun 2017 18h 12m

Pocket CIO - The Guide to Successful IT Asset Management

Pocket CIO - The Guide to Successful IT Asset Management

IT Asset Management (ITAM) supports life cycle management and strategic decision making for an IT environment. This book is a detailed IT Asset Management (ITAM) guidebook with real-world templates that can be converted into working ITAM documents. It is a step-by-step IT asset management manual for the newbies as well as the seasoned ITAM veterans, providing a unique insight into asset management. It discusses how risk management has changed over time and the possible solutions needed to address the new normal. The book also includes considerations for selecting the best technology for a specific company including what questions should be asked at the onset, as well as the best ways to manage a software audit and how to be prepared for one.

Mar 2018 8h 16m

Implementing Microsoft Dynamics 365 for Finance and Operations

Implementing Microsoft Dynamics 365 for Finance and Operations

Microsoft Dynamics 365 aims to bring the worlds of CRM and ERP together for better business implementations and management. This book will help you to effectively implement Dynamics 365 for Finance and Operations, Enterprise edition in your organization, and seamlessly migrate all processes and data from traditional or older versions.

Sep 2017 18h 44m

Max Fatourechi shares his decades of experience building successful CRM systems that make a real difference to business performance. Through clear processes, actionable advice, and informative case studies, The Art of CRM teaches you to design successful CRM systems for your clients

May 2019 12h 0m

Personalised recommendations for you

Based on your interests and search pattern

Mathematics of Machine Learning

Mathematics of Machine Learning

Deepen your theoretical knowledge and enhance your ability to solve complex machine learning problems with structured guidance. Gain the confidence to engage with advanced ML literature and tailor algorithms to meet your project requirements.

May 2025 24h 20m

Generative AI with Python and PyTorch

Generative AI with Python and PyTorch

Learn how to create images and text using VAEs, GANs, LSTMs, and transformers. Implement applications in natural language processing and computer vision through practical tutorials.

Mar 2025 15h 0m

Practical Generative AI with ChatGPT

Practical Generative AI with ChatGPT

This book helps you unlock ChatGPT's potential to make your working life better. From prompt engineering to creating custom GPTs, you'll enhance your productivity, creativity, and efficiency with practical insights and advanced techniques.

Apr 2025 12h 52m

Generative AI with LangChain

Generative AI with LangChain

Gain a solid foundation in LangChain, agentic AI, and LangGraph, and learn to build production-ready systems with multi-agent architectures, advanced RAG pipelines, Tree of Thought reasoning, agent handoffs, and fine-grained error handling.

May 2025 15h 52m

Architecting Power BI Solutions in Microsoft Fabric

Architecting Power BI Solutions in Microsoft Fabric

Power BI provides several options to solve common data problems, and designing the correct solution for each scenario can be a daunting task. This book makes it easier by guiding you through designing optimal solutions using Power BI.

Apr 2025 14h 16m

Microsoft Identity and Access Administrator SC-300 Exam Guide

Microsoft Identity and Access Administrator SC-300 Exam Guide

This comprehensive guide covers key topics such as Microsoft Entra ID implementation, authentication and access management, external user management, and hybrid identity solutions, providing practical insights and techniques for SC-300 exam success.

Mar 2025 19h 48m

LLM Design Patterns

LLM Design Patterns

This book helps you gain practical skills to develop and deploy LLMs. You'll learn data prep, training, pruning, quantization, and evaluation, as well as explore RAG, advanced prompting, and optimization to build robust, scalable language models.

May 2025 17h 48m

Tableau Cookbook for Experienced Professionals

Tableau Cookbook for Experienced Professionals

Advance your Tableau knowledge beyond the basics, streamline dashboard performance, tackle advanced geospatial challenges, and unlock API potential while fortifying your corporate data infrastructure with proven best practices.

Apr 2025 12h 24m

Time Series Analysis with Spark

Time Series Analysis with Spark

This book offers a complete guide to time series analysis with Apache Spark and Databricks, covering essential concepts and advanced techniques including Generative AI to equip readers with skills for real-world challenges across industries.

Mar 2025 9h 56m

Hands-On Artificial Intelligence for IoT

Hands-On Artificial Intelligence for IoT

Transform IoT systems with the power of artificial intelligence using this hands-on guide. Dive into practical techniques and expert insights to innovate and optimize your IoT devices, making them smarter and more efficient.

May 2025 15h 44m