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, based in BTM Layout, is a premier training
facility that offers real-time and job-oriented QlikView Training Courses. We
have completed over 2000 QlikView sessions with a 100% placement rate,
assisting college students. For the past 5 years, the team at Softgen infotech
has been dedicated to providing high-quality QlikView training.
Softgen Infotech’s trainers have a minimum of 5 years of
experience implementing QlikView Technology and are hand-picked from the
QlikView sector. All QlikView Trainers are real-world consultants with
extensive experience in providing hands-on training based on real-time
scenarios.
Our QlikView training centre in Bangalore is completely
equipped with labs and excellent infrastructure to give you hands-on
experience. We also provide certification training for QlikView. We have
successfully trained and placed several of our students in huge MNC firms with
the help of placement assistance.
Contact us and let us together build a perfect career for your future!
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 !

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 list boxes
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.