You, this course and us.
Understanding a Qlikview Document The In-Memory Data Model Installing the Qlikview Desktop Client QV Introduction Document
Loading data from a CSV file Loading data from a Database Avoiding Synthetic Keys Removing Circular References
List Boxes are like Select DISTINCT Table boxes are for Selecting columns Selection interactions in QV Summarizing data with Chart Boxes Data Types in QV : The Dual Format Representation
Adding calculated fields in the load script Using a variable in the load script Joining tables in memory The Keep keyword Loading data from in-memory tables Inline loads
Some useful dashboard elements Grouped Fields Highlighting with Color The total keyword Using Set analysis to override selections
Mapping Loads Generic Load
What will I learn?
- Build Qlikview apps end-to-end from loading to visualization
- Transform data using Joins and Keep
- Visualize data with Charts, Drill downs and Triggers
- Load data from sources like CSVs and Databases
- Run queries using List boxes and Chart boxes
About the course
- Qlikview: One tool to Transform, Summarize and Visualize Data
- A Qlikview app is like an in-memory database. The interactive nature of Qlikview allows you to explore and iterate very quickly to develop an intuitive feel for your data.
- The Qlikview In-memory data model
- Use List boxes, Table boxes and Chart boxes to query data
- Load data into a QV app from CSV and Databases, avoiding Synthetic keys and Circular references
- Transform and adding new fields in a Load script
- Transform tables with Join, Keep
- Effectively present your insights using elements like charts, drill downs, triggers.
- Nested aggregations in charts
- Generic Loads, Mapping Loads, Crosstable
Who should take the course?
- Yep! Data professionals who want a handy tool to play with and explore data
- Yep! Business professionals who prefer interactive environments to heavy duty programming
Pre-requisites & Requirements
- Basic understanding of SQL is assumed