Learn By Example : Qlikview
3.7 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6,433 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn By Example : Qlikview to your Wishlist.

Add to Wishlist

Learn By Example : Qlikview

An all-round toolkit to play with data
3.7 (34 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6,433 students enrolled
Created by Loony Corn
Last updated 5/2017
English [Auto-generated]
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build Qlikview apps end-to-end from loading to visualization
  • Load data from sources like CSVs and Databases
  • Transform data using Joins and Keep
  • Run queries using List boxes and Chart boxes
  • Visualize data with Charts, Drill downs and Triggers
View Curriculum
  • Basic understanding of SQL is assumed

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. 

What's covered?

1) The Qlikview In-memory data model

2) Use List boxes, Table boxes and Chart boxes to query data

3) Load data into a QV app from CSV and Databases, avoiding Synthetic keys and Circular references

4) Transform and adding new fields in a Load script

5) Transform tables with  Join, Keep

6) Effectively present your insights using elements like charts, drill downs, triggers. 

7) Nested aggregations in charts

8) Generic Loads, Mapping Loads, Crosstable  

Using discussion forums

Please use the discussion forums on this course to engage with other students and to help each other out. Unfortunately, much as we would like to, it is not possible for us at Loonycorn to respond to individual questions from students:-(

We're super small and self-funded with only 2 people developing technical video content. Our mission is to make high-quality courses available at super low prices.

The only way to keep our prices this low is to *NOT offer additional technical support over email or in-person*. The truth is, direct support is hugely expensive and just does not scale.

We understand that this is not ideal and that a lot of students might benefit from this additional support. Hiring resources for additional support would make our offering much more expensive, thus defeating our original purpose.

It is a hard trade-off.

Thank you for your patience and understanding!

Who is the target audience?
  • 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
Compare to Other Qlikview Courses
Curriculum For This Course
27 Lectures
1 Lecture 01:54

We start with an introduction, what the course is about and what you'll be able to do at the end of it 

Preview 01:54
Getting Started
3 Lectures 16:36

A Qlikview document is like a database, an excel sheet and a presentation in 1! 

Preview 07:09

Understanding how data is laid out 

Preview 06:47

Get started by installing Qlikview 

Installing the Qlikview Desktop Client
Loading Data into a QV App
4 Lectures 38:38

Loading data from a Database

Avoiding Synthetic Keys

Removing Circular References
Exploring Data using the UI
5 Lectures 40:24
List Boxes are like Select DISTINCT

Selection interactions in QV

Summarizing data with Chart Boxes

Data Types in QV : The Dual Format Representation
Transforming Data in Load Scripts
6 Lectures 22:06
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
Effectively presenting data
5 Lectures 33:10
Some useful dashboard elements

Grouped Fields

Highlighting with Color

The total keyword

Using Set analysis to override selections
Advanced Load Transformations
2 Lectures 07:24

Generic Load
1 Lecture 07:03
MySQL Installation
About the Instructor
Loony Corn
4.3 Average rating
5,464 Reviews
42,646 Students
75 Courses
An ex-Google, Stanford and Flipkart team

Loonycorn is us, Janani Ravi and Vitthal Srinivasan. Between us, we have studied at Stanford, been admitted to IIM Ahmedabad and have spent years  working in tech, in the Bay Area, New York, Singapore and Bangalore.

Janani: 7 years at Google (New York, Singapore); Studied at Stanford; also worked at Flipkart and Microsoft

Vitthal: Also Google (Singapore) and studied at Stanford; Flipkart, Credit Suisse and INSEAD too

We think we might have hit upon a neat way of teaching complicated tech courses in a funny, practical, engaging way, which is why we are so excited to be here on Udemy!

We hope you will try our offerings, and think you'll like them :-)