by B. Diane Blackwood | Released December 2016 | ISBN: 9781785884535

Build powerful BI solutions with the finest BI tool on the marketAbout This VideoGet to grips with the new features of the latest version of QlikViewBuild an application that fulfills the D.A.R (Dashboard, Analysis, and Report) approach suggested by QlikLearn essential features such as modifying scripts, joining tables, and automatic concatenationIn DetailApplication development is a fundamental task for developers. QlikView provides impressive UI Functions to design and customize applications to meet developers' and organizational needs.This video course introduces the Business Intelligence platform, Qlikview, and demonstrates to viewers how to leverage the system ultimately to conduct and deliver data analysis on business data. The viewers will learn how to build an application that fulfils the D.A.R (Dashboard, Analysis and Report) approach suggested by Qlik.The course will start with introducing viewers to the QlikView platform and how to set up their own project. It will take them through document elements and how to create a connection with multiple datasources. The course will guide users in creating Analysis Reports, Adding Visualizations and also tips & tricks on improving them. Users will learn how to optimise their Data Models by using advanced Script Functions.By the end of the course, the viewers will have a good grounding in QlikView and find it easy to create and analyse reports. Show and hide more

1. Chapter 1 : Course Introduction
   • The Course Overview 00:02:12
   • Overview of the QlikView Platform 00:07:11
   • Installing QlikView Personal Edition 00:03:01
   • Setting Up the Course Project Environment 00:04:29
2. Chapter 2 : Introduction to the QlikView Documents and Scripts
   • The QlikView Document Elements and Properties 00:05:10
   • Adding Data and Creating Database Connection 00:06:10
   • Creating Data Layers with QVD files 00:07:03
3. Chapter 3 : Building the Data Model
   • Loading More Tables and Resolving Synthetic Keys 00:05:52
   • Loading and Modeling Sales Transactions 00:03:44
4. Chapter 4 : Learning QlikView Design – Elements, Properties, and Guidelines
   • Adding a Customer Sheet to Our QlikView Document 00:07:15
   • Applying Design Best Practices to Our New QlikView Sheet 00:11:42
5. Chapter 5 : Solving Data Model Challenges
   • Using the If Statement or Inline Load to Create New Data 00:08:22
   • Creating a Master Calendar table 00:14:23
   • Solving Circular References 00:11:41
   • Learning Tables Concatenation Usage 00:09:36
Show and hide more