Wednesday 11 November 2015

Qlikview Online Training
sdfWednesday 11 November 2015 0 comments

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 0 comments

Qlikview Online Training Concepts :
INTRODUCTION
✔Target Audience
✔What You Will Learn in this Course
✔Course Logistics
✔Notes
QLIKVIEW ENVIRONMENT
✔QlikView Desktop
QLIKVIEW DEVELOPMENT METHODOLOGY
✔Import/Export Sheet and Document Layouts as XML
✔Qlik Wholesale Trade (QWT) Project Plan
✔Project Plan Review
✔SAFE Methodology
DEPLOYMENT
✔QlikView Standalone
✔QlikView Server
✔QlikView Publisher
INTRODUCTION TO DATA AND SCRIPTING
✔Relational Databases
✔Other Data Structures
✔Comparing Database Structures to QlikView Data Structures
✔Data Structures in QlikView
✔Data Source Files
✔The QWT Primary Data Source
✔The QWT Secondary Data Files
✔Introduction to Scripting
BASIC SCRIPT SYNTAX
✔Syntax
LOADING DATA FROM THE DATABASE
✔Script Generation
✔Comments in the Script
✔Script Debugging
STRUCTURING THE SCRIPT
✔Creating Tabs in the Script
BASIC DATA MODEL AND TABLE VIEWER
✔The Table Viewer
✔The System Table
✔Document Properties: Tables page
BASIC DATA TRANSFORMATION
✔Load Statement
✔Renaming a Field
✔Script Expressions
✔Loading an XML File
✔Renaming Fields Using the Qualify Statement
✔Key Fields
✔Example Predicament
✔How Does this Affect You?
✔Loading a Field into a Table Multiple Times
✔Using a Record Counter on Key Fields
✔Is it Correct?
ADDING TEXT DATA
✔Employees
✔Offices
✔Script generation using the File Wizard
GENERATING DATA IN THE QLIKVIEW SCRIPT
✔Resident Load
✔Using Orders to determine Sales Person.
✔Include
✔Time Functions: Creating a Calendar
✔Getting the Highest and Lowest Date from the Orders Table
✔Autogenerate tables
✔Creating Variables in the Script
✔The Master Calendar
SCRIPTING CONSIDERATIONS
✔Synthetic Key Tables
✔Circular References
✔Causes of Circular References
✔Check the Numbers
QLIKVIEW DATA (QVD) FILES
✔QVD File Format
✔Use of QVD Files
✔Creating QVD Files
✔Manual Creation of a QVD File in the Script
✔Automatic Creation of a QVD File in the Script
✔QVD File Script Functions
REPORTING BUGS IN QLIKVIEW
ADDITIONAL INFORMATION
✔Reference Materials
✔Data types in QlikView 137
APPENDIX: LAYOUT BASICS FOR DEVELOPERS
✔User Friendly Design
✔Natural Human Behavior
✔Chart and Object Choices in QlikView
✔Import/Export Sheet and Document Layouts
✔APPENDIX: The Completed Script
✔QLIKVIEW_Developer_II
INTRODUCTION
✔Installing the Course Materials
✔Program versions
✔Text formats
DEVELOPER TOOLS
✔Troubleshooting
✔The Debugger
MAPPING TABLES
✔Mapping Quarters to the Orders table
✔MonthYear
✔Cleaning up the table structure
LOADING BUDGET DATA
✔Reading Cross Tables
ADVANCED SCRIPTING
✔Condition on a field in a table
✔Aggregating Data
✔Joining tables
✔Concatenation
✔Preceding Load on Preceding Load
ADVANCED CALCULATIONS IN SHEET OBJECTS
✔Set Analysis
✔Dollar-Sign Expansion
✔AGGR Function
SCRIPTING AND DATA MODELING CHALLENGES
✔Link Tables and Concatenated Tables
✔Calculating net change within a field
✔Functions InDate, Data & DateIslands
✔Aggr()
✔Class()
✔Dynamic Aggregation
✔IntervalMatch
DATA MODEL OPTIMIZATION
✔Performance Tuning
✔Best Practices for QlikView File Optimization
✔Creating Incremental Loads
DATA MODEL OPTIMIZATION
✔Performance Tuning
✔Best Practices for QlikView File Optimization
✔Creating Incremental Loads
DAILY AND TRANSACTION BALANCES
✔Overview
✔Example: Balances at Specific Dates
✔Example: Balances for Transactions (in/out)
QLIKVIEW SECURITY 1
✔Access control
✔Access levels
✔Access control database
✔Inherited access restrictions
✔Hidden script
✔Adding Section Access
✔Access control for certain commands
✔Further access control
✔Unattended Command Line Reload Considerations
✔Access restrictions on selected field values
✔Field value limitation in Section Access
ADVANCED DATABASE CONNECTIVITY
✔Custom Data
✔SAP Connector
BUSINESS CASE WORKSHOP
✔Scenario
✔Data Structure
QLIKVIEW_Server_Publisher_I
INTRODUCTION
✔Target Audience
✔Introduction
✔Course Logistics
✔Notes
QLIKVIEW DEPLOYMENT CONFIGURATIONS
✔Company Requirements
✔User Requirements
✔What configuration to choose?
✔QlikView Standalone
✔QlikView Server
✔QlikView Server & Publisher
INSTALLING QLIKVIEW SERVER
✔Components of the QlikView Server installation file 13
✔Prerequisites and preparations for installation
LICENSES AND SERVER TYPES
✔License Overview
✔Server
✔Client Access Licenses
✔Publisher
✔Local Clients
INTERACTION OF SERVER AND PUBLISHER COMPONENTS
✔Workflow and architecture of Document Management & Display
✔Document Levels: Script, Data & Layout
✔Overall Architecture QlikView 10, technical point of view
✔Functional overview of main components
SETTINGS OF QLIKVIEW SERVER, THE QEMC
✔Settings of the QEMC
✔Status
✔System
✔Users
✔Documents
SECURITY
✔General Concept of Security
✔Security in QlikView
QLIKVIEW SERVER COLLABORATION
✔Sharing objects
✔How Server Collaboration works
✔Management of Server Collaboration
✔More granular control of Server Collaboration
TROUBLESHOOTING
✔AccessPoint does not work
✔The QlikView Web Server service can’t be started
✔AccessPoint displays no content
✔Details can’t be displayed in the QEMC or QMC
✔The QEMC or QMC don’t work at all
Read More

