<?php the_title_attribute(); ? data-src=
Admin bar avatar

Bodhi IT

 4.5 (5 Reviews)

Course Duration

40 hour

About QlikView and Qlik Sense

QlikView and Qlik sense  Analytics Cloud is a new tool in the QlikView and Qlik sense portfolio to meet the needs of data visualization in the cloud. It is delivered as an all-in-one, SaaS-based product. It covers the needs of data visualization, budget planning, and predictive analytics. QlikView and Qlik sense offers a complete solution when it comes to business intelligence. Accessible online in SaaS mode, QlikView and Qlik sense is becoming increasingly important in the QlikView and Qlik sense ecosystem. Eventually, it is destined to become the BI reference tool for the QlikView and Qlik sense Cloud suite. BODHI IT provides best QlikView and Qlik sense Online Training in Hyderabad and all over world.

Qlikview and Qliksense

1. Data Modelling
  • Dimensions
  •  Facts
  •  Schemas
  •  Best Practices
  •  Link table vs concatenate
  • Normalization

2.Qlikview Introduction
  • QlikView features
  •  Value creation
  •  Story telling
  •  How to think while designing apps?
  •  Concepts of BI
  • Tools (Tableau vs Qlik)

3. QlikView Implementing Architecture
  • Database Connectivity
    1.SQL Queries
    2.SQL Tables
    3. ODBC/JDBC
    4.  DSN Creation
  •  QlikView Memory Management
  •  QVD Layer
    1. Database connection in Qlik
    2. Generations of QVD
    3. Fetch data from other data sources in Qlik
  • Transformation Layer
    Identifying Facts and dimensions
  • Creation of Data Model
    1. Scripting techniques
    2. Optimization in scripting
    3. Applying Business logic
    4. Creating Calendar
    5. Types of Load
  •  Visualization
    1. Identifying KPIS for the business
    2. Layouts and colours
    3. Bookmark
    4.Extensions
  •  Deployment Process

4. Set Analysis and Functions
  • Point in Time Reporting
    1. Current Year
    2.  Previous Year
    3.  YTD
    4. MTD
  • Chart Function
    1. Range
    2.  Aggr
    3.  Class
    4. Pick
    5.  Above
    6.  Below
  • Scripting Functions
    • Control Statement
      1. If else
      2.  For loop
      3.  Switch Case
    • Other Functions
      1. Apply Map
      2.  Match
      3. Look up
      4.  Wild match
      5.  Interval match
      6.  FirstsortedValue
      7.  FieldValue
      8.  Exists
      9.  Isnull
      10.  Date functions
      11.  Time functions
      12.  Aggregated functions
      13.  Peek
      14.  Previous
      15.  Rec no
      16.  Row no
    • Techniques
      1. Joins
      2.  Group By
      3.  Order By
      4.  Keep
      5.  Concatenation
      6.  Variables
      7.  Let
      8.  Set
    • Pnl Template Explanation

5. Qlik Project Management Process
  • Business Understanding – Ground work to be done before project
    1. Clearly understanding the KPIs and the business terminology
  •  Requirement Gathering
  •  Technical Architecture
  •  Development Governance
  •  Testing
    1. Unit Testing – at the time of development
    2. Test Cases formats
  •  UAT
  •  User Presentation/Demos
  •  KT and Adoption Techniques and Support related
  •  Detailing of each charts – Dashboard
    1. CBT

6. Qlik Visualization
  • Scripting End
  • Visualization End
  •  Server Performance Side
  •  Performance Turning

7. Optimization and Best Practices
  • Predictive scenario overview
  • SAC Stories vs SAC Applications vs SAC Predictive
  • Working with Datasets, Variables
  • Understand Regression
  • Understand Logistic Regression, RoC Curves, AUC Curve
  • Model performance and Confusion Matrix
  • Profit Simulation for Classification
  • Implementing Classification Precative Model
  • Implementing Regression Predictive Model
  • Residual and MAPE Concept in Regression
  • Trend, Cycle, Residual and Variations concepts
  • Implementing a Time series Predictive Model
  • Generating predictive stories

    Qlikview and Qliksense

    • Dimensions
    •  Facts
    •  Schemas
    •  Best Practices
    •  Link table vs concatenate
    • Normalization

    • QlikView features
    •  Value creation
    •  Story telling
    •  How to think while designing apps?
    •  Concepts of BI
    • Tools (Tableau vs Qlik)

    • Database Connectivity
      1.SQL Queries
      2.SQL Tables
      3. ODBC/JDBC
      4.  DSN Creation
    •  QlikView Memory Management
    •  QVD Layer
      1. Database connection in Qlik
      2. Generations of QVD
      3. Fetch data from other data sources in Qlik
    • Transformation Layer
      Identifying Facts and dimensions
    • Creation of Data Model
      1. Scripting techniques
      2. Optimization in scripting
      3. Applying Business logic
      4. Creating Calendar
      5. Types of Load
    •  Visualization
      1. Identifying KPIS for the business
      2. Layouts and colours
      3. Bookmark
      4.Extensions
    •  Deployment Process

    • Point in Time Reporting
      1. Current Year
      2.  Previous Year
      3.  YTD
      4. MTD
    • Chart Function
      1. Range
      2.  Aggr
      3.  Class
      4. Pick
      5.  Above
      6.  Below
    • Scripting Functions
      • Control Statement
        1. If else
        2.  For loop
        3.  Switch Case
      • Other Functions
        1. Apply Map
        2.  Match
        3. Look up
        4.  Wild match
        5.  Interval match
        6.  FirstsortedValue
        7.  FieldValue
        8.  Exists
        9.  Isnull
        10.  Date functions
        11.  Time functions
        12.  Aggregated functions
        13.  Peek
        14.  Previous
        15.  Rec no
        16.  Row no
      • Techniques
        1. Joins
        2.  Group By
        3.  Order By
        4.  Keep
        5.  Concatenation
        6.  Variables
        7.  Let
        8.  Set
      • Pnl Template Explanation

    • Business Understanding – Ground work to be done before project
      1. Clearly understanding the KPIs and the business terminology
    •  Requirement Gathering
    •  Technical Architecture
    •  Development Governance
    •  Testing
      1. Unit Testing – at the time of development
      2. Test Cases formats
    •  UAT
    •  User Presentation/Demos
    •  KT and Adoption Techniques and Support related
    •  Detailing of each charts – Dashboard
      1. CBT

    • Scripting End
    • Visualization End
    •  Server Performance Side
    •  Performance Turning

    • Predictive scenario overview
    • SAC Stories vs SAC Applications vs SAC Predictive
    • Working with Datasets, Variables
    • Understand Regression
    • Understand Logistic Regression, RoC Curves, AUC Curve
    • Model performance and Confusion Matrix
    • Profit Simulation for Classification
    • Implementing Classification Precative Model
    • Implementing Regression Predictive Model
    • Residual and MAPE Concept in Regression
    • Trend, Cycle, Residual and Variations concepts
    • Implementing a Time series Predictive Model
    • Generating predictive stories

0.0
0 total
5
0
4
0
3
0
2
0
1
0

Course Features

  • Students Limited
  • Certificate Yes
  • Skill Advance
  • Category Instrumentation

Request for Free Demo

    Training Features

    Live Online Training

    Live online training session will be given by our trainers and are available to answer your queries.

    Time flexibility

    We conduct classes in most of the day. We are flexible to train you according to your schedule.

    Real time scenario

    All of our trainers are come from different industry they are experts in explaining scenarios that are happening in real time.

    Best IT Leading Software Training Institute

    Talk with Bodh IT