QlikView – Developer

QlikView – Developer

Introduction

Who is QlikTech?

What is QlikView?

QlikView Enterprise

What is Dash Board & Analysis?

A SHORT INTRODUCTION TO DATA STRUCTURES

Relational databases (OLTP)

Other data structures (OLAP, MOLAP, HOLAP, and ROLAP)

A SHORT INTRODUCTION TO DATA WAREHOUSING

Fundamentals of ETL

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

Star Schema

Snow Flake Schema

QLIKVIEW DATA STRUCTURES

Why QlikView is Compare with ETL

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

 Data structures in QlikView(AQL)

Sample Application walkthrough of QlikView 

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

Why it’s called In-memory BI Tool

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

 LOADING DATA INTO QLIKVIEW

Script editing

Edit Script Toolbar

Edit Script Menu Commands

Statements Area

Edit Script Tool Pane

Syntax

Renaming a Field

DATA SOURCE FILES

The QWT (Access File example) primary data source

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

CREATING THE SCRIPT

Script generation

Creating a connection to the database

Reading tables into QlikView

 EXERCISES

Script Debugging

STRUCTURING THE SCRIPT

Creating tabs in the script

 DATA STRUCTURE OF THE LOADED DATA

The Table Viewer

System fields

The system table

Document Properties: Tables page

SCRIPTING CONSIDERATIONS

Synthetic key tables

Circular references

Causes of circular references

Loosely Coupled Tables

ADDING TEXT DATA

Employees

Offices

LOADING AN XML FILE

Loading a text file in XML Format

Renaming fields using the Qualify statement

EXERCISES

GENERATING DATA IN THE QLIKVIEW SCRIPT

Resident Load

Creating data using Load Inline and Autogenerate

Inline tables

Autogenerate tables

MAPPING TABLES

Mapping Quarters to the Orders table

MonthYear

Cleaning up the table structure

CREATING A CALENDAR

Getting the Highest and Lowest date from the Orders table

Creating variables in the script

Creating the Master Calendar

INCLUDE

 READING BUDGET INTO QLIKVIEW

 Reading Cross Tables

 QLIKVIEW DATA (QVD) FILES

 QVD file format

 Use of QVD files

 Creating QVD files

 Automatic Creation of a QVD file in the script

 QLIKVIEW SECURITY

 Access control

 Access levels

 Access control database

 Hidden script

 Adding Section Access

 USING QLIKVIEW SR PERSONAL EDITION

 Starting QlikView

 Basic Layout and Navigation

 SHEETS AND SHEET OBJECTS

 Sheet Basics

 Sheet Objects

 Exercise – Creating Your Workspace

 THE LIST BOX

 Introduction

 Creating a List Box

 List Box in Action

 Properties of the List Box

 Exercise – List Boxes

 THE TABLE BOX

 Introduction

 Creating a Table Box

 Selections in Table Boxes

 Sorting in Table Boxes

 More Table Box formatting options

 Printing data from a table box

 Exporting data from a table box to a text file

 Exercises

 THE MULTI BOX

 Introduction

 Selections in Multi Boxes

 Creating a Multi Box

 Resizing Multi Boxes

 Formatting Multi Boxes

 Exercises

 THE TEXT OBJECT

 Introduction

 Creating Text Objects

 Formatting, Resizing, Copying and Moving Text Objects

CHARTS

 Chart Basics

 Creating a Chart

 Selections in Charts

 Changing the Chart Properties for Existing Charts

 Common Chart Types

 A Note About Mathematical Expressions

 Exporting charts

 References in charts

 Exercises

 MULTIDIMENSIONAL CHARTS, PIVOT TABLES

 Straight Table with Multiple Expressions

 Pivot Tables with Multiple Dimensions

 Grouped bar charts

 More about Pivot Tables and Straight Tables

  Using a Dropdown Selection List

 Using Visual Cues

 Summary – Comparing Tables

 Exercises

 GAUGES

 Why Use a Gauge Chart?

  Types of Gauges

 Building Gauges

 Exercises

 BUTTONS

 Buttons in QlikView

 Creating and Formatting a Button

 Shortcut Buttons

 Launch/Export-Buttons

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

 Exercises

 THE OTHER SHEET OBJECTS

 The Statistics Box

 The Current Selections Box

 The Slider/Calendar Object

 The Input Box

 The Bookmark Object

 ADDITIONAL EDITING IN THE LAYOUT

 Title Settings

 Fast Change Chart Type

 Legend Settings

 Reference Lines / Text in Chart

 Advanced Caption Settings

 Using Layout Themes

 Exercises

 OTHER USES OF EXPRESSIONS

 Calculated Labels and Dynamic Text in Text Objects

 Conditional Functions

 Chart Attribute Expressions

 Color Expressions

 Calculated Fields in List Boxes

 Calculated Dimensions in Charts

 THE SETTINGS MENU

 Sheet Properties 

Savi Computer Educaiton

www.saviItTraining.blogspot.com

Apthamithra Tutorials & Spoken English

ಆಪ್ತಮಿತ್ರ ಟ್ಯೂಷನ್ & ಸ್ಪೋಕನ್ ಇಂಗ್ಲೀಷ್ , ಹಿಂದಿ 

Free Kannada Speaking Classes 

Contact No : 9008453065

Address : No.29, 1st Main Road, Near Yallamma Devi Temple & Arch, Konappana Agrahara, Electronic City, Bangalore-560100.

Email : apthamithratutorials@gmail.com

Website : www.ApthamithraTutorials.blogspot.com

www.facebook.com/apthamithratuitions 

Apthamithra Tuitions , Spoken English, Hindi, Free Kannada speaking Classes, Computer Education MS Office, Advance Excel, Tally erp-9 advance, c, c++, java, hardware & networking, photo shop, pagemaker, corel draw, kannada typing, english grammer

Corporate training

Contact No : 9008453065

Address : No.29, 1st Main Road, Near Yallamma Devi Temple & Arch, Konappana Agrahara, Electronic City, Bangalore-560100.

Email : apthamithratutorials@gmail.com

Website : www.ApthamithraTutorials.blogspot.com

www.facebook.com/apthamithratuitions 

www.savicomputereducaiton.blogspot.com

savicompuereducation@gmail.com

www.facebook.com/savicomputereducation

Mobile : 9008453065.