QlikView Essentials

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

QlikView Essentials

This ebook is included in a Mapt subscription
Chandraish Sinha

1 customer reviews
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
$0.00
$14.00
$34.99
$29.99p/m after trial
RRP $27.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781784397289
Paperback166 pages

Book Description

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.

Table of Contents

Chapter 1: QlikView Fundamentals
QlikView components
QlikView installation
Getting started
The development life cycle of QlikView implementations
QlikView development setup
Summary
Chapter 2: Extract, Transform, and Load
Configuring settings
Scripting essentials
Connecting to the database
Summary
Chapter 3: Optimizing Your Data Model
Mapping table essentials
Mapping load – Territory table
Concatenation
Joins
Reviewing the final data model
Summary
Chapter 4: Data Modeling Challenges
Crosstable essentials
Loading EmployeeSalesTarget.xlsx
Link table
Variables in QlikView
Master calendar
The IntervalMatch function
QlikView Data Files (QVD)
Optimized load – reading QVD
Best practices of data modeling
Summary
Chapter 5: Creating Dashboards
Dashboarding essentials
Getting started
Sheet objects
Creating a multi-tab application
Creating a bar chart
Creating a text object
Creating a scatter chart
The story of two tables
Dimension limits
Some important functions
Summary
Chapter 6: Comparative Analysis
Set Analysis essentials
Using Set Analysis
Alternate States
What-If Analysis
The last step
Summary
Chapter 7: Securing Your Application
Section Access essentials
Implementing Section Access
Summary
Chapter 8: Application Deployment
QlikView architecture essentials
Client Access Licenses (CALs)
QlikView application deployment
QlikView server structure
Summary

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

Authors

Table of Contents

Chapter 1: QlikView Fundamentals
QlikView components
QlikView installation
Getting started
The development life cycle of QlikView implementations
QlikView development setup
Summary
Chapter 2: Extract, Transform, and Load
Configuring settings
Scripting essentials
Connecting to the database
Summary
Chapter 3: Optimizing Your Data Model
Mapping table essentials
Mapping load – Territory table
Concatenation
Joins
Reviewing the final data model
Summary
Chapter 4: Data Modeling Challenges
Crosstable essentials
Loading EmployeeSalesTarget.xlsx
Link table
Variables in QlikView
Master calendar
The IntervalMatch function
QlikView Data Files (QVD)
Optimized load – reading QVD
Best practices of data modeling
Summary
Chapter 5: Creating Dashboards
Dashboarding essentials
Getting started
Sheet objects
Creating a multi-tab application
Creating a bar chart
Creating a text object
Creating a scatter chart
The story of two tables
Dimension limits
Some important functions
Summary
Chapter 6: Comparative Analysis
Set Analysis essentials
Using Set Analysis
Alternate States
What-If Analysis
The last step
Summary
Chapter 7: Securing Your Application
Section Access essentials
Implementing Section Access
Summary
Chapter 8: Application Deployment
QlikView architecture essentials
Client Access Licenses (CALs)
QlikView application deployment
QlikView server structure
Summary

Book Details

ISBN 139781784397289
Paperback166 pages
Read More
From 1 reviews

Read More Reviews