by Packt Publishing | Released January 2018 | ISBN: 9781789130904

Discover time-saving techniques and best practices to make your QlikView development more efficientAbout This VideoDevelop your own scalable and maintainable QlikView applicationsLearn time-saving techniques to make your QlikView development more efficientA one-stop guide to developing BI applications with QlikViewIn DetailQlikView is one of the most flexible and powerful Business Intelligence platforms around. If you want to build data into your organization, build it around QlikView. Don't get caught in the gap between data and knowledge—find out how QlikView can help you unlock insights and data potential with ease. Whether you're new to QlikView or want to get up-to-speed with the features and functionality of QlikView, this course starts at a basic level and delves more deeply to demonstrate how to make QlikView work for you, and make it meet the needs of your organization. Using a real-world use-case to highlight the extensive impact of effective business analytics, this course might well be your magic bullet for success.A superb hands-on guide to exploring the highly efficient techniques in QlikView and successfully implementing it, technically and strategically. You'll learn valuable tips, tricks, and insights into loading different types of data into QlikView, and how to model it effectively. You will also learn how to write useful scripts for QlikView to handle potentially complex data transformations in a way that is simple and elegant. Along with this, you will learn to improve user experiences and implement security features for your QlikView documents. Show and hide more

1. Chapter 1 : Data Modeling Best Practices
   • The Course Overview 00:04:21
   • Data Consistency 00:13:34
   • Design Challenges of Data Modeling 00:10:09
   • The Master Calendar 00:07:22
2. Chapter 2 : Basic Data Transformation
   • Cleansing a Dirty table 00:11:01
   • Loading a Crosstable 00:04:37
   • Expanding a Hierarchy 00:06:22
   • Generic Load 00:03:53
3. Chapter 3 : Advanced Expressions
   • Using Variables 00:21:01
   • Using Total Qualifier 00:03:38
   • The Aggr Function 00:05:23
   • Conditional Functions 00:08:53
4. Chapter 4 : Set Analysis and Point In Time Reporting
   • The Magic of Set Analysis 00:11:51
   • Point in Time Reporting 00:07:49
   • Comparative Analysis with Alternate States 00:08:46
5. Chapter 5 : Advanced Data Transformations
   • Loading Data Already Stored in QlikView 00:05:06
   • Aggregating Data 00:04:34
   • Sorting Tables 00:04:06
   • Merging Forces 00:06:09
   • Dealing with Slowly Changing Dimensions 00:10:40
   • Incremental Loads 00:05:31
6. Chapter 6 : More on Visual Design and User Experience
   • Creating a Consistent QlikView UI 00:11:25
   • Additional Interactivity 00:17:24
7. Chapter 7 : Security
   • Hidden Script 00:03:01
   • Section Access 00:06:59
   • Restricting the Data 00:09:24
   • Document-Level and Sheet-Level Security 00:05:45
Show and hide more