QLIK VIEW

Length: I Class (1 Hour)

Duration – 30 days

Audience:

• Anyone who wants to start his/her career as a Qlik View Administrator / Developer / Consultant.
• Anyone working on technologies which are doing not so good in the market like Mainframes, SAP, Siebel, Oracle, Java, Microsoft .Net
• Business Intelligence Architecture

Student Location– To students from around the world

Delivery Method: Instructor-Led – Live online Training

Introduction to QlikView

• What is QlikView
• Difference Between Traditional BI Tools and QlikView

Data Warehousing Basics

• What is Data WareHouse?
• What is OLAP and OLTP

Dimensional Data Model

• What is Dimension Table?
• What is Fact Table?
• MicroStrategy BI Architectures

Different Types of Schemas

• Star Schema
• Snow Flake Schema
• Galaxy/Hybrid Schema

Starting With QlikView

• Detail Description on QlikView
• What is DashBoard and Analysis?
• Installation of Software
• Basic Concepts of QlikView?
• QlikView Architecture

QlikView Developer

QlikView Data Loading

• How to load the Data into QlikView
• Loading The Data From DataBase Tables
• Loading The Data From Excel Files
• Loading The data From In-Line Statement

Conneting ODBC and OLEDB DataSources

Data Model , Script Editor

Scrit Commands

• Connect
• Load
• Select
• Re-Load

Advanced Scripting/Data Modeling

• Joining the Data From Multiple Tables
• Working the Variables in the Script and UI
• Concatenation
• Resident Load / Table
• Apply Map Function
• Incremental Loading
• Let and Set Commandse
• Date Functions

Joins In QlikView

Inner Join/Left Join/Right Join/Outer Join

Data Structure Of The Loaded Data

• Table Viewer?
• Self , Multiple and Circular References
• Synthetic Keys
• System Tables/Fields

QlikView Design

QlikView Design Concepts

• Creating And Working with Sheets
• QlikView Menu Commands
• Design Tool Bar
• Sheets Properties
• Different Sheet Objects

Sheet Objects

Table Box

• Creating Table box
• Table Box Styles
• Ways of Sorting
• Minimize and Maximize the Table Boxes
• Exporting Table Data into Excel Files

List Box

• Creating a List Box
• Formatting Tips for The List Box
• Detail Properties of List Box

Multi Boxes

• What is Multi Box
• Creating Multi Box
• Uses of Muli Box
• Properties of Multi Box<

Text Object

• Creation of Text Object
• Text Object Properties

Buttons

• Creating of Buttons
• Applying Actions with Buttons

Charts

• Different Types of Charts
• Bar Chart
• Line Chartx
• Combo Chart<
• Pie Chart
• Radar Chartt
• Guages
• Mekko Chart
• Scatter Plot
• Grid Chart

Other Sheet Objects

• Container Object
• Line/Arrow Object
• Search Object
• Slider/Calender Object
• Statics Box

Settings Menu / Other Tool options

• Different Types of Charts
• User Preferences
• Document Properties
• Variable Overview
• Sheet Properties

Navigation Tool Bar

Advanced Tables/Fields

• Mapping Tables
• Auto Generate tables
• Time Dimension tables
• Inline Tables

QlikView Data Files (QVD)

• QVD File Format
• Creating QVD Files
• Use of QVD files

Pivot Tables And Straight Tables

• Creating Pivot Table and Straight Table
• Adding Multiple Expressions to the Tables
• Formatting The Pivot and Straight Tables

QlikView Server (Theory)

• Server Components
• QMC Introduction and OverView
• Access Point
• Publisher
• Managing Folders
• Scheduling Tasks
• Adding Users to Document
• Security Overview
• Authentication
• Section Access

Fee :	400 USD
Batch Starts :	March 29th 2018
Timings :	7:00PM EST to 8:00PM EST