QLIKVIEW LIVE REALTIME ONLINE TRAINING BY IT PROFESSIONALS | BEST TRAINERS

Post# A564292 · PITTSBURGH, Kansas · Posted by: raj

QLIKVIEW HANDS-ON ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW & JOB SUPPORT BY WORKING FACULTY

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 Content (we can customize the course Outline as per your requirements)

Day 1
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)

Day 2
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

Day 3
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
Day 5
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

FOR More Details contact us:
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

Type
Offer
Contract type
Permanent
Name
sri raja
Phone number
8500122107

Contact this User

It is NOT ok to contact this poster with commercial interests.
Reply to
[email protected]