Last updated 4/2017MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 241.10 MB | Duration: 1h 53m

 

Learn efficient data analysis skills with the simple yet powerful tool—QlikView

What you'll learn

Set up a Project Environment

Build the data model, resolve synthetic keys, and organize script sections to load data

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

Learn how to Load data from different sources, including QVD files and how to optimize data models for accuracy and precision

Create accessible dashboards and quality data visualizations to share insights effectively

Learn how to secure and deploy your BI application for optimal availability

Requirements

No prior knowledge of QlikView is required for you to take this course.

Description

Are you a data analyst, executive, manager, decision maker, or anyone who works with data and wants to make sense of this data in a simplistic yet powerful way? Then, you'd want to try QlikView.

What differentiates QlikView from other Business Intelligence software is its simplicity and ease of use. It's easy to be in total control of data with it. You wouldn’t want to miss out on trying this tool.

QlikView: Data Analysis exists as a blend of text, videos, code examples, and assessments, which together makes your learning and creating journey all the more fun and worth the cost.

This course introduces QlikView and demonstrates to you how to leverage the system to conduct and deliver data analysis on business data. You’ll learn how to build an application that fulfils the D.A.R (Dashboard, Analysis, and Report) approach suggested by Qlik. Then, you'll be equipped to use mapping tables and create a master calendar. Moving from there, you’ll find out how to get the most from QlikView’s visualization features—vital if you are to use your data insights effectively.By the end of the course, you’ll be ready to solve real-world challenges using QlikView.

The goal of this course is to make you a skilled QlikView Data Analyst.

This course is authored by some of the best in the fields.

Why should I choose this course?

We've spent the last decade working to help developers stay relevant. The structure of this course is a result of deep and intensive research into what real-world developers need to know in order to be job-ready. We don't spend too long on theory, and focus on practical results so that you can see for yourself how things work in action.

This course follows an example-based approach that will take you through the most basic games toward the more complex ones, gradually building your skill level. It's a blend of text, videos, code examples, and assessments, which together makes your learning journey all the more exciting and truly rewarding. It includes sections that form a sequential flow of concepts covering a focused learning path presented in a modular manner. This helps you learn a range of topics at your own speed and also move towards your goal of learning Unity.

We combine the best of the following Packt products

Learning QlikView 12 by B. Diane BlackwoodQlikView Essentials by Chandraish Sinha

Meet your expert instructors

B. Diane Blackwood

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.

Chandraish Sinha

Chandraish Sinha is a Business Intelligence enthusiast from Ohio. He brings 17 years of experience in providing cost-effective BI solutions.

He is responsible for many QlikView implementations in various industries, namely financial, insurance, pharmaceuticals, and event management. He currently holds QlikView Designer and QlikView Developer certifications.

Overview

Section 1: Getting Started

Lecture 1 Introduction

Lecture 2 Overview of the QlikView platform

Lecture 3 Installing QlikView Personal Edition

Lecture 4 Setting up the course project environment

Section 2: Introduction to the Qlikview Documents and Scripts

Lecture 5 The QlikView document elements and properties

Lecture 6 Creating a database connection

Lecture 7 Creating data layers with QVD files

Section 3: Building the Data Model

Lecture 8 Loading more data and resolving synthetic keys

Lecture 9 Loading and modeling sales transactions

Section 4: Learning Qlikview Design – Elements, Properties, and Guidelines

Lecture 10 Adding a customer sheet to our QlikView document

Lecture 11 Applying design best practices to our new QlikView sheet

Section 5: Solving Data Model Challenges

Lecture 12 Using the if statement or inline load

Lecture 13 Adding a Master Calendar table

Lecture 14 Solving Circular References

Lecture 15 Concatenating tables to create a budget

Section 6: Securing Your Application

Lecture 16 Introduction

Lecture 17 Section Access essentials

Lecture 18 Implementing Section Access

Section 7: Application Deployment

Lecture 19 Introduction

Lecture 20 QlikView architecture essentials

Lecture 21 Client Access Licenses (CALs)

Lecture 22 QlikView application deployment

Lecture 23 QlikView server structure

Lecture 24 for a Challenge

A data analyst, executive, manager, decision maker, or anyone who works with data and wants to make sense of the data in a simplistic yet powerful way

HomePage: