Mountains

Qlikview

What is QlikView?

QlikView is one of the leading Business Intelligence tools. You can interpret actionable business insights from raw data easily. State of the art visualization is not luxury anymore, it is the necessity now. Centralised, Standardised and Automated solutions possible with QlikView.

  • Who can learn?

    Suitable for Team Leads, Business Analysts, Analysts, Software Developers, Mid and Higher-level Management, Data Scientists.

  • What do I Learn

    QlikView Business intelligence application build, learn the art of visualisation, QlikView ETL

 

Basics of Qlikview
What is Qlikview? Why Qlikview? Who can use Qlikview?
Thinking through a BI solution build
Structured approach for first dashboard build in a Visualisation tool
Understanding Qlikview Desktop, Publisher, Server, QlikSense
Quick Tour of Qlikview tool : Scripting, Front End Canvas, Automation
Basic Elements of the QV User Interface - Tool Bars(Standard, Menu, Design tool bars)
Demo: State of the art BI Dashboard in Qlikview
List Boxes, Pivot Charts, Straight Tables, Table Box, Pie Chart, writing expressions, Associative Search
Qlikview Scripting
Necessity of Scripting
Connecting to Data Source: Select and Load
Connecting to Data Base(thru OLEDB), Excel File, QVDs, Qlikview Application(Binary Load) etc;
Understanding Preceding Load
What if Analysis: Input Filed, Input Sum
Variables declaration with LET, SET
Dollar Sign Expansion (DSE) of Variables
Data Modelling in Qlikview
Loading Multiple files to QV, Table Viewer
Table Joins: Join, Left, Right, Inner Joins
Keep: Left, Right, Inner
Concatenate Tables (Implicit, Explicit Concatenation), Prevent Implicit Concatenation
Start Schema, Snow Flake Schema
Expression Viewer, Variable Editor, Log File Creation
Button Object, Reload Time function
Importance of System Fields

Data Modelling Optimization
Challenges of Data Modelling: Synthetic Key, Circular References, Loosely Coupled Tables
Solution: Rename Fields, Auto number, Qualify (UnQualify), Concatenate, Composite Key
Linked Tables
Dashboard Real Estate space Optimization Techniques
Multi Box
Container: Different Types
Data Load Types
Cross Tables
Mapping Load and Mapping Tables
Reading and Writing QVD files, csv Files in the script
Advantages of QVDs and creation of QVDs from Chart
Buffer Load, Incremental Load, Resident Load
Binary Load in detail
Partial Reload (Add, Replace)
Combo Chart, Trellis
Transformations
Table Transformation
Generic Load
Cross Tables
Hierarchy
Create Theme File
Book Marks
Advanced Charts
Qlikview Functions
Radar Chart
Scatter Chart
Grid Chart
Fast Change of Charts
Cyclic Chart
Drill Down Chart
Set Analysis Expressions
Set Analysis
Set Identifier, Operator, Modifier
Indirect Set Analysis: P(), E()
Mekko Chart
Tips and Tricks

     

Course Features

  • Next Batch Saturdays
  • Duration 24 Hrs
  • Students 45
  • Certificate Yes
  • Price Call - 91485 67987

About Us

We are the leading State of the Art Skill enhancer in the field of professional's training. Our idea of enhancing skills is through detailed industry research, experiential training, consulting, collaborations, innovations, and importantly experiments.

We have a proud Partnership with Leading trainers in the Industry ExcelR Solutions.


Reach Us

Skillnest Solutions,
Rajarajeshwari Nagar, Bangalore-560098

+91 91485 67987

info@skillnestsolutions.co.in

DISCLAIMER :

• PMI®, PMBOK® Guide, PMP®, PgMP®, CAPM®, PMI-RMP®, PMI-ACP® are registered marks of the Project Management Institute (PMI)®