QlikView Essentials cover basics on QlikView designer, QlikView developer and deploying application on the server.
The objective of the book is to provide complete information in a nutshell. Before starting on QlikView implementation, developer should be equipped with all the QlikView essentials.
Each Chapter is designed with explanation and practice exercise. Every chapter starts with Essentials i.e. important concepts on the topic covered, followed by the exercise.
Book uses Adventure works database. This database is very common and most readers may be aware of the tables and relationships among them. This helps is good understanding of various concepts used in creating QlikView data model.
Book is divided into different chapters.
Chapter One,provides overview of QlikView,installation steps,explanation of the problem and tables used.It also provides setup instructions of the data provided with the book.
Chapter Two, starts with loading data in QlikView. Readers understand the concepts of scripting and learn about different load statements. By following the exercises, readers will learn about synthetic keys and how to resolve them.
Chapter Three, covers different ways to optimize QlikView data model. This involves the use of Mapping tables,Joins,Aggregating data and so on.
Chapter Four,provides ways to resolve data modeling challenges by the use of interval match function, Link table, Master calendar and so on.
Chapter Five, covers the basics of QlikView designer i.e. creating different visualization objects in QlikView.Readers will learn about different visualization objects and create them.
Chapter Six, covers aspects of comparative analysis by using Set Analysis and Alternate state.
Chapter Seven,covers the use of Section Access to secure QlikView application
Chapter Eight, covers deployment of QlikView application on the server. This chapter provides details on different licenses in QlikView. In this chapter readers will also learn about different tabs available on QlikView Management console to manage the server. Readers will also learn about creating tasks and triggers to schedule data load and publish tasks.
This books covers A-Z of QlikView implementation – understanding the problem, creating data model, designing dashboards and deployment.