QLIKVIEW online Training
sdf 0 comments

QLIKVIEW

QlikView is the most flexible Business Intelligence platform for turning data into knowledge. Effective decision-making is based on having the right information available and easy accessible. Taking just minutes to learn, the automatic associations of QlikView create endless possibilities for making ad hoc queries without requiring tediously defined structures and hierarchies, as is typical in other data analysis tools. QlikView promotes unrestricted analysis of application data, helping users make time-saving and accurate decisions. It brings a whole new level of analysis, insight, and value to existing data stores with user interfaces that are clean, simple, and straightforward.

→ Data warehouse Concepts:

  •  Basics of Data Warehousing.
  • What is OLTP and OLAP?
  • Difference between OLTP and OLAP.
  • Data warehouse Architecture
  • Data mart

→ DDimensional Modeling Concepts:

  •  Introduction to Dimensional Modeling.
  • Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling
  • Dimensional table
  • Fact table
  • Aggregate table
  • Star schema
  • Snowflake schema
  • Star schema Vs. Snowflake schema
  • Fact Vs. Dimension table
  • Fact Vs. Aggregate Table
  • Types of Facts
  • Types of Fact tables
  • Types of Dimensions
  • Level of Granularity
  • Grain of fact
  • Slowly Changing Dimensions( SCD )
  • Normalization
  • DE normalization

→ QlikView Introduction:

  •  What is QlikView?
  • Why QlikView is most effective than other BI Tools.
  • QlikView Architecture.
  • QlikView Components.
  • Qlikview Desktop Developer.
  • QlikView Server.
  • Qlikview Publisher.
  • QlikView Access Protocol.
  • How data flows in QlikView.
Data Loading in QlikView:

→ QlikView Data Sources.

  • Excel File.
  • oracle (ODBC and OLEDB).
  • Web File.
  • Qlikview File (QVW or QVD).
  • Inline Statement.
  • Residental Load.
  • Cross Table Load.

→ Scripting

  • Concatenate.
  • ADD.
  • Do.... Loop.
  • Comment Table and Comment Field.
  • Drop Table and Drop Field.
  • Join.
  • NoConcatenate.

