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


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