Learn By Example : Qlikview
4.1 (32 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,313 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
4.1 (32 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,313 students enrolled
Created by Loony Corn
Last updated 5/2017
English
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Basic understanding of SQL is assumed
Description

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
02:47:15
+
Introduction
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
02:40
+
Loading Data into a QV App
4 Lectures 38:38

Loading data from a Database
09:06

Avoiding Synthetic Keys
10:10

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


Selection interactions in QV
07:59

Summarizing data with Chart Boxes
15:42

Data Types in QV : The Dual Format Representation
07:28
+
Transforming Data in Load Scripts
6 Lectures 22:06
Adding calculated fields in the load script
04:40

Using a variable in the load script
03:48

Joining tables in memory
03:45

The Keep keyword
03:24

Loading data from in-memory tables
05:00

Inline loads
01:29
+
Effectively presenting data
5 Lectures 33:10
Some useful dashboard elements
09:43

Grouped Fields
07:46

Highlighting with Color
03:33

The total keyword
06:04

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

Generic Load
04:36
+
Appendix
1 Lecture 07:03
MySQL Installation
07:03
About the Instructor
Loony Corn
4.3 Average rating
5,007 Reviews
39,074 Students
77 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 :-)