QLIKVIEW

QlikView is a leading Business Discovery Platform. It is very powerful in visually analyzing the relationships between data. It does in-memory data processing and stores the data in the report itself that it creates. It can read data from numerous sources including files and relational databases. It is used by businesses to get deeper insight by doing advanced analytics on the data they have. It even does data integration by combining data from various sources into one QlikView analysis document.

Satisfied Learners


Best QlikView Training in Pune by Industry Experts

Duration of Training: 6 weekends

download (5)

 

 

 

Qlikview  Syllabus

What is QlikView? 

How does QlikView differ from traditional BI? 

Exploring data with QlikView 

Navigating the document 

Slicing and dicing your data 

List-boxes 

Selections in charts 

Search

Bookmarking selections 

Undoing selections 

Cyclic Groups 

Drill down Groups 

Containers 

The technology and components behind QlikView  and the way the data flows 

Reload, publish, and distribute content  25

Project

What is a SiB? 

Preparing the workspace 

Setting up the folder structure 

Creating the QlikView document 

Creating the app  

Constructing the data model 

What is a data model? 

Loading the fact table 

Playing with listboxes 

Creating the dashboard tab 

Creating and positioning the filters and user controls 

One chart and multiple analyses with cyclic expressions 

Adding a time drill-down group  

Data Sources 

Accessing custom data sources 

Third-party custom connectors 

Reading table files 

Extracting data

Creating the OLE DB connection string

Querying the database

Reloading the script 

The transformation

Refining the input table 

QVD and QVX files 

QVD files 

QVX files 

Loading an Inline table 

Data Modeling 

Dimensional data modeling 

Relational databases and ER modeling 

Dimensional modeling 

The star schema 

The snowflake schema 

Creating the dimensional model 

Dimensional models in QlikView 

The associative data model 

How associations are created 

Avoiding data model conflicts 

Table information 

Field information 

Table preview 

Table viewer menu 

Styling Up  

Design requirements 

The Document Properties window 

The Sheet Properties dialog 

Setting the object properties 

Caption colors and style 

Changing the caption colors 

Setting the caption font 

Setting the content font 

Setting the global font 

Propagating the object appearance

Setting the default Sheet Object Style 

Hiding captions 

Working with listboxes

Adding listboxes

The Expressions tab 

The Sort tab 

The Presentation tab 

The Number tab 

The Font tab 

The Layout tab 

The Caption tab 

The Multi Box 

The Current Selections Box 

Adding a Bookmark Object 

Aligning and resizing sheet objects 

Selecting objects 

Moving objects 

Aligning sheet objects 

Defining chart colors 

Setting the default color map  

Building Dashboards 

Expressions and the Edit Expression window 

The Edit Expression window 

Auto minimize  200

The Report Editor window 

Other charts 

Radar Chart 

Mekko Chart 

Grid Chart 

Funnel Chart 

Block Chart 
Trellis Chart  

Depending on the selection of the BI tool we train you to crack the first step of Data Analytics certification (Developer/Designer for Qlikview) with the guidance of the trainer and the most expected questions in the certification along with the tips and tricks to quickly make your answers by interpreting the questions asked in the certification.

The trainer has 10+ years of experience into Business Intelligence blended with Data Analytics and real time BI implementations of Banking,Retail and Pharma domain which implement BI on a very high scale. Along with the industrial experience he carries a suite of different use cases in the industry and their solutions as a part of the training. The past candidates have successfully been able to grasp the tool after being taught and keep receiving solutions for existing problems in the Real time experience and bond shared by the trainer.

Radical believes in giving Quality to their candidates by gelling up the real time industry experience shared by the trainers. We believe in taking the tour of the technology to a deep level assuming that it provides value in the long rum to its students and they keep up a good bond with the institute and the trainer in their long journey. Swift responses to queries, Alternate solutions to problems and real time use cases of business makes it unique as a training institute.

After learning Qlikview you can support the reporting and ELT mechanism of any reporting framework. Adding to it you will also be in a position to explore Qliksense and create visualizations for mobile and desktop resolutions

Our Courses

Drop A Query