Packt+ | Advance your knowledge in tech (2024)

You're reading fromHands-On Business Intelligence with Qlik Sense

Product typeBook

Published inFeb 2019

PublisherPackt

ISBN-139781789800944

Pages442 pages

Edition1st Edition

Languages

Concepts

Business Intelligence

Authors (4):

Packt+ | Advance your knowledge in tech (2)Pablo Labbe

Pablo Labbe

Pablo is a Business Intelligence Consultant with over 18 years of experience. In 2008 he was presented to Qlikview, the former product by Qlik and the seed for Qlik Sense. Since that year he was focused on delivering BI solutions in a new way. Now he is the Principal of ANALITIKA Inteligencia delivering BI projects and training focusing on Qlik products and other technologies that embrace the Self-Service BI. He is an active member of the Qlik Community and other social media sites. You can follow him on Twitter - @pablolabbe and LinkedIn.

See other products by Pablo Labbe

Packt+ | Advance your knowledge in tech (3)Clever Anjos

Clever Anjos

Clever Anjos is an experienced Business Discovery professional having several years working experience with Qlik, Microsoft and others BI technologies. He holds a Bachelor in Computer Science from Universidade Federal de Uberlândia (Minas Gerais State - Brazil). He works at Qlik as a Solution Architect helping companies to use the Qlik technologies to enable their professionals to be data literate persons. He has several Qlik Certifications and Awards (Qlik Luminary, Qlik MVP and Presales "Rookie of The Year" - Americas 2018)

See other products by Clever Anjos

Packt+ | Advance your knowledge in tech (4)Kaushik Solanki

Kaushik 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 Kaushik Solanki

Packt+ | Advance your knowledge in tech (5)Jerry DiMaso

Jerry DiMaso is an Analytics Advisory Consultant who has spent the past ten years developing applications, advising on data and analytics strategies, and coaching organizations on how to build efficient analytics operating models. His work in more than 100 organizations in dozens of different industries has inspired him to take on the mission of improving the world's analytics capabilities through a series of practical frameworks and methodologies, most notably the Analytics Enablement and Axis Academy programs he created.

See other products by Jerry DiMaso

View More author details

Table of Contents (18) Chapters

Preface

  • Who this book is for
  • What this book covers
  • To get the most out of this book
  • Get in touch

