O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

QlikView Essentials

Book Description

Want to solve your Business Intelligence headaches? Learn how QlikView can help, and discover a powerful yet accessible BI solution that lets you harness your data

About This Book

  • Design interactive dashboards using QlikView to share sharp BI insights
  • Discover how to create effective data models to manage and harness your data with QlikView's ETL functionality
  • Learn and implement best practices to successfully integrate QlikView within your organization

Who This Book Is For

If you recognize the challenges of harnessing data for a modern business this book is for. Maybe you already know a little about QlikView ? if you want to learn more, QlikView Essentials is a great way to develop your knowledge and skills.

What You Will Learn

  • Learn the complete QlikView workflow ? from loading data, to visualization and analytics
  • Learn how to Load data from different sources, including QVD files and how to optimize data models for accuracy and precision
  • Discover solutions to common data modeling problems, so you can respond quickly to changing situations
  • Create accessible dashboards and quality data visualizations to share insights effectively
  • Learn how to deploy your BI application for optimal availability

In Detail

This guide demonstrates just how easy it is to get started with QlikView and create your own BI application. Featuring an introduction to its core features before exploring how to load data and model it, you'll soon become more confident that you can take full advantage of QlikView's capabilities. You will also learn how to use QVD files with QlikView ? and how they offer a simpler way of handling data.

After digging deeper into data handling, as you learn how to use mapping tables and create a master calendar, you'll then find out how to get the most from QlikView's visualization features ? vital if you are to use your data insights effectively. From accessible and user friendly dashboards to strategies and best practices for subjecting data to further analysis, you can be confident that you'll be prepared to get the most out of your data with QlikView.

With details on how to finally secure your application and deploy it for a successful integration in your organization, QlikView Essentials underlines exactly why QlikView is becoming more and more popular for businesses that understand the value of data.

Style and approach

The book takes a step-by-step approach to QlikView development, and is explained in an easy-to-follow style. Each topic is accompanied by an exercise so you can put your knowledge into practice. This book will be useful for you no matter what your needs and experience levels with the technology.

Table of Contents

  1. QlikView Essentials
    1. Table of Contents
    2. QlikView Essentials
    3. Credits
    4. About the Author
    5. About the Reviewer
    6. www.PacktPub.com
      1. Support files, eBooks, discount offers, and more
        1. Why subscribe?
        2. Free access for Packt account holders
        3. Instant updates on new Packt books
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    8. 1. QlikView Fundamentals
      1. QlikView components
      2. QlikView installation
      3. Getting started
      4. The development life cycle of QlikView implementations
        1. About Adventure Works
        2. User requirements
        3. Analyze data model/data sources
          1. Star schema and snow flake schema
      5. QlikView development setup
      6. Summary
    9. 2. Extract, Transform, and Load
      1. Configuring settings
      2. Scripting essentials
      3. Connecting to the database
        1. Loading the OrderHeader Table
        2. Loading the OrderDetail table
        3. Creating fields in the Order table
        4. Loading the Customer table
        5. Loading the Product table
        6. Resolving the synthetic keys
          1. How to resolve synthetic keys
        7. Removing synthetic keys between the Product and Order Detail tables
        8. Loading the ProductSubcategory table
        9. Loading data from text and Excel files
        10. Loading the Product Category table
        11. Loading Employee.xlsx
        12. Circular reference and loosely coupled tables
          1. Circular reference
          2. Loosely coupled tables
          3. Resolving circular reference
        13. Loading the SalesTerritory and Shipment tables
        14. Loading an Inline table
        15. The Qualify statement
        16. Loading the Shippers table
        17. A word about resident load and Exists
        18. Finding the sales person
        19. Using If statements in the script
        20. Including files using the Include statement
        21. More on Table Viewer
        22. Time to review your data model so far
      4. Summary
    10. 3. Optimizing Your Data Model
      1. Mapping table essentials
      2. Mapping load – Territory table
        1. Mapping load – Product Category and ProductSubcategory tables
        2. Mapping load – ProductSubcategory table
        3. Mapping load – CountryRegion_Inline
      3. Concatenation
        1. Concatenation example
          1. Automatic Concatenation
          2. NoConcatenate
          3. Forced concatenation
      4. Joins
        1. Join Orders and Order Detail
        2. Left join SalesPerson
        3. Aggregating data
        4. Concatenating the new Employees table
      5. Reviewing the final data model
      6. Summary
    11. 4. Data Modeling Challenges
      1. Crosstable essentials
      2. Loading EmployeeSalesTarget.xlsx
      3. Link table
        1. Link table essentials
        2. Creating a link table
      4. Variables in QlikView
        1. Using variables to set the file path
      5. Master calendar
      6. The IntervalMatch function
      7. QlikView Data Files (QVD)
        1. Creating QVD files for our data model
      8. Optimized load – reading QVD
        1. Reading QVD files
      9. Best practices of data modeling
      10. Summary
    12. 5. Creating Dashboards
      1. Dashboarding essentials
      2. Getting started
        1. Associative experience
        2. Binary load
          1. Exploring menu items
      3. Sheet objects
      4. Creating a multi-tab application
        1. The dashboard sheet
        2. Creating list boxes for other fields
          1. Options to copy and paste objects
          2. Placing a logo on the dashboard sheet
      5. Creating a bar chart
        1. Expression Overview
      6. Creating a text object
      7. Creating a scatter chart
      8. The story of two tables
        1. Creating a straight table
        2. Enhancing your tables
          1. Groups
          2. Creating a drill-down group
          3. Creating a cyclic group
          4. Creating a pivot table
            1. Container
      9. Dimension limits
        1. Interactivity using text objects
        2. Some more charts
          1. Line charts
          2. Combo charts
          3. Pie charts
      10. Some important functions
        1. The Aggr function
        2. Nested aggregation
        3. Other functions
      11. Summary
    13. 6. Comparative Analysis
      1. Set Analysis essentials
      2. Using Set Analysis
      3. Alternate States
      4. What-If Analysis
        1. Using input box
      5. The last step
      6. Summary
    14. 7. Securing Your Application
      1. Section Access essentials
      2. Implementing Section Access
        1. Using OMIT
        2. Using reduction
      3. Summary
    15. 8. Application Deployment
      1. QlikView architecture essentials
      2. Client Access Licenses (CALs)
      3. QlikView application deployment
      4. QlikView server structure
      5. Summary
    16. Index