Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




Qlik Sense

This web-based training course on Qlik Sense functionality, administration and development, 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.


Introduction

  • Business Intelligence
  • Challenges
  • Qlik Sense
  • Converting Data into Meaning
  • Layering Representations of Data
  • Level of Analysis
  • Action Oriented Data

Fundamentals of Data Warehousing & Business Intelligence

  • OLAP/CUBE
  • ETL
  • Qlik Sense
  • Utility of de-normalizing Data Structure in Data Warehouse
  • Star Schema
  • Snowflake Schema

Qlik Sense Data Structures

  • Important Terminologies
  • Data model
  • Dimensions
  • Measures
  • QVD
  • QVD Creator
  • Script
  • Calendar/Common Calendar
  • Reload
  • Document
  • Sheet
  • Objects

How Data in Qlik Sense looks like

Difference between Qlik Sense and other Spreadsheet/Reporting System

Why It Is Called In-Memory Tool

Getting familiar to The Qlik Sense Development client Interface, its menus etc. and then getting into writing scripts

Loading data into Qlik Sense

Data Structure of the loaded data and mapping them

  • Un-linked data
  • Linked date

Scripting Considerations

  • Synthetic Keys
  • with Circular reference

Data validation

  • Is the data taken from Staging server?
  • What is the right time to take the data depending on data logging by the applications or any post processing or EOD process or backup etc.
  • Are all tables, fields and records loaded required as per the requirements and does the number match from the source data.
  • Sum up few of the numeric fields from the loaded data and it should match with similar sum from the source table.
  • Are the data inside the fields in required format and guidelines including spellings, case, format etc.
  • Run couple of business logic or formula on both source data and the data loaded in Qlik Sense and they should match.
  • Any additional or supplementary data (generally master data) should be in a format and completeness and there should not be multiple forms of truth of the same.

Hands-on exercise.

Generating Additional Data in Qlik Sense Script

  • In Line
  • Resident Load
  • Autogenerate()
  • Loading Data from XML
  • Loading Data from Database
  • Adding Data from RSS Feed

Creating a Calendar

  • Simple Calendar related to One data set
  • Common Calendar
  • Master Calendar
  • Financial Calendar
  • Getting Highest and Lowest Date
  • Rolling 12 Months

Qlik Sense Data (QVD) Files

  • QVD Creation
  • QVD File Functions

Knowing Data Presentation

  • Measures/Expressions and More along with Dimensions
  • Set Analysis
  • Replacing field values with integer
  • Understanding Charts and Objects

Advance Scripting

  • If Statement
  • Aggregation
  • Right Join
  • Left Join
  • Inner Join
  • Outer Join
  • Concatenate
  • Preceding Load
  • Incremental Load
  • Previous() and Peek()
  • IterNo ()
  • Applymap ()
  • Buckets
  • Cross Table
  • String/Date/Number Functions
  • Cleaning Source data

More about Charts

  • Bar Chart
  • Combo Chart
  • Gauge Chart
  • Line Chart
  • Map Chart
  • Pei Chart
  • Pivot Table Chart
  • Scatter plot Chart
  • Tree map Chart
  • Table Chart

Qlik Cloud

  • Qlik Sense publishing
  • Qlik Sense Sharing

Hands-on exercise and presentation


The 8D Problem Solving Methodology and 8D Process is implemented in virtually every industry and industrial domain. No matter what the area of work is, there will always be challenges to face and the highly flexible and all-encompassing methodology that it is, 8D problem solving capability is an expertise which is highly sought after in every single domain. Individuals proficient in the subject will have doors opened for them in all venues of the industry with a great boost to their career. This course is highly recommended for all professionals working at different levels of organizations and especially for RnD professionals who face design and research challenges on a daily basis

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.