Qlik

Program Overview |Instructors |Curriculum |Certification |Who should do this course? |FAQ |Calender

Program Overview

Montreal College is an official Certification Academy. We believe in evolving along with technological advancements. We are offering a short duration certification program to equip our students with QlikView .We lay emphasis on practical experience along with necessary theoretical knowledge.

QlikView is the only in-memory tool with ETL(Extract, transform, load) engine to transform data from various data sources.This course will make you an awesome QlikView developer. You will be able to extract data from various sources and transform data based on the business rules to create a data model that business analysts can use to create Presentation layer.

Instructors

You call them instructors, we call them your Mentors!

They are the catalysts under whose supervision and arm’s length support our students are empowered to accomplish expertise in advanced technology. We boast of enterprising and talented resources with proven track records who are working in tandem with our goal to provide inspiring and enduring technical learning experience to our students.

Curriculum

Intro & Basic Visualizations

  1. Loading data from different sources in QlikView.
  2. Introduction to QVD and how does it work?
  3. What is Table Viewer?

 

Objects and Properties

  1. Sheet object and Tab with their properties
  2. List Box, Multi-Box, Current Selection Box, Search Box
  3. Chart Objects and their properties
  4. Use of Object Container
  5. Expression writing and read about basic functions

 

Scripting & Data Transformations 

  1. Loading Cross Table
  2. Loading Inline Table
  3. Loading data from already stored data in Qlikview (Resident Load)
  4. Joins, Concatenation of tables
  5. Use of Mapping Tables
  6. Synthetic Keys and ways to remove it
  7. Incremental Load in Qlikview
  8. Partial Load

 

Advanced Visualizations and Expressions

  1. Conditional Formatting In Qlikview
  2. Gauge Chart, Thermometer and Waterfall chart
  3. Enable dimension and expression
  4. Adhoc Reporting in Qlikview
  5. Cyclic and drill groups
  6. Conditional Formatting In Qlikview
  7. Gauge Chart, Thermometer and Waterfall chart
  8. Enable dimension and expression
  9. Adhoc Reporting in Qlikview

 

Certification

You will be able to start building Qlik View data models after completing this course.

Who should do this course?

All individuals with basic understanding of Relational Databases (SQL) who are interested to connect various data sources, transform data and create a QlikView data model for data visualization and business discovery

FAQ

Calender

  • Session one
    25 October 2016
    30 09 16
    Apply
  • Session two
    06 February 2017
    20 01 17
    Apply
  • Session three
    04 July 2017
    16 06 17
    Apply