→ Aggregation Functions.

  • Basic Aggregation Functions.
  • String Aggregation Function.
  • Counter Aggregation Functions.
  • Advanced Aggregation.
  • Statistical Aggregation Functions.
  • Financial Aggregation Functions.
  • Statistical Test Functions.

→ Modelling

  • Table Viewer.
  • Modeling Techinques and Best Practices.
  • Semantic Keys and Semantic Tables.

→ QVD File.

  • How to create a QVD File.
  • Reading data from QVD Files.

→ Incremental Load.

  • Insert.
  • Insert and Updates.
  • Incremental Load through a QVD File.
  • Preceeding Load.

→ Hierarchies

  • Drill Down group.
  • cyclic Group.

→ QlikView -Set Analysis and Alternate State.

→ Hierarchies

→ Transformations in QlikView.

→ UI Design(Reporting).

  • User Preferences.
  • Document Properties.
  • Sheet Properties.
  • Sheet Objects.
    • List Box.
    • Let.
    • Set.
    • Statistic Box.
    • Multi Box.
    • Table Box.
    • Chart.
    • Input Box.
    • Current Selections Box.
    • Buttons.
    • Text Object.
    • Line/Arrow Object.
    • Slide/Calendar Object.
    • Bookmark Object.
    • Custom Object.
    • System Table.

→ Miscillaneous Functions:

  • Detach.
  • Clone.
  • OBIEE as source for QlikView.
  • Customized Sort Order.

→ QlikView Server.

  • Overview.
  • Security.
  • Authentication.
  • Authorization.
  • Document Level Authorization.
  • Data Level Authorization.
  • Clustering.

→ QlikView Publisher.

  • Overview.
  • Detailed Technical View.
  • Detailed view of User Interface.
  • Recipients.

→ Other Feature we provide:

  • Real Time Scenarios
  • Resume preparation
  • Sample resumes
  • Interview & certification FAQS
  • How to face the interview
  • Class notes which is useful for who is trying for job
  • Project preparation.
Read More

QlikView Training

Give your developers the tools they need to build and deploy powerful dashboards and applications - BuddhaiSoft Group, a premier QlikView consulting company and Elite Solution Provider, offers QlikView training for users of all experience levels, from beginner to advanced, to best maximize your QlikView deployment. Designed by certified QlikView experts with a combined 100 years of QV experience, our customized courses demonstrate solutions to real-world challenges and leave you better equipped to handle any QlikView scenario. 

"I came with problems, and left with solutions."
Why choose BuddhaiSoft Group for your QlikView training?
  • Real-world examples
  • QlikView-certified instructors
  • Industry expertise: our experts were instrumental in developing QlikView’s certification exams
  • National reach
  • Custom-designed courses
  • Training manuals written by BuddhaiSoft Group
“The style of teaching was comfortable and easy to follow. It was conversational, as opposed to being read some slides and a textbook summary.”
Browse through our classes below to find those that best align with your particular needs and skillsets. Our upcoming instructor-led courses are listed to the right  and for more information, email us using the form on the sidebar or call .
BuddhaISoft SoftWare Development
 Hyderabad
Mobile: +91 - 7799895236 / +91 - 7207401404
ContactUs@BuddhaiSoft.com
BuddhaiSoft@gmail.com

Instructor-led Training: In person

BuddhaiSoft Group's instructor-led QlikView courses are held at our offices in New Jersey, Georgia and Texas and public training facilities throughout the nation. We also offer private, customizable classes, if you prefer to train at your location.

QlikView Designer

QlikView Designer is a scenario-based course covering the fundamentals required to get started building QlikView applications. The course is a mixture of demonstrations and hands-on exercises which integrates user interface layout, design fundamentals, and how to create a QlikView application with sheets, including a case study providing an opportunity to build your own QlikView application. Additionally, the course will take an in-depth look at best practices in design and the different charts and graphs available to developers and business users inside of QlikView applications. This course is recommended for QlikView business users, designers and developers with a knowledge of basic computer concepts and an understanding of how key performance indicators are used. A training manual will be provided.

QlikView Developer

