QlikView Online Training sdfFriday 25 December 2015 1 comments

QlikView Online Training

BuddhaiSoft Provides Online Training in various courses. Current Hot Courses MSBI 2012(SSRS,SSIS,SSAS), Tabelau, QlikView Training you can receive across the globe. You will learn complete from Real Time experience and get 360 degree overview about the technology. 

Key Features of BuddhaiSoft Online Training:

1. In-depth high quality interactiveLive sessions
2. Multiple assignment, project work and lab exercises for practice
3. On-demand training support
4. Job assistance - US, UK, and Indian Clients and partners by providing FAQ.
5. Sample resumes preparation along with mock up interview session
6. Guidance for Certification at the end of the course
7. Professional faculty with more than 11+ years of experience in the industry With Real Time

BuddhaiSoft had trained participants across globe on MSBI(SSRS,SSAS,SSIS), QlikView,Tableau Training from different regions like Europe,US,Spain,Germany, Singapore, Malaysia , Australia, UK, Saudi Arabia,Egypt, Bay Area, Chicago and MA. BuddhaiSoft provide online Training to make professional to get started with career enhancement.

Visit us - www.BuddhaiSoft.com

BuddhaISoft SoftWare Development & Online Training
Hyderabad
Mobile: +91 - 7799895236 / +91 - 7207401404

www.BuddhaiSoft.com
ContactUs@BuddhaiSoft.com
BuddhaiSoft@gmail.com

Read More

BI & Data Visualization with Qlikview sdfMonday 21 December 2015 2 comments

Become an expert in Data Visualization with Qlikview by transforming data into interactive charts and graphs using Qlikview features like dashboards, system table, incremental load and object formatting

Lets call BuddhaiSoft.com

1. Qlikview Starter

Learning Objectives - In this module, you will get an introduction to Qlikview and the other associated components.

 

Topics - Introduction to Qlikview, What is Visualization, Components of Qlikview, Create Connection, Create Dashboard Report, Report Interface, Sheet Object-List BOX.

2. Script - Code

Learning Objectives - In this module, you will learn to edit the script and you will understand the working of the different tools to edit the scripts. 

Topics - Script Editing, Edit Script Toolbar, Edit Script Menu Commands, Statements Area, Edit Script Tool Pane, Syntax, Creating tabs in the script, Renaming a Field, Chart Object- Bar Chart, Sheet Object- TABLE Box.

3. Script - Relation

Learning Objectives - In this module, you will learn about Tables, Join, its types and uses.

Topics - The Table Viewer, System Fields, The System Table, Join, Keep, Concatenation, Types of Join, Keep and Concatenation, When to use, Which Type, Chart Object-Line Chart, Sheet Object-Multi Box.

4. Script - Loop & Field Handle

Learning Objectives - In this, module you will learn to use the Synthetic Key tables and the ways to resolve the synthetic keys and circular reference. 

Topics - Synthetic Key Tables, Circular References, Causes of Circular References, Ways to Resolve Synthetic Keys and Circular Reference, Text Files, Excel Files, CSV Files, Others, Chart Object- Combo Chart Sheet Object- Input Box.

5. Script - Load Type & System Table

Learning Objectives - In this module, you will learn to generate the data in Qlikview script, cross tables, mapping tables and various other concepts. 

Topics - Generating Data in the Qlikview Script, Cross Tables, Mapping Tables, Different Types of Loads, Chart Object - Pie Chart, Sheet Object - Buttons, Sheet Object - Current Selections Box.

6. Script - Incremental Load & Files

Learning Objectives - In this module, you will learn about data file types, incremental load, Calendar creation and types of sheet objects.

Topics - Qlikview Data Files Types, Incremental load, Incremental load with qvd file, Creating a Calendar, Sheet Object - Radar Chart, Sheet Object - Scatter Chart, Sheet Object - Text Box.

7. Object/Field Formatting

