Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering QlikView
  • Table Of Contents Toc
Mastering QlikView

Mastering QlikView

By : Stephen Redmond
4.5 (10)
Buy this Book
close
close
Mastering QlikView

Mastering QlikView

4.5 (10)
By: Stephen Redmond
Buy this Book

Overview of this book

If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics.
Table of Contents (9 chapters)
close
close
close
Preface
Icon
Preface
Icon
Qlik Sense
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Icon
Downloading the example code
Lock Free Chapter
1
1. Performance Tuning and Scalability
Icon
1. Performance Tuning and Scalability
Icon
Reviewing basic performance tuning techniques
Icon
Generating test data
Icon
Understanding how QlikView stores its data
Icon
Strategies to reduce the data size and improve performance
Icon
Testing chart performance for different load options
Icon
Optimizing chart calculation times
Icon
The QlikView calculation engine
Icon
Using Direct Discovery
Icon
Testing scalability with JMeter
Icon
Running an example execution
Icon
Summary
2
2. QlikView Data Modeling
chevron up
Icon
2. QlikView Data Modeling
Icon
Reviewing basic data modeling
Icon
Dimensional data modeling
Icon
Handling slowly changing dimensions
Icon
Dealing with multiple fact tables in one model
Icon
Drilling across with document chaining
Icon
Summary
3
3. Best Practices for Loading Data
Icon
3. Best Practices for Loading Data
Icon
Reviewing data loading concepts
Icon
Understanding why you should use an ETL approach
Icon
Using an ETL approach to create QVD data layers
Icon
Mastering loading techniques
Icon
Using QlikView Expressor for ETL
Icon
Summary
4
4. Data Governance
Icon
4. Data Governance
Icon
Reviewing basic concepts of data governance
Icon
Establishing descriptive metadata
Icon
Extracting metadata
Icon
Deploying the QlikView Governance Dashboard
Icon
Summary
5
5. Advanced Expressions
Icon
5. Advanced Expressions
Icon
Reviewing basic concepts
Icon
Understanding Dollar-sign Expansion
Icon
Using advanced Set Analysis
Icon
Calculating vertically
Icon
Summary
6
6. Advanced Scripting
Icon
6. Advanced Scripting
Icon
Reviewing the basic concepts
Icon
Counting records
Icon
Loading data quickly
Icon
Applying variables and the Dollar-sign Expansion in the script
Icon
Using control structures
Icon
Examining advanced Table File Wizard options
Icon
Looking at data from different directions
Icon
Reusing code
Icon
Summary
7
7. Visualizing Data
Icon
7. Visualizing Data
Icon
Reviewing the history of data visualization
Icon
Understanding the audience
Icon
Designing effective visualizations
Icon
Summary
8
Index
Icon
Index

Reviewing basic data modeling

If you have attended QlikView training courses and done some work with QlikView modeling, there are a few things that you will know about, but I will review them just to be sure that we are all on the same page.

Associating data

QlikView uses an associative model to connect data rather than a join model. A join model is the traditional approach to data queries. In the join model, you craft a SQL query across multiple tables in the database, telling the database management system (DBMS) how those tables should be joined—whether left, inner, outer, and so on. The DBMS might have a system in place to optimize the performance of those queries. Each query tends to be run in isolation, returning a result set that can be either further explored—Excel pivot tables are a common use case here—or used to build a final report. Queries might have parameters to enable different reports to be executed, but each execution is still in isolation. In fact...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering QlikView
End of Section 2
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon