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.
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.
During this video, we will download and install QlikView 12 Personal Edition and also see the QlikView Personal Edition license limitations.
During this video, We will setup our first QlikView document to start the course project.
During this video, we will learn about QlikView documents and sheets and sheet objects. Default user and document setting will be discussed.
Adding data and creating database connections. Also, see different types of data sources to load a QlikView document.
Create QVD files and load them to our QlikView document.
In this video, we will be looking at building the data model, adding data and resolving synthetic keys.
In this video, we look at creating script tabs to organize scripts, load more QVD files, and view table structure
This video will introduce us to the guidelines for QlikView design.
During this video, we have a discussion of design best practices and how to apply them to a QlikView document.
During this video, we will learn to use the if statement to create new data or dimension fields and learn about inline scripts.
The aim of this video is to create a Master Calendar table.
In this video, we will look at solving circular references.
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.
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.