Ready to take your QlikView applications to the next level? Our three-day Developer course is a must if you are building QlikView documents. Knowledge of the data model, creation of the proper data connections and scripting fundamentals are critical to creating QlikView documents that provide your organization with powerful business discovery tools. QlikView Developer provides you with an opportunity to learn by doing through a series of lectures and hands on exercises focused on developing QlikView documents. The course begins with the QlikView environment and ends with an introduction to advanced interface design, as well as a new business case where you can practice your skills in building a QlikView document from the beginning using identified key performance indicators. The QlikView Developer course is recommended for designers and developers who have already completed the QlikView Designer course.

Advanced QlikView Boot Camp

Our advanced three-day QlikView boot camp utilizes a topic-based training approach structured to maximize your time learning the ins and outs of advanced concepts that are typically not covered in traditional training classes.

Why advanced training? Maybe you’ve already taken Qlik’s developer training course, but still find yourself scratching your head when certain situations arise. Our boot camp is structured to give you a core foundation on which nearly any QlikView question can be solved. This will help you execute projects faster, seeing a return on your investment much quicker. By the end of this camp, you’ll be able to effectively read and understand requirements in regards to impact on QlikView coding and design. You will also be able to quickly create supportable data models and understand the front-end concepts that will allow for you to efficiently deliver a sustainable application.

Topics Include:
  • Basic Scripting Best Practices
  • Data Loading
  • Data Architecture
  • Advanced Scripting Functions
  • Data Alignment and Modeling Strategies
  • Data Model Best Practices
  • Common & Adv. Front End Functions
  • Cycle/Drill Groups
  • Variable Expansion Management
  • Set Analysis and Aggr()
  • Actions and Macros
  • Performance Tuning: End User Application
  • Advanced Application Design
  • Building for AJAX - Mobile Design
  • File Metadata
  • Island Tables
  • Extensions
This class is not for beginners and requires a decent understanding of QlikView already.

Instructor-led Training: Virtual

We offer virtual QlikView Designer, Developer and Advanced Boot Camp courses. For a complete list of our upcoming 
BuddhaISoft SoftWare Development
 Hyderabad
Mobile: +91 - 7799895236 / +91 - 7207401404
ContactUs@BuddhaiSoft.com
BuddhaiSoft@gmail.com
Read More

QlikView Online Training
sdf 0 comments

QlikView Online Training

  • Trainer Information
  • 12+ years of career expertise on Business Intelligence tools

  • Trained more than 1000+ learners around the globe
  • Expertise in QlikView ,MSBI(SSRS,SSIS,SSAS),Tableau from various heterogeneous sources
  • Extensive knowledge on Dimensional Data Modeling like Star and Snowflake schemas
  • Strong ability to analyze source systems and business requirements
  • Core topics of online QlikView course:
  • Scripting Considerations
  • QlikView Development

  • Data Transformation
  • Data Visualization

QlikView Course Curriculum

Developer: 10 Hours
  • Script Editor
  • Loading Data to Qlikview using Excel Files
  • Connecting to ODBC or OLEDB Data Sources
  • Loading Data from Other Data Sources
  • Relative Paths
  • Reload,
  • Partial Reload
  • Debugger
  • Creating and Working with QVD files
  • Data Model, Script Editor and Table Viewer
  • Load Statements (Inline Loads, Binary Loads)
  • Joining Tables Where Exists
  • Table Concatenation
  • Synthetic Keys and Synthetic Tables
  • Cross table
  • Mapping loads
  • Apply Map Method
  • Interval Match
  • Aggregation Functions
  • PEEK
  • FirstSortedValue, Hirerachy
  • Set and Let Statements
  • Security Overview
  • Best Practices
Designer: 10 Hours
  • Sheets and Sheet Objects

    • The Table Box
    • Creating Links and Removing Unwanted Links
    • Expressions and Dimensions
    • Editing Expressions
    • Set Analysis
    • Straight and Pivot Tables
    • Bar Charts
    • Text, Line, Button and Action Objects
    • The Multi Box
    • Pie, Block and Funnel Charts
    • Line Charts and Combo Charts
    • Mini Charts, Trellis Charts
    • Dynamic Text
    • Gauges
    • Working with Variables
    • Best Practices
    BuddhaISoft SoftWare Development
     Hyderabad
    Mobile: +91 - 7799895236 / +91 - 7207401404
    ContactUs@BuddhaiSoft.com
    BuddhaiSoft@gmail.com
    Layout Design
  • The Current Selections, Search and Statistics Objects
  • The List Box
Read More