1. Section 1: Qlik Sense and Business Intelligence

    2. Getting Started with Qlik Sense

    • An overview of the Qlik Sense product
    • Summary

    3. Section 2: Data Loading and Modeling

      4. Loading Data in Qlik Sense

      • Technical requirements
      • Data loading process
      • Table associations
      • Data profiling
      • Summary
      • Further reading

      5. Implementing Data Modeling Techniques

      • Technical requirements
      • An overview of data modeling
      • Joining
      • Concatenation
      • Filtering
      • QVDs
      • Link table
      • Canonical dates
      • As-Of Table
      • Script optimization
      • Summary
      • Sample questions
      • Further reading

      6. Section 3: Building an Analytical Application

        7. Working with Application Structure

        • Technical requirements
        • Application overview
        • Understanding the DAR methodology
        • Creating visualization objects
        • Creating Master items
        • Calculation expressions
        • Summary
        • Questions
        • Further reading

        8. Creating a Sales Analysis App Using Qlik Sense

        • Technical requirements
        • Creating the dashboard sheet
        • Creating the analysis sheets
        • Creating a reporting sheet
        • Summary

        9. Interacting with Advanced Expressions

        • Technical requirements
        • Creating calculations with conditions
        • Using TOTAL for aggregation scope
        • Using some useful inter-record functions
        • Using AGGR for advanced aggregation
        • Leveraging Set Analysis for in-calculation selection
        • Summary
        • Further reading

        10. Creating Data Stories

        • An overview of stories
        • Creating snapshots
        • Planning and organizing your presentation
        • Creating stories
        • Editing your story
        • Sharing stories
        • Summary
        • Further reading

        11. Section 4: Additional Features

          12. Engaging On-Demand App Generation

          • Technical requirements
          • How Qlik Sense handles large volumes of data
          • Setting up a Google BigQuery account
          • Configuring Qlik Sense for ODAG applications
          • Building a summarized application
          • Building the detailed application
          • Integrating the summarized and detailed applications
          • Summary
          • Further reading

          13. Creating a Native Map Using GeoAnalytics

          • Technical requirements
          • Concepts of GeoAnalytics
          • Creating a map
          • Adding more information to the map
          • Summary
          • Further reading

          14. Working with Self-Service Analytics

          • Technical requirements
          • Creating self-service analytics
          • Sharing insights with community sheets
          • Approving sheets to add them to a baseline
          • Co-creating applications in Qlik Sense Cloud Business
          • Summary
          • Further reading

          15. Data Forecasting Using Advanced Analytics

          • Technical requirements
          • Qlik Sense Engine and Server Side Extensions
          • Preparing your R environment
          • Using the R extension in a Qlik Sense application
          • Preparing your Python environment
          • Using a Python extension
          • Using the Python SSE in your apps
          • Summary
          • Questions
          • Further reading

          16. Deploying Qlik Sense Apps for Mobile/Tablets

          • Technical requirements
          • Setting up the Sales Analysis app for mobile usage
          • Choosing the right client
          • Preparing the Sales Analysis app for offline usage
          • Summary

          17. Other Books You May Enjoy

          • Leave a review - let other readers know what you think

          You will learn how to analyze the data loaded using several visualization objects in the Qlik Sense app and share the app through Qlik Sense Enterprise or Qlik Sense Cloud.

          The following chapters will be covered in this section:

          • Chapter 4, Working with Application Structure
          • Chapter 5, Creating a Sales Analysis App Using Qlik Sense
          • Chapter 6, Interacting with Advanced Expressions
          • Chapter 7, Creating Data Stories

          Packt+ | Advance your knowledge in tech (6)The rest of the chapter is locked

          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

          Renews at £13.99/month. Cancel anytime

          Start free trial

          Previous Chapter

          Chapter 1 of 18

          Next Chapter

          Other recommended products

          Related to this chapter

          Qlik Sense CookbookAn 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 201811 hours 8 minutes
          Mastering Qlik SenseThis 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 201817 hours 8 minutes
          Implementing Qlik SenseDeveloping a successful business intelligence solution takes more than just the knowledge of Qlik Sense. With Business Analytics becoming popular, it’s now becoming imperative for a Qlik Developer to scale up to the next level. This book will you with the right implementations needed for your organization to scale to new levels.Oct 201714 hours 36 minutes
          QlikView for DevelopersQlikView 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 201718 hours 12 minutes
          Hands-On Dashboard Development with QlikViewThe book will help you build effective business intelligence dashboards using the latest features of QlikView. You will create different types of visualizations such as bar charts, interactive plots, and more. With this book, you will learn how to gain actionable insights from your data and communicate them across to relevant stakeholders in the best possible manner.Mar 20195 hours 12 minutes
          Learning SAP Analytics CloudSAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud) is a cloud-based BI platform being delivered under SaaS terms. It is a business intelligence, planning, and predictive cloud-based application, which helps users blend data from different sources, create compelling data visualization, run ad hoc reporting, and more.Jul 201714 hours 0 minutes
          Tableau 10 BootcampTableau is a leading visual analytics software that can uncover insights for better and smarter decision making. Tableau has an uncanny ability to beautify your data, compared to other BI tools, which makes it an ideal choice for performing fast and easy visual analysis. This book will be a guide for anyone who wants to have practical knowledge and exercises and get up to speed with Tableau in no time.Sep 201712 hours 48 minutes
          Packt+ | Advance your knowledge in tech (2024)
          Top Articles
          Latest Posts
          Article information

          Author: Msgr. Benton Quitzon

          Last Updated:

          Views: 6144

          Rating: 4.2 / 5 (43 voted)

          Reviews: 82% of readers found this page helpful

          Author information

          Name: Msgr. Benton Quitzon

          Birthday: 2001-08-13

          Address: 96487 Kris Cliff, Teresiafurt, WI 95201

          Phone: +9418513585781

          Job: Senior Designer

          Hobby: Calligraphy, Rowing, Vacation, Geocaching, Web surfing, Electronics, Electronics

          Introduction: My name is Msgr. Benton Quitzon, I am a comfortable, charming, thankful, happy, adventurous, handsome, precious person who loves writing and wants to share my knowledge and understanding with you.