QlikView Training in Bangalore

Learn QlikView Course from Expert Oracle Trainers who are Real-time Working Professionals.
Expert Trainers | Practical Training | Mock Interviews | Placement Assistance | Job Support

Best QlikView Training in Bangalore

Softgen Infotech is rated as one of the Best QlikView Training Institutes in Bangalore based on Google and other third party reviews. We have completed over 2000 Training classes in QlikView and provided 100% placement assistance to students. Over the past 5 years, Team at Softgen Infotech is dedicated to provide High-Quality Training in QlikView.
 
Trainers at Softgen Infotech are handpicked from QlikView Industry and will have a minimum of 5 years of experience in implementing QlikView Technology. All QlikView Trainers are Professional real-time working consultants who offer hands on experience based on live scenarios.
 
Our QlikView training center in Bangalore is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in QlikView.  We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide 100% placement support for our students.
 

Enroll Today

    Why Choose Softgen Infotech

    Softgen Infotech is a leading Training Institute in Bangalore providing Quality Training for Multiple IT Courses with Placement Assistance.

    Live & Interactive Sessions

    Real Time Training

    Practical Classes

    Interview & Placement Assistance

    Need Advice?

    Worried or Confused whether this is the right course for you? Feel free to reach our Expert Consultant for all your Queries !

    Icon

    Course Material & Syllabus

    Get all Course Content and Syllabus. Get Trained like a  Professional. We Provide Course Material, Prepare for Interviews, Arrange Mock Interviews and 100 % Placement Assistance

    1. What is QlikView?

    1. How does QlikView differ from traditional BI?

    1. Associative user experience

    2. Technology

    3. Adoption path

    2. Exploring data with QlikView

    1. Getting QlikView

    2. Navigating the document

    3. Slicing and dicing your data

    1. List boxes

    2. Selections in charts

    3. Search

    4. Bookmarking selections

    1. Creating a new bookmark

    2. Retrieving a bookmark

    3. Undoing selections

    5. Changing the view

    1. Cyclic groups

    2. Drill down groups

    3. Containers

    6. But wait, there’s more!

    3. The technology and components behind QlikView

    1. The way the data flows

    2. When QlikView use expands

    1. Create content

    2. Reload, publish, and distribute content

    3. Consume content

    4. E-Commerce Overview

    5. Summary & Assignments

    What’s New in QlikView 12?

    6. How is QlikView 12 different from QlikView 11?

    1. Common QIX Engine

    2. 64-bit only

    3. Online documentation

    4. Security improvements

    5. Mobile touch improvements

    6. Improved clustering and scaling

    1. Clustering improvements in QlikView 12.1

    7. What is new in the Qlik product portfolio?

    1. Qlik Sense Enterprise and the Qlik Analytics Platform

    1. In what way are QlikView and Qlik Sense similar?

    2. In what way do QlikView and Qlik Sense differ?

    3. What does this mean for users?

    4. What is the Qlik Analytics Platform?

    2. Qlik NPrinting

    3. Qlik Web Connectors

    4. Qlik GeoAnalytics

    5. Qlik DataMarket

    8. How do the products in the Qlik product portfolio fit together?

    9. What is new in QlikView 12 for Developers?

    10. Summary & Assignments

     Seeing is Believing:

    11. What is a SiB?

    12. Preparing the workspace

    1. Setting up the folder structure

    2. Creating the QlikView document

    13. Creating the app

    1. The requirements

                 2. Constructing the data model

    1. What is a data model?

    2. Loading the fact table

    3. Playing with listboxes

    4. Associating additional tables

    1. Structuring the script

    3. Creating the dashboard tab

    1. Creating and positioning the filters and user controls

    1. Optimizing the screen space

    2. Number of Sales over time

    3. One chart and multiple analyses with cyclic expressions

    4. Adding a time drill-down group

    5. Top 10 routes

    14. Summary & Assignments

     

    Data Sources:

    15. Using ODBC and OLE DB drivers

    1. Installing the drivers

    2. Accessing custom data sources

    3. Accessing web resources via APIs

    1. Qlik Web Connectors

    2. Qlik REST Connector

    4. Reading table files

    16. Extracting data – two hands-on examples

    1. Extracting data from MS Access

    1. Configuring the driver

    1. How to set up an ODBC connection

    2. Creating the OLE DB connection string

    2. Querying the database

    1. The Create Select Statement wizard

                                 1. Adding the Sales tables

    3. Reloading the script

    4. The resulting data model

    17. Loading a table file

    1. Specifying the file attributes

    1. The CSV attributes

    2. A word on quoting

    3. Previewing

    2. The transformation step

    1. Refining the input table

    1. The Where clause wizard

    2. The crosstable

    3. The resulting script

    18. QVD and QVX files

    1. QVD files

    2. QVX files

    19. Loading an Inline table

    20. Summary & Assignments

     

    Data Modeling:

    21. Dimensional data modeling

    1. Back in the day

    2. Relational databases and ER modeling

    3. Dimensional modeling

    1. The star schema

    2. The snowflake schema

    3. Creating the dimensional model

    1. Dealing with multiple fact tables

    4. Dimensional models in QlikView

    22. The associative data model

         1. Guidelines for table associations

    1. How associations are created

    1. Renaming fields

    2. Renaming fields with the Qualify statement

    2. Avoiding data model conflicts

    1. Dealing with synthetic keys

    2. Creating a composite key

    3. Dealing with circular references

    23. The Table Viewer window

    1. Table information

    2. Field information

    3. Table preview

    4. Table viewer menu

    24. Summary & Assignments

     

    Styling Up:

    25. Design requirements

    26. The Document Properties window

    27. The Sheet Properties dialog

    28. Setting the object properties

    1. Caption colors and style

    1. Changing the caption colors

    1. The Color Area and Color dialog windows

    2. Setting the caption font

    3. Setting the content font

    4. Setting the global font

    2. Propagating the object appearance

    3. Setting the default Sheet Object Style

    4. Hiding captions

    29. Working with listboxes

     

     

    1. Adding listboxes

    2. The List Box Properties dialog

    1. The General tab

    2. The Expressions tab

    3. The Sort tab

    4. The Presentation tab

    5. The Number tab

    6. The Font tab

    7. The Layout tab

    8. The Caption tab

    30. The Multi Box

    31. The Current Selections Box

    1. Making selections from the Current Selections Box

    32. Adding a Bookmark Object

    33. Aligning and resizing sheet objects

    1. Selecting objects

    2. Moving objects

    3. Resizing objects

    1. Resizing a Multi Box

    4. Aligning sheet objects

    5. Do a little house keeping

    34. Creating and applying a default color map

    1. Defining chart colors

    2. Setting the default color map

    35. Summary & Assignments

     

    Building Dashboards:

    36. User types

    1. Dashboard users

    2. Analysts

                3. Report users

    37. Applying the DAR principle to E-commerce Operations

    1. Document requirements

    38. Creating the Analysis sheet

    1. Adding a new chart

    2. Bar Chart

    1. Additional bar chart properties

    1. Style

    2. Presentation

    3. Expressions and the Edit Expression window

    1. Expressions

    2. The Edit Expression window

    1. Fields

    2. Functions

    3. Variables

    4. Images

    3. The Expression Overview window

    4. Line Chart

    1. Additional line chart properties

    1. Expressions

    2. Style

    3. Presentation

    5. Combo Chart

    6. Container

    7. Scatter Chart

    8. Button

    9. Statistics box

    39. Creating the new Dashboard sheet

    1. Linked Objects

    2. Gauges

    1. Cloning the object for re-use

                            2. Adding Sale %

    3. More Gauge styles

    3. Adding a Text object

    1. Using a Text Object to display an image

    2. Adding actions to a Text object

    4. Adding a Pie chart

    1. Dimension Limits

    2. Adding the dimension value to the data point values

    40. Creating the Reports sheet

    1. Variables

    1. The Expression Overview window in action

    2. Copying sheets

    3. KPIs per e-commerce, Sales, and Cancellation

    1. Cyclic and Drill-down groups

    4. Straight table

    1. Not all expressions are numbers

    5. Pivot tables

    6. Auto minimize

    7. The Report Editor window

    41. Other charts

    1. Radar Chart

    2. Mekko Chart

    3. Grid Chart

    4. Funnel Chart

    5. Block Chart

    6. Trellis Chart

    42. Summary & Assignments

     

    Scripting:

    43. The Script Editor

                1. Menu and toolbar

    2. Script pane

    3. Tool pane

    44. Script statements

    1. Building the e-commerce dimension tables

    1. Loading the product information

    2. Adding the product groups

    3. Loading the Cancelations table

    4. Making it all right

    2. Manipulating tables

    1. The JOIN statement

    2. The KEEP statement

    3. The CONCATENATE statement

    4. The NOCONCATENATE statement

    5. Using MAPPING tables

    6. Adding comments

    7. Storing tables

    8. Renaming tables and fields

    9. Deleting tables and fields

    3. Setting variables

    4. Controlling script flow

    45. Conditional functions

    46. Dealing with different data types

    1. Strings

    1. String operators

    2. String functions

    2. Numbers and numeric functions

    3. Date and time functions

    47. Debugging script

    1. Syntax check

    2. Saving logs to disk

    3. The script debugger

    1. Using breakpoints

    2. Limited load

    4. Tracing script

    48. Standardizing and organizing script

    1. Using tabs

    2. Comments

    3. Adding an information tab

    4. Script layout

    5. Naming conventions

    1. Table naming conventions

    2. Field naming conventions

    49. Re-using scripts

    1. Subroutines

    2. Including script files

    50. Managing file locations and connection strings

    51. Summary & Assignments

     

    Data Modeling Best Practices:

    52. Data consistency

    1. Dealing with dimensions without facts

    1. An alternative approach

    2. A solo exercise

    2. Dealing with facts without dimensions

    53. Reducing storage requirements

    1. Using number-based key fields

    2. Removing unused fields

    3. Splitting high-cardinality fields

    54. Design challenges of data modeling

    1. The payment info statistics table

                2. Concatenating fact tables

    1. Structural asymmetry

    2. Natural and forced concatenation

    1. Natural concatenation

    2. Forced concatenation

    3. Concatenating the Payment Statistics table

    3. Working with link tables

    1. A link table example

    2. Creating a link table in the Payment and Sales document

    4. Finding a balance

    55. The master calendar

    56. A final note on data modeling

    57. Summary & Assignments

     

    Data Transformation:

    58. Changing the source table structure

    1. “Cleansing” a dirty table

    1. File contents

    2. Working with the Transformation Step wizard

    1. Throwing out the garbage

    2. Unwrapping table contents

    3. Filling missing cells

    3. The final result

    4. Other transformation tricks

    2. Loading a Crosstable

    1. A Crosstable example

    2. Working with the Crosstable Wizard

    3. A solo exercise

    3. Expanding a hierarchy

    1. A hierarchy example

                             2. Working with the Hierarchy Wizard

    3. The tree-view list-box

    4. Generic load

    1. Loading a generic table into QlikView

    59. Summary & Assignments

     

    Advanced Expressions:

    60. Using variables

    1. Creating a variable

    2. Using variables in charts

    3. Interactively changing a variable’s value

    1. Using the Input Box object

    2. Using the Slider object

    4. Using variables based on expressions

    5. Using variables to store expressions

    6. Variable naming convention

    7. The Dollar Sign Expansion syntax

    1. Dollar Sign Expansion with parameters

    2. Double Dollar Sign Expansion

    61. Using the TOTAL qualifier

    62. The Aggr function

    1. Using Aggr for nested aggregation

    1. A word on calculated dimensions

    2. Aggregations over the Aggr output

    1. A word on using the Distinct qualifier

    3. Getting the Average Sales per Day

    63. Conditional functions

    1. The If function

    1. The syntax

    2. A use case

                                       1. Heat charts

    2. A solo exercise

    3. Building a heat chart with the Colormix wizard

    3. Numeric versus text comparisons

    2. The Class function

    1. A solo exercise using the Class function

    3. The Pick function

    1. Using Pick with Dimensionality

    64. A tip on copying expressions

    65. Summary & Assignments

     

    Set Analysis and Point In Time Reporting:

    66. The magic of Set Analysis

    1. What is it for?

    2. Syntax and examples

    1. Using variables in set expressions

    3. Dynamic record sets

    4. More assignment operators

    5. Set operators

    6. Using element functions

    67. Point In Time Reporting

    1. The challenge

    2. Defining the set modifiers

    1. Obtaining the base period record set

    2. Obtaining the compare-to period record set

    3. Constructing the expressions

    4. Enabling additional period comparisons

    1. More Point In Time Reporting examples

    5. Storing set expressions into variables

    1. Set expressions with parameters

                6. Portable set expressions

    1. Set variables and the Master Calendar

    68. Comparative analysis with alternate states

    1. A comparative analysis example

    2. Alternate states step-by-step

    3. State-based expressions

    1. Combining alternate states and the default state

    4. Applying alternate states to layout objects

    5. Document navigation with alternate states

    1. Clearing selections in an alternate state

    69. Always validate

    70. Summary & Assignments

     

    Advanced Data Transformation:

    71. Data architecture

    1. Two-stage architecture

    2. Three-stage architecture

    3. Setting up our environment

    72. Loading data already stored in QlikView

    1. Cloning a QlikView data model

    2. Loading from RAM

    1. Resident load

    73. Aggregating data

    1. Aggregating the Sales Data table

    2. The Transformation output

    3. Aggregation functions

    74. Sorting tables

    1. Ordering the Order-By fields

    75. The Peek function

    76. Merging forces

                1. A refresher

    2. The objective

    3. Getting it done

    1. Loading the table

    2. Sorting the table

    3. Peeking previous records

    4. A solo exercise

    77. Dealing with slowly changing dimensions

    1. The Product table

    2. IntervalMatch magic

    1. Expanding the intervals

    2. Some considerations

    3. Applying IntervalMatch to the Product table

    78. Ordering, peeking, and matching all at once

    1. The use case

    79. Incremental loads

    80. Summary & Assignments

     

    More on Visual Design and User Experience:

    81. Creating a consistent QlikView UI

    1. Screen resolution

    2. Background image

    3. Themes

    1. Applying themes

    2. Creating themes

    1. Adding document properties

    2. Adding sheet properties

    3. Adding sheet object properties

    4. A solo exercise

    82. Additional interactivity

                1. Triggers

    1. Document triggers

    2. Sheet triggers

    2. Actions

    3. Advanced search expressions

    1. A solo exercise

    4. Dynamic bookmarks

    5. Alerts

    6. Conditionally showing and calculating objects

    83. Summary & Assignments

     

    Security:

    84. Hidden script

    85. Section access

    1. Section access fields

    2. Reduction fields

    3. Initial data reduction

    4. Omitting fields

    86. Document-level security

    87. Sheet-level security

    88. Summary & Assignments

     

    Qlikview project:

    89. On OLA Data a project

    Qlikview interview queries:

    90. Data models queries

    91. Frequently asked queries on logics

    92. Functions queries

    93. Schema models queries

    94. Queries on Visualization and why

    95. Set analysis queries.

    96. Visualization logic queries.

    QlikView Training Course Duration & Batch Timings

    Duration : 30 Hours Version : latest Version
    Regular : 1 Hour per day Fast Track : 2 - 3 Hours per day: 10 days
    Weekdays : Monday - Friday Weekend : Saturday and Sunday
    Online Training : Available Class Room Training : Available
    Course Fee : Talk to our Customer Support Mode of Payment : Talk to our Customer Support

    Frequently Asked Questions for QlikView Training Course

    Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

    What Our Students Have to Say about QlikView Course

    Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
    Kelvin Black
    Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
    Zasha Swan

    Book A FREE Demo Today

    Worried or Confused whether this is the right course for you?

    Feel free to reach our Expert Consultant for all your Queries !