Learning QlikView® 12
2.0 (1 rating)
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.
22 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning QlikView® 12 to your Wishlist.

Add to Wishlist

Learning QlikView® 12

Build powerful BI solutions with the finest BI tool on the market
2.0 (1 rating)
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.
22 students enrolled
Created by Packt Publishing
Last updated 1/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Download QlikView Personal Edition and Set up a Project Environment
  • Introduce QlikView terminology such as Document, Sheet Elements and Scripts, Adding data and the different data sources available to use
  • Continue building the data model, resolving synthetic keys and organizing script sections to load data.
  • Create a new document sheet, Design Objects and manage their properties, learn best practice guidelines for design
  • Solve some data modeling challenges, the If statement, using a Master Calendar table, solving Circular References, and join or concatenate tables to create budget data.
  • Create Data Layers with QVD files
View Curriculum
Requirements
  • Some experience with programming would be useful but is not compulsory.
  • This step-by-step tutorial uses a sample application to help you understand the basics of QlikView in a very practical manner.
Description

Application development is a fundamental task for developers. QlikView provides impressive UI Functions to design and customize applications to meet developers’ and organizational needs.

This video course introduces the Business Intelligence platform, Qlikview, and demonstrates to viewers how to leverage the system ultimately to conduct and deliver data analysis on business data. The viewers will learn how to build an application that fulfils the D.A.R (Dashboard, Analysis and Report) approach suggested by Qlik.

The course will start with introducing viewers to the QlikView platform and how to set up their own project. It will take them through document elements and how to create a connection with multiple datasources. The course will guide users in creating Analysis Reports, Adding Visualizations and also tips & tricks on improving them. Users will learn how to optimise their Data Models by using advanced Script Functions.

By the end of the course, the viewers will have a good grounding in QlikView and find it easy to create and analyse reports.

About The Author

B. Diane Blackwood has worked as a consultant implementing business intelligence and corporate performance management solutions since 2005. She has extensive experience in multiple industries (micro-electronics to heavy equipment manufacturing, medical, legal, and various retail industries) implementing BI and CPM solutions. In 2010, she worked with El Camino Hospital creating data warehouse/data marts to feed QlikView, a "social business discovery" software. When working closely with Dr. Michael Gallagher, formerly Director of Informatics at El Camino Hospital, his enthusiasm for the uses of QlikView in analyzing hospital and medical data "infected" her.

Diane and her husband, Bob, moved from Chicago to Albuquerque in June 2012. He took early retirement from the City Colleges of Chicago, and they have had Albuquerque on their short list of retirement locations since 1997.

In the past, Diane has written several biographic encyclopedia articles including articles on Charles Babbage, Erving Goffman, and Isaac Asimov.

Who is the target audience?
  • This course is for data analysts, executives, managers, decision makers, or anyone who works with data and wants to make sense of this data in a simple yet extremely powerful way. This video tutorial is for developers as well as non-developers.
Compare to Other Qlikview Courses
Curriculum For This Course
15 Lectures
01:47:45
+
Course Introduction
4 Lectures 16:52

This video gives an overview of the entire course.

Preview 02:11

During this video, QlikView associations will be presented along with the components and overall architecture. Some common architecture implementations will also be described. Inform the user that we will be using QlikView 12 Personal Edition. 

Overview of the QlikView Platform
07:11

During this video, we will download and install QlikView 12 Personal Edition and also see the QlikView Personal Edition license limitations. 

Installing QlikView Personal Edition
03:01

During this video, We will setup our first QlikView document to start the course project. 

Setting Up the Course Project Environment
04:29
+
Introduction to the QlikView Documents and Scripts
3 Lectures 18:21

During this video, we will learn about QlikView documents and sheets and sheet objects. Default user and document setting will be discussed. 

Preview 05:09

Adding data and creating database connections. Also, see different types of data sources to load a QlikView document. 

Adding Data and Creating Database Connection
06:10

Create QVD files and load them to our QlikView document. 

Creating Data Layers with QVD files
07:02
+
Building the Data Model
2 Lectures 09:36

In this video, we will be looking at building the data model, adding data and resolving synthetic keys. 

Preview 05:52

In this video, we look at creating script tabs to organize scripts, load more QVD files, and view table structure 

Loading and Modeling Sales Transactions
03:44
+
QlikView Design – Elements, Properties, and Guidelines
2 Lectures 18:56

This video will introduce us to the guidelines for QlikView design. 

Preview 07:15

During this video, we have a discussion of design best practices and how to apply them to a QlikView document. 

Applying Design Best Practices to Our New QlikView Sheet
11:41
+
Solving Data Model Challenges
4 Lectures 44:00

During this video, we will learn to use the if statement to create new data or dimension fields and learn about inline scripts. 

Preview 08:21

The aim of this video is to create a Master Calendar table. 

Creating a Master Calendar table
14:22

In this video, we will look at solving circular references. 

Solving Circular References
11:41

In this video, we are concatenating tables to create a budget. By using the concatenate function, the user will learn its benefits for performance and data modeling. 

Learning Tables Concatenation Usage
09:36
About the Instructor
Packt Publishing
3.9 Average rating
8,229 Reviews
58,953 Students
687 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.