|
QlikView Course Content
It is one of the Data Ware house Tool. It is mostly used in BI. The QlikView Business Discovery platform delivers true self-service business intelligence that empowers business users and drives innovative decision making.
Ø Layout and best application design practices. What should you think about when
designing an application?
Ø How to use QlikView Desktop.
Ø What is a sheet, sheet object, list box and a table box?
Ø How do we create the QlikView objects mentioned above, how do we use them,
including examples such as sorting data, entering data, exporting data.
Ø You will learn about charts objects, how to create them and the many functionalities,
how to edit the format and layout.
Ø How to load data into QlikView.
Overview of QlikView Desktop.
Ø Introduction to multi dimensional objects such as pivot tables, straight tables with
multiple expressions.
Ø Advanced usage of the many QlikView charts and objects, such as tree views in list
boxes and mini charts.
Ø Advanced calculations using set analysis and AGGR function.
Ø Gauges, buttons, actions – what are they and how do you develop them.
Ø Introduction to some other useful objects such as slider/calendar objects.
Ø QlikView reports and how do you create and manage them.
Ø Business case workshop.
The QlikView environment.
Ø Overview of QlikView development methodology, SAFE.
Ø How to deploy QlikView, standalone, Server and Publisher.
Ø Introduction to data and scripting, relational databases and other data structures.
Ø Connecting to ODBC and also OLEDB data sources.
Ø Introduction to the underlying scripting language and best practices in how to use this,
including the use of time functions and creating variables.
Ø Overview of data preparation required before starting to develop a QlikView
application.
Ø Basic data model overview and understanding of QlikView table viewer.
Ø How to resolve abnormalities in the data structure, such as synthetic keys.
Ø QlikView QVD file and how to create them and use them.
Learn about the debugger and troubleshooting.
Ø How to add text data and how to generate data in the QlikView script.
Ø Mapping tables and cleaning up a data structure.
Ø How to load budget data.
Ø Script language and how to aggregate data, joining tables, concatenation, functions,
interval match and other scripting features.
Ø Analyze data over time using Set analysis and Aggr Function.
Ø Data model optimization and performance tuning and how to create incremental loads.
Ø Overview of QlikView security and various access settings and levels.
Ø Advanced database connectivity.
Ø To finish it off a case study - each student gets to develop a QlikView application, which
includes: loading in data, resolving data issues and building the UI with the help of
business KPI.
|
