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

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Mastering QlikView
  • Toc
  • feedback
Mastering QlikView

Mastering QlikView

By : Stephen Redmond
4.5 (10)
close
Mastering QlikView

Mastering QlikView

4.5 (10)
By: Stephen Redmond

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
Preface
Preface
Qlik Sense
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Free Chapter
1
1. Performance Tuning and Scalability
1. Performance Tuning and Scalability
Reviewing basic performance tuning techniques
Generating test data
Understanding how QlikView stores its data
Strategies to reduce the data size and improve performance
Testing chart performance for different load options
Optimizing chart calculation times
The QlikView calculation engine
Using Direct Discovery
Testing scalability with JMeter
Running an example execution
Summary
2
2. QlikView Data Modeling
chevron up
2. QlikView Data Modeling
Reviewing basic data modeling
Dimensional data modeling
Handling slowly changing dimensions
Dealing with multiple fact tables in one model
Drilling across with document chaining
Summary
3
3. Best Practices for Loading Data
3. Best Practices for Loading Data
Reviewing data loading concepts
Understanding why you should use an ETL approach
Using an ETL approach to create QVD data layers
Mastering loading techniques
Using QlikView Expressor for ETL
Summary
4
4. Data Governance
4. Data Governance
Reviewing basic concepts of data governance
Establishing descriptive metadata
Extracting metadata
Deploying the QlikView Governance Dashboard
Summary
5
5. Advanced Expressions
5. Advanced Expressions
Reviewing basic concepts
Understanding Dollar-sign Expansion
Using advanced Set Analysis
Calculating vertically
Summary
6
6. Advanced Scripting
6. Advanced Scripting
Reviewing the basic concepts
Counting records
Loading data quickly
Applying variables and the Dollar-sign Expansion in the script
Using control structures
Examining advanced Table File Wizard options
Looking at data from different directions
Reusing code
Summary
7
7. Visualizing Data
7. Visualizing Data
Reviewing the history of data visualization
Understanding the audience
Designing effective visualizations
Summary
8
Index
Index

Chapter 2. QlikView Data Modeling

 

"It is a capital mistake to theorize before one has data. Insensibly one begins to twist facts to suit theories, instead of theories to suit facts."

 
 --Sherlock Holmes (Arthur Conan Doyle), A Scandal in Bohemia

In data warehousing and business intelligence, there are many approaches to data modeling. We hear of personalities such as Bill Inmon and Ralph Kimball. We talk of normalization and dimensional modeling. But we also might have heard about how QlikView can cut across all of this—we don't need to worry about data warehousing; we just load in all the data from source systems and start clicking. Right?

Well, that might be right if you want to load just a very quick application directly from the data source and aren't too worried about performance or maintainability. However, the dynamic nature of the QlikView script does not mean that we should throw out all of the best practices in data warehouse design...

End of Section 1
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete