QlikView Training in Bangalore

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.