Learning Objectives - In this module,  you will learn to perform Object / Field formatting. 

Topics - Number Format, Aggregation & Nested level, Calculated Formula, Field Groups, Sheet Object - Grid Chart, Sheet Object - Block Chart, Sheet Object - line/arrow.

8. Data Analysis

Learning Objectives - In this module you will learn to perform Data Analysis like Set, Indirect, and What-If analysis. 

Topics - Set Analysis, Indirect Set Analysis, What-if Analysis, Set vs Let, Sheet Object-Mekko Chart, Sheet Object - Gauge Chart, Sheet Object - Slider/Calendar Box.

Read More

Qlikview Online Training sdf 1 comments

Qlikview Online Training :

INTRODUCTION

• 1.Target Audience
• 2.What You Will Learn in this Course
• 3.Course Logistics
• 4.Notes

QLIKVIEW ENVIRONMENT

• 1.QlikView Desktop

QLIKVIEW DEVELOPMENT METHODOLOGY

• 1.Import/Export Sheet and Document Layouts as XML
• 2.Qlik Wholesale Trade (QWT) Project Plan
• 3.Project Plan Review
• 4.SAFE Methodology

DEPLOYMENT

• 1.QlikView Standalone
• 2.QlikView Server
• 3.QlikView Publisher

INTRODUCTION TO DATA AND SCRIPTING

• 1.Relational Databases
• 2.Other Data Structures
• 3.Comparing Database Structures to QlikView Data Structures
• 4.Data Structures in QlikView
• 5.Data Source Files
• 6.The QWT Primary Data Source
• 7.The QWT Secondary Data Files
• 8.Introduction to Scripting

BASIC SCRIPT SYNTAX

• 1.Syntax

LOADING DATA FROM THE DATABASE

• 1.Script Generation
• 2.Comments in the Script
• 3.Script Debugging

STRUCTURING THE SCRIPT

• 1.Creating Tabs in the Script

BASIC DATA MODEL AND TABLE VIEWER

• 1.The Table Viewer
• 2.The System Table
• 3.Document Properties: Tables page

BASIC DATA TRANSFORMATION

• 1.Load Statement
• 2.Renaming a Field
• 3.Script Expressions
• 4.Loading an XML File
• 5.Renaming Fields Using the Qualify Statement
• 6.Key Fields
• 7.Example Predicament
• 8.How Does this Affect You?
• 9.Loading a Field into a Table Multiple Times
• 10.Using a Record Counter on Key Fields
• 11.Is it Correct?

ADDING TEXT DATA

• 1.Employees
• 2.Offices
• 3.Script generation using the File Wizard

GENERATING DATA IN THE QLIKVIEW SCRIPT

• 1.Resident Load
• 2.Using Orders to determine Sales Person.
• 3.Include
• 4.Time Functions: Creating a Calendar
• 5.Getting the Highest and Lowest Date from the Orders Table
• 6.Autogenerate tables
• 7.Creating Variables in the Script
• 8.The Master Calendar

SCRIPTING CONSIDERATIONS

• 1.Synthetic Key Tables
• 2.Circular References
• 3.Causes of Circular References
• 4.Check the Numbers

QLIKVIEW DATA (QVD) FILES

• 1.QVD File Format
• 2.Use of QVD Files
• 3.Creating QVD Files
• 4.Manual Creation of a QVD File in the Script
• 5.Automatic Creation of a QVD File in the Script
• 6.QVD File Script Functions

REPORTING BUGS IN QLIKVIEW ADDITIONAL INFORMATION

• 1.Reference Materials
• 2.Data types in QlikView 
• 
  
•  LAYOUT BASICS FOR DEVELOPERS

• 1.User Friendly Design
• 2.Natural Human Behavior
• 3.Chart and Object Choices in QlikView
• 4.Import/Export Sheet and Document Layouts
• 5.The Completed Script
• 6.QLIKVIEW_Developer_II

INTRODUCTION

