Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




QlikView

This web-based training course on QlikView, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


QlikView is a popular business discovery platform flagged by QlikTech Company that is known for turning data into knowledge. A futuristic Business Intelligence tool, QlikView allows its users to easily search and analyze data for getting a better view of their business. The tool helps in effective decision making by providing accurate and easy access to information. QlikView uses the in-memory data model that enables quick, in-memory, management of gigantic datasets. QlikView basically compresses data and then stores it in the memory where it can be used immediately. Qlikview has unlimited horizons and a user can start and reach anywhere, not limit to drill path and dashboards.


Introduction

  • What is Qlikview
  • How does Qlikview differs from traditional BI (architecturally as well as from end user point of view)
  • Associative User Experience
  • Strengths' and Limitations
  • Position in the BI Market (With explain with Garter magic quadrant)
  • Sample Qlikview Demo Application
  • Visualization Concepts
  • Qlikview Architecture (Development Architecture/Tool Architecture)
  • Server components and the purpose of each server components

Data Modelling & Scripting

  • Understanding various data connections and data load types available in Qlikview
  • Data Modelling Concepts- subset ratio/information density/synthetic keys/joins etc.
  • Script Menu Commands/AQL Syntax
  • Executing scripts, Debugging & Tracing and Trouble Shooting
  • Folder Structure
  • Calendar Generation

Interacting with Qlikview Objects-Part1

  • Creating Charts
  • Bar Chart
  • Pie Chart
  • Line Chart
  • Pivot Chart/Straight

Functions and Expressions

  • Qlikview Functions - String/Numeric/Date Time/Dual etc.
  • Expressions - usage of various aggregate functions
  • Set Analysis - static/dynamic, use of variables
  • Running Totals, YTD, MOM Calculations

Interacting with Qlikview Objects-Part2

  • Sheet Basics
  • List Box
  • Table Box
  • Multi Box
  • Text Objects
  • Statistics Box Objects
  • Current Selection box
  • Slider /Calendar Box

Qlikview -Tips & Tricks

  • Loading Multiple Excel in a folder.
  • Errors handling with excel sources.
  • Formatting Option.
  • Calculation conditions on charts Ways to export the data etc.

Setting & Reports

  • Documents Settings
  • Creating Reports

Advanced Topics in Qlikview-Part1

  • Best Practices in scripting and data model
  • Performance Tuning of the Qlikview Apps
  • Security Implementation in Qlikview (Section Access Concepts)
  • Creation of Subroutines and loops in Qlikview

Advanced Applications/Functions

  • Aggr
  • Inter Record Functions
  • Interval Match – Application on Slowly Changing Dimensions
  • Hierarchies
  • Multi Lingual Applications

Advanced Topics in Qlikview-Part2

  • Qlikview Data Modelling
  • Incremental Loads
  • Alternate states and Comparative Analysis
  • Extension objects in Qlikview

Qlikview Licensing Policy and Server Concepts

  • Standard licensing model provided by Qliktech
  • Qlikview Server Concepts
  • Qlikview Services
  • Publisher, QMC etc.
  • Scheduling and Reloading of Qlikview files (Demo only)
  • CALS (Licenses)

With over 240,00 customers spread over 58 global countries, QlikView has proved its significance in the field of Business Intelligence. Taking just a few hours to learn, QlikView opens endless opportunities for uninterrupted analysis of data with its clean, simple and easy to use interface. The future of this Business Intelligence tool is quite right because the amount of convenience QlikView provides in terms of analyzing and searching is beyond everything. Professional prospects for those planning a career in the field of Business Intelligence are also very favorable. A QlikView Certification in your portfolio can really be advantageous and bring you dream job offers.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.