Learning QlikView® 12 [Video]

Learning QlikView® 12 [Video]

This video is included in a Mapt subscription
B. Diane Blackwood

Build powerful BI solutions with the finest BI tool on the market
$0.00
$25.00
$29.99p/m after trial
RRP $124.99
Subscription
Video
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

Video Details

ISBN 139781785884535
Course Length1 hours 47 minutes

Video Description

Application 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.

Style and Approach

This step-by-step tutorial uses a sample application to help you understand the basics of QlikView in a very practical manner.

Table of Contents

Course Introduction
The Course Overview
Overview of the QlikView Platform
Installing QlikView Personal Edition
Setting Up the Course Project Environment
Introduction to the QlikView Documents and Scripts
The QlikView Document Elements and Properties
Creating a Database Connection
Creating Data Layers with QVD files
Building the Data Model
Loading More Tables and Resolving Synthetic Keys
Loading and Modeling Sales Transactions
Learning QlikView Design – Elements, Properties, and Guidelines
Creating Design Objects and Their Properties
Applying General Design Guidelines in QlikView
Solving Data Model Challenges
Using the If Statement to Create New Fields
Creating a Master Calendar table
Solving Circular References
Learning Tables Concatenation Usage

What You Will Learn

  • Download QlikView Personal Edition and Set up a Project Environment
  • Introduce QlikView terminology such as Document, Sheet Elements and Scripts, Adding data and the different data sources available to use
  • Continue building the data model, resolving synthetic keys and organizing script sections to load data.
  • Create a new document sheet, Design Objects and manage their properties, learn best practice guidelines for design
  • Solve some data modeling challenges, the If statement, using a Master Calendar table, solving Circular References, and join or concatenate tables to create budget data.
  • Create Data Layers with QVD files

Authors

Table of Contents

Course Introduction
The Course Overview
Overview of the QlikView Platform
Installing QlikView Personal Edition
Setting Up the Course Project Environment
Introduction to the QlikView Documents and Scripts
The QlikView Document Elements and Properties
Creating a Database Connection
Creating Data Layers with QVD files
Building the Data Model
Loading More Tables and Resolving Synthetic Keys
Loading and Modeling Sales Transactions
Learning QlikView Design – Elements, Properties, and Guidelines
Creating Design Objects and Their Properties
Applying General Design Guidelines in QlikView
Solving Data Model Challenges
Using the If Statement to Create New Fields
Creating a Master Calendar table
Solving Circular References
Learning Tables Concatenation Usage

Video Details

ISBN 139781785884535
Course Length1 hours 47 minutes
Read More

Read More Reviews