QlikView by Examples - Beginner course [Fast Track]
4.7 (3 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.
528 students enrolled
Wishlisted Wishlist

Please confirm that you want to add QlikView by Examples - Beginner course [Fast Track] to your Wishlist.

Add to Wishlist

QlikView by Examples - Beginner course [Fast Track]

Must have course for beginners and University students.
4.7 (3 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.
528 students enrolled
Created by Taha Mahmoud
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $95 Discount: 89% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 10 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build the example dashboard shown in the introduction lecture
  • Know the main process to develop a QlikView application
  • Learn the basics of Script Editing
  • How to create different QlikView charts
  • How to create lists and containers
  • How to implement KPIs and metrics
  • Difference between Cyclic dimensions and drill down hierarchies
  • How to configure the basic graph / chart features
View Curriculum
Requirements
  • QlikView personal edition should be installed on your PC before starting this course.
  • Basic knowledge about Business intelligence like what a dimension, measure, chart means....etc.
Description

This Course will help you to understand and learn 80% of what QlikView designer need to know. the remaining 20% will come through experience and hands on. This course is specially designed to deliver knowledge in an easy way by developing and ready mad QlikView application and step by step from scratch. The main target Audience for this course are  University students to help them doing their Mid-term and final term assignments. The course duration is around 1 hour which guarantee to deliver maximum required information in lowest possible time. All what you need to do is 

  1. watch this course
  2. workout the final project
  3. discuss your final output with me
  4. start working in your University assignment. 

The main advantages of this course:

  • No Time: The is a fast track course so you will be able to start creating QlikView application after 1 hour.
  • Step By Step: Course designed to deliver information with examples and step by step guide.
  • Final Project: The final course project will help you to assess you understanding and highlight any gaps in your knowledge.
  • Additional Materials: Course is designed to University students with tons of materials, writ-ups, hints, best practice and much much more.
  • Life Time Support: By enrolling to this course; You will get life time support, help while you are creating your University assignment, recommendation and best practice.

I already helped many students to get very good marks and so I'm ready to help you as well. What you are waiting for; enroll now and challenge your colleagues. Show them that you can get the full marks.

Who is the target audience?
  • Any one want to learn QlikView
  • Business Intelligence designers
  • Students whom need help to do their University assignments.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
QlikView by Examples - Introduction
2 Lectures 09:45

This lecture is an introduction to the course:

  • Introduce the lecturer
  • Define the target audience
  • What you are going to learn from this course
Preview 04:15

Super-Market Excel file is the data source that we are going to use during this course. This lecture will give you an overview about the raw data stored in that file.

Preview 05:30
+
Data Modeling - Script Editor [basics]
1 Lecture 09:53

Summary:
========

1) The first step to create a QlikView application is to connect to a data source. In our case we will use SuperMarket data Excel file
2) The 2nd step is to prepare data by adding costume calculated dimensions and measures.
3) The last modeling step is to Load the script.

Preview 09:53
+
Creating QlikView Applications
5 Lectures 14:26

Summary:

1) List box is the basic selector in any QlikView Application.

2) To create a list box; Right click on any empty space in the application; then select "New sheet Object" --> "List Box"
3) You can control many list box properties like showing / hiding caption or enable / disable search feature. 

Creating List Boxes
02:54

Summary:

  1. Containers can be used to contain charts as well as list boxes.
  2. Containers are used to Utilize the space in an efficient way.
  3. You can adjust containers tab locations from the "Presentation" menu
Creating Containers
04:34

Summary:

1) List boxes can display values horizontal or vertically.

2) Search function will allow you to search for a specific value in the list box.

3) You can use / remove borders from "Layout" menu.

Advanced List Boxes properties
04:27

1) Current Selections Box can be added from "New sheet Object" menu
2) The current selections box will display all values which been selected currently.
3) you can clear selections by clicking on the eraser icon beside any selection

Current Selections Box
01:07

Summary:

To add an image to your QlikView application:
1) Add new text box.
2) Display as "Image"
3) Select the required pictures

Creating Logos
01:24
+
Creating QlikView Applications - Advanced Featuers
3 Lectures 24:19

Summary:

1) Metric are plain numbers that have no indications.
2) Count of customers and number of transactions are 2 metrics examples
3) Metric are useful to display high level numbers

Creating Metrics
05:25

  • KPIs: Key Performance indicators are metric assigned with Target, comparison or trend
  • KPIs usually presented as percentage.
  • KPIs will indicates good or bad performance
Creating KPIs
10:24

There are many types of charts:

  • Line chart: the best way to show trends
  • Bar / Column chart: best way to show comparison
  • Combination Chart: one metric presented as line and the other one as bars.
  • Bubble Chart: show 2 measures against 1 dimension  

There is 3 types of groups:

  • Hierarchy: used to represent hierarchy like Country - State - City. we use drill down to navigate the hirarchy.
  • Cyclic dimension: used to swap between dimensions  
  • Cyclic Measure: used to swap between measures
Creating Charts
08:30
+
Assignments
1 Lecture 00:24

test yourself and find out your knowledge gaps 

Final Exam
8 questions

Final Project
00:24
About the Instructor
Taha Mahmoud
4.2 Average rating
60 Reviews
1,894 Students
5 Courses
Senior BI and EDW consultant

Taha M. Mahmoud (PMP, TOGAF, ITIL, and CSM) is a senior BI consultant, BI project manager, and solution architect. He has a BS degree in computer science and automatic control from Alexandria University, Egypt. He has a great passion for new technologies, especially those related to business intelligence. Taha has more than 9 years of experience in working on, consulting for, and deploying successful BusinessObjects projects in the banking and telecom industries. He is the author of "Creating Universes with SAP BusinessObjects" and "Learning SAP BusinessObjects Dashboards".

Publication(s):

Book: Creating Universes with SAP BusinessObjects (ISBN: 978-1782170907 )

Book: Learning SAP BusinessObjects Dashboards (ISBN: 978-1785286629 )

Article: Creating Informative Desktop and Mobile Dashboards with SAP BusinessObjects Solutions (BIEXPERT)

Article: How to Solve Loops, Fan, and Chasm Traps in SAP BusinessObjects Universes (BIEXPERT)