QlikView Hands-On Online Training By Corporate Professionals

QlikView Training makes you Learn QlikView Business Analytics using QlikView tool, QlikView analytics, how to create real-world Analytical Visualizations with the QlikView, architecture, interactive charts, and graphs, data modeling, extensions. You will work on real-time projects, and it will help you to master visualization, Qlikview data modeling, reports, and dashboards.



FOR FREE DEMO contact :

Email : raj@apex-online-it-training.com

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : raavi.sriraja@gmail.com

Blog: http://apex-it-online-trainings.blogspot.in


QlikView Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

QLIKVIEW COURSE CURRICULUM

(the course content can be modified as per your requirements):


INTRODUCTION

1.1 Who is QlikTech ?

1.2 What is QlikView ?

1.3 QlikView Enterprise

1.4 What is Dash Board & Analysis?

2 A SHORT INTRODUCTION TO DATA STRUCTURES

2.1 Relational databases (OLTP)

2.2 Other data structures (OLAP)

3 A SHORT INTRODUCTION TO DATA WAREHOUSING

3.1 Fundamentals of ETL

3.2 What is the utility of De-normalize data structure in Data warehousing

3.3 Star Schema

3.4 Snow Flake Schema

3.5 SQL Arithmetic Functions, Joins, Aggregation Functions and String Functions

3.6 What are the table and field?

4 QLIKVIEW DATA STRUCTURES

4.1 Why QlikView is Compare with ETL

4.2 Comparing Database structures (OLTP & OLAP) to QlikView data structures

4.3 Data structures in QlikView (AQL).

4.4 Sample Application walkthrough of QlikView.

4.5 Objectivity of Relevant search records (Gray area & White area in Dimension)

4.6 Why it’s called In-memory BI Tool

4.7 Thorough Architecture of QlikView (including Multiple Data Source & AJAX Client)

5 LOADING DATA INTO QLIKVIEW

5.1 Script editing

5.2 Edit Script Toolbar

5.3 Edit Script Menu Commands

5.4 Statements Area

5.5 Edit Script Tool Pane

5.6 Syntax

5.7 Renaming a Field

6 DATA SOURCE FILES

6.1 The QWT (Access File example) primary data source

6.2 The QWT (Access File example with QVD Conversion) secondary data files

7 CREATING THE SCRIPT

7.1 Script generation

7.2 Creating a connection to the database

7.3 Reading tables into QlikView

8 EXERCISES

8.1 Script Debugging

9 STRUCTURING THE SCRIPT

9.1 Creating tabs in the script

10 DATA STRUCTURE OF THE LOADED DATA

10.1 The Table Viewer

10.2 System fields

10.3 The system table

10.4 Document Properties: Tables page

11 SCRIPTING CONSIDERATIONS

11.2 Synthetic key tables

11.3 Circular references

11.4 Causes of circular references

11.5 Loosely Coupled Tables

12 ADDING TEXT DATA

12.1 Employees

12.2 Offices

13 LOADING AN XML FILE

13.1 Loading a text file in XML Format

13.2 Renaming fields using the Qualify statement

14 EXERCISES

15 GENERATING DATA IN THE QLIKVIEW SCRIPT

15.1 Resident Load

15.2 Creating data using Load Inline and Autogenerate

15.3 Inline tables

15.4 Autogenerate tables

16 MAPPING TABLES

16.1 Mapping Quarters to the Orders table

16.2 MonthYear

16.3 Cleaning up the table structure

17 CREATING A CALENDAR

17.1 Getting the Highest and Lowest date from the Orders table

17.2 Creating variables in the script

17.3 Creating the Master Calendar

18 INCLUDE

19 READING BUDGET INTO QLIKVIEW

19.1 Reading Cross Tables

20 QLIKVIEW DATA (QVD) FILES

20.1 QVD file format

20.2 Use of QVD files

20.3 Creating QVD files

20.4 Automatic Creation of a QVD file in the script

21 QLIKVIEW SECURITY

21.1 Access control

21.2 Access levels

21.3 Access control database

21.4 Hidden script

21.5 Adding Section Access

Day 4

1 USING QLIKVIEW 11.0SR1 PERSONAL EDITION

1.1 Starting QlikView

1.2 Basic Layout and Navigation

2 SHEETS AND SHEET OBJECTS

2.1 Sheet Basics

2.2 Sheet Objects

2.3 Exercise – Creating Your Workspace

3 THE LIST BOX

3.1 Introduction

3.2 Creating a List Box

3.3 List Box in Action

3.4 Properties of the List Box

3.5 Exercise – List Boxes

4 THE TABLE BOX

4.1 Introduction

4.2 Creating a Table Box

4.3 Selections in Table Boxes

4.4 Sorting in Table Boxes

4.5 More Table Box formatting options

4.6 Printing data from a table box

4.7 Exporting data from a table box to a text file

4.8 Exercises

5 THE MULTI BOX

5.1 Introduction

5.2 Selections in Multi Boxes

5.3 Creating a Multi Box

5.4 Resizing Multi Boxes

5.5 Formatting Multi Boxes

5.6 Exercises

6 THE TEXT OBJECT

6.1 Introduction

6.2 Creating Text Objects

6.3 Formatting, Resizing, Copying and Moving Text Objects

7 CHARTS

7.1 Chart Basics

7.2 Creating a Chart

7.3 Selections in Charts

7.4 Changing the Chart Properties for Existing Charts

7.5 Common Chart Types

7.6 A Note About Mathematical Expressions

7.7 Exporting charts

7.8 References in charts

7.9 Exercises

8 MULTI DIMENSIONAL CHARTS, PIVOT TABLES

8.1 Straight Table with Multiple Expressions

8.2 Pivot Tables with Multiple Dimensions

8.3 Grouped bar charts

8.4 More about Pivot Tables and Straight Tables

8.5 5.5. Using a Dropdown Selection List

8.6 Using Visual Cues

8.7 Summary – Comparing Tables

8.8 Exercises

9 GAUGES

9.1 Why Use a Gauge Chart?

9.2 8.3. Types of Gauges

9.3 Building Gauges

9.4 Exercises

10 BUTTONS

10.1 Buttons in QlikView

10.2 Creating and Formatting a Button

10.3 Shortcut Buttons

10.4 Launch/Export-Buttons

10.5 Edit Macro (on the fly Grouping/Sheet Enabled Disabled)

10.6 Exercises

11 THE OTHER SHEET OBJECTS

11.1 The Statistics Box

11.2 The Current Selections Box

11.3 The Slider/Calendar Object

11.4 The Input Box

11.5 The Bookmark Object

12 ADDITIONAL EDITING IN THE LAYOUT

12.1 Title Settings

12.2 Fast Change Chart Type

12.3 Legend Settings

12.4 Reference Lines / Text in Chart

12.5 Advanced Caption Settings

12.6 Using Layout Themes

12.7 Exercises

14 OTHER USES OF EXPRESSIONS

14.1 Calculated Labels and Dynamic Text in Text Objects

14.2 Conditional Functions

14.3 Chart Attribute Expressions

14.4 Color Expressions

14.5 Calculated Fields in List Boxes

14.6 Calculated Dimensions in Charts

15 THE SETTINGS MENU

15.1 Sheet Properties