Edureka's Qlikview course is specifically made for professionals who want to learn to use Qlikview for business intelligence and to bring visual insights to the data. This course covers all the concepts of Qlikview tools like Data Interpretation, Designing, Modeling and then dives into advance features of Qlikview like Analyzying the data, Discovering the hidden data and generating attractive graphs and charts.
At the end of the course the participants should be able to:
1. Apply various visualization and modeling techniques
2. Implement Qlikview features like In-memory, Associate and Decision-making
3. Perform Data Analysis
4. Access the multiple charts / tables / objects for Dashboard analysis
5. Work on a real life Project, implementing data into image for Dashboard
Content for Script-Modeling and Security will be given as complimentary self paced videos.
Towards the end of the Course, you will be working on a live project where you will be using Retail & Banking Dataset to perform various data analytics.
Project #1: Sales Analysis
Data: Excel File/Oracle/Sql Server.
Problem Statement: Creation of Dashboard via multiple data source using Qlikview.
Project #2: Creation of Dashboard for Customer analysis
Data: Excel File/Oracle/Sql Server.
Problem Statement: Analyzing customer data using Qlikview.
Edureka is a live and interactive e-learning platform that is revolutionizing professional online education. Edureka offers instructor-led courses supported by online resources, along with 24/7 on-demand support. It gives professionals the flexibility to learn at their own time and location, even from their mobile devices. Edureka also provides real-life project scenarios designed and evaluated by industry experts. With its innovative course delivery backed by industry-renowned practitioners, Edureka has helped more than 250,000 professionals upgrade their skills across 80+ specially designed courses. From its inception in 2011, more than 50,000 hours of classes have been delivered on the Edureka platform. Professionals and practitioners from more than 150 countries constantly engage on the Edureka platform and each Edureka course is tailored to address industry challenges, domain changes and latest trends. Edureka is committed to arming professional learners with the right resources to excel in their careers. With a customer-first approach, Edureka focuses on the long term career aspirations of learners and safeguards them against technology changes. The Edureka family prioritizes learners’ career growth above all else, and a flat hierarchy ensures healthy collaboration with transparency and positivity. Edureka offers courses in the areas of Big Data, Programming, Professional Certifications and Marketing.
1. Qlikview Starter
Learning Objectives - In this module, you will get an introduction to Qlikview and the other associated components.
Topics - Introduction to Qlikview, What is Visualization, Components of Qlikview, Create Connection, Create Dashboard Report, Report Interface, Sheet Object-List BOX.
2. Script - Code
Learning Objectives - In this module, you will learn to edit the script and you will understand the working of the different tools to edit the scripts.
Topics - Script Editing, Edit Script Toolbar, Edit Script Menu Commands, Statements Area, Edit Script Tool Pane, Syntax, Creating tabs in the script, Renaming a Field, Chart Object- Bar Chart, Sheet Object- TABLE Box.
3. Script - Relation
Learning Objectives - In this module, you will learn about Tables, Join, its types and uses.
Topics - The Table Viewer, System Fields, The System Table, Join, Keep, Concatenation, Types of Join, Keep and Concatenation, When to use, Which Type, Chart Object-Line Chart, Sheet Object-Multi Box.
4. Script - Loop & Field Handle
Learning Objectives - In this, module you will learn to use the Synthetic Key tables and the ways to resolve the synthetic keys and circular reference.
Topics - Synthetic Key Tables, Circular References, Causes of Circular References, Ways to Resolve Synthetic Keys and Circular Reference, Text Files, Excel Files, CSV Files, Others, Chart Object- Combo Chart Sheet Object- Input Box.
5. Script - Load Type & System Table
Learning Objectives - In this module, you will learn to generate the data in Qlikview script, cross tables, mapping tables and various other concepts.
Topics - Generating Data in the Qlikview Script, Cross Tables, Mapping Tables, Different Types of Loads, Chart Object - Pie Chart, Sheet Object - Buttons, Sheet Object - Current Selections Box.
6. Script - Incremental Load & Files
Learning Objectives - In this module, you will learn about data file types, incremental load, Calendar creation and types of sheet objects.
Topics - Qlikview Data Files Types, Incremental load, Incremental load with qvd file, Creating a Calendar, Sheet Object - Radar Chart, Sheet Object - Scatter Chart, Sheet Object - Text Box.
7. Object/Field Formatting
Learning Objectives - In this module, you will learn to perform Object / Field formatting.
Topics - Number Format, Aggregation & Nested level, Calculated Formula, Field Groups, Sheet Object - Grid Chart, Sheet Object - Block Chart, Sheet Object - line/arrow.
8. Data Analysis
Learning Objectives - In this module you will learn to perform Data Analysis like Set, Indirect, and What-If analysis.
Topics - Set Analysis, Indirect Set Analysis, What-if Analysis, Set vs Let, Sheet Object-Mekko Chart, Sheet Object - Gauge Chart, Sheet Object - Slider/Calendar Box.
The course is designed for professionals who want to learn Dashboard techniques by using Qlikview. The following professionals can go for this course:
1. Analytics Professionals
2. BI /ETL/DW Professionals
3. Project Managers
4. Testing Professionals
5. Business and Reporting professionals
6. Software Developers and Architects
7. Graduates aiming to build a career in Visualization & Analysis
Pre-requisites for this Course:
There are no such pre-requisites for this course, but if you have some knowledge of file type, SQL, DWH, RDBMS then it will be beneficial.
- Hours 24
- Online Query Support
- Online Tests
- Telephonic Query Support
- Video Classes
- Study Content
- Class Hand Outs