access
lifetime
content
2.5 Hours
Description
A Qlikview app is like an in-memory database. It is a single tool that you can use to transform, summarize, and visualize data. The interactive nature of Qlikview allows you to explore and iterate data very quickly to develop an intuitive feel. In this course, you'll use real-life, practical examples to learn how to work with this tool.- Access 26 lectures & 2.5 hours of content 24/7
- Use list boxes, table boxes, & chart boxes to query data
- Load data into a QV app from CSV & databases, avoiding synthetic keys & circular references
- Transform & add new fields in a load script
- Present your insights effectively using elements like charts, drill downs, & triggers
- Perform nested aggregations in charts
Loonycorn is comprised of two individuals—Janani Ravi and Vitthal Srinivasan—who have honed their respective tech expertise at Google and Flipkart. The duo graduated from Stanford University and believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.
Details & Requirements
- Length of time users can access this course: lifetime
- Access options: web streaming, mobile streaming
- Certification of completion not included
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: all levels
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Course Outline
- Introduction
- You, This Course and Us (1:54)
- Getting Started
- Understanding a Qlikview Document (7:09)
- The In-Memory Data Model (6:47)
- Installing the Qlikview Desktop Client (2:40)
- Loading Data into a QV App
- Loading data from a CSV file (14:03)
- Loading data from a Database (9:06)
- Avoiding Synthetic Keys (10:10)
- Removing Circular References (5:19)
- Exploring Data using the UI
- List Boxes are like Select DISTINCT (5:38)
- Table boxes are for Selecting columns (3:37)
- Selection Interactions in QV (7:59)
- Summarizing data with Chart Boxes (15:42)
- Data Types in QV : The Dual Format Representation (7:28)
- Transforming Data in Load Scripts
- Adding calculated fields in the load script (4:41)
- Using a variable in the load script (3:48)
- Joining tables in memory (3:45)
- The Keep keyword (3:24)
- Loading data from in-memory tables (5:01)
- Inline loads (1:29)
- Effectively presenting data
- Some useful dashboard elements (9:44)
- Grouped Fields (7:46)
- Highlighting with Color (3:33)
- The total keyword (6:04)
- Using Set analysis to override selections (6:04)
- Advanced Load Transformations
- Mapping Loads (2:48)
- Generic Load (4:36)
access
lifetime
content
2.5 Hours