• 1.Installing the Course Materials
• 2.Program versions
• 3.Text formats

DEVELOPER TOOLS

• 1.Troubleshooting
• 2.The Debugger

MAPPING TABLES

• 1.Mapping Quarters to the Orders table
• 2.MonthYear
• 3.Cleaning up the table structure

LOADING BUDGET DATA

• 1.Reading Cross Tables

ADVANCED SCRIPTING

• 1.Condition on a field in a table
• 2.Aggregating Data
• 3.Joining tables
• 4.Concatenation
• 5.Preceding Load on Preceding Load

ADVANCED CALCULATIONS IN SHEET OBJECTS

• 1.Set Analysis
• 2.Dollar-Sign Expansion
• 3.AGGR Function

SCRIPTING AND DATA MODELING CHALLENGES

• 1.Link Tables and Concatenated Tables
• 2.Calculating net change within a field
• 3.Functions InDate, Data & DateIslands
• 4.Aggr()
• 5.Class()
• 6.Dynamic Aggregation
• 7.IntervalMatch

DATA MODEL OPTIMIZATION

• 1.Performance Tuning
• 2.Best Practices for QlikView File Optimization
• 3.Creating Incremental Loads

DATA MODEL OPTIMIZATION

• 1.Performance Tuning
• 2.Best Practices for QlikView File Optimization
• 3.Creating Incremental Loads

DAILY AND TRANSACTION BALANCES

• 1.Overview
• 2.Example: Balances at Specific Dates
• 3.Example: Balances for Transactions (in/out)

QLIKVIEW SECURITY 1

• 1.Access control
• 2.Access levels
• 3.Access control database
• 4.Inherited access restrictions
• 5.Hidden script
• 6.Adding Section Access
• 7.Access control for certain commands
• 8.Further access control
• 9.Unattended Command Line Reload Considerations
• 10.Access restrictions on selected field values
• 11.Field value limitation in Section Access

ADVANCED DATABASE CONNECTIVITY

• 1.Custom Data
• 2.SAP Connector

BUSINESS CASE WORKSHOP

• 1.Scenario
• 2.Data Structure

QLIKVIEW_Server_Publisher_I

INTRODUCTION

• 1.Target Audience
• 2.Introduction
• 3.Course Logistics
• 4.Notes

QLIKVIEW DEPLOYMENT CONFIGURATIONS

• 1.Company Requirements
• 2.User Requirements
• 3.What configuration to choose?
• 4.QlikView Standalone
• 5.QlikView Server
• 6.QlikView Server & Publisher

INSTALLING QLIKVIEW SERVER

• 1.Components of the QlikView Server installation file 13
• 2.Prerequisites and preparations for installation

LICENSES AND SERVER TYPES

• 1.License Overview
• 2.Server
• 3.Client Access Licenses
• 4.Publisher
• 5.Local Clients

INTERACTION OF SERVER AND PUBLISHER COMPONENTS

• 1.Workflow and architecture of Document Management & Display
• 2.Document Levels: Script, Data & Layout
• 3.Overall Architecture QlikView 10, technical point of view
• 4.Functional overview of main components

SETTINGS OF QLIKVIEW SERVER, THE QEMC

• 1.Settings of the QEMC
• 2.Status
• 3.System
• 4.Users
• 5.Documents

SECURITY

• 1.General Concept of Security
• 2.Security in QlikView

QLIKVIEW SERVER COLLABORATION

• 1.Sharing objects
• 2.How Server Collaboration works
• 3.Management of Server Collaboration
• 4.More granular control of Server Collaboration

TROUBLESHOOTING

• 1.AccessPoint does not work
• 2.The QlikView Web Server service can’t be started
• 3.AccessPoint displays no content
• 4.Details can’t be displayed in the QEMC or QMC
• 5.The QEMC or QMC don’t work at all

Our Qlikview Online Training batches start every week and we accommodate your flexible timings.

Read More