Course Overview
QlikView enables users to gain unexpected business insights by understanding how data is associated and what data is not related. Users can conduct direct and indirect searches across all data points anywhere in the visualization whether globally or within a single field. QlikView lets you rapidly develop and deliver interactive guided analytics applications and dashboards.
QlikView is powered by in-memory computing technology. It is extremely fast and efficient thanks to its being able to overcome the limitations of the traditional disk and query-based BI tools. With QlikView, you dont need to use multiple dashboards, reports, and analysis as it takes a consolidated approach.
Course Modules
You will learn :
- Introduction to Business Intelligence (BI)
- What is Business Intelligence (BI)
- Features of Business Intelligence (BI)
- Traditional Business Intelligence(BI)
- Introduction
- Features of QlikView
- Pros and cons of QlikView
- QlikView navigation
- Concept of Association in QlikView
- Concept of Facts and Dimension
- Fact table and Dimension table
- Schemas
- Star Schema
- Snowflake Schema
- Installation of Qlikview
- How to start the QlikView (QV)
- Script Edit ( Cntrl +E)
- Reload (Cntrl +R)
- Loading Data from files
- Creation of QVD file
- Load and Store of QVD file in QlikView(QV)
- Purpose
- Create QVD files
- Reading Data from QVD files H
- How to use joins in QlikView(QV)
- Left, Right, Inner, Outer
- What is DSN
- How to create the DSN
- ODBC and OLEDB
- Loading Data from Database
- Loading Data from QVDs
- What is staging
- What is Folder Structure
- Why it is necessary
- Standard folder Structure
- What is Object
- Types of Objects
- Properties of Objects
- Discussion on List Box object
- Discussion on Statstics Box object
- Discussion on Multi Box object
- Discussion on Current Selection Box Object
- Input Box Object
- Button Text Object
- Line/Arrow
- Slider/ Calendar
- Bookmark Object
- Search Object
- Container Object
- Introdcution Chart Properties
- Bar Chart
- Line Chart
- Combo Chart
- Raddar Chart
- Scatter Chart
- Grid Chart
- Pie Chart
- Funnel Chart
- Block Chart
- Gauge Char
- Pivot Table
- Straight Table
- Look up different QlikView Applications
- Dashboard
- What is Synthetic Key
- How the Synthetic Key generated
- How to remove the Sythetic Key
- What is Circuler Reference
- How to remove Circuler Reference
- SET and LET statement
- Table Viewer
- Calendar Creation
- Purpose of Calendar
- Date and Time function
- Concept of Autogenerate() function
- What is Variable
- Why it is uses
- Variable declaration
- Conditional Expression
- If …….Else statement
- Nested If …….Else statement
- Set Analysis
- Use of Set Analysis Syntax
- Direct Set and Indirect Set
- Apply map
- Keep
- Wild match
- Exists
- Incremental Load Concept
- Introduction to Incrmental Load
- Use of Incremental Load
- Insert only
- Insert update
- Insert Update and Delete
FAQ
Any graduate, fresher, experienced and looking to start or change their career into data analytics can attend. No prior experience is mandatory.
Absolutely. We start the training from scratch. After completing the course you will not feel that you have never programmed.
Yes
Our trainers are from the industry. Every class is followed by real time assignments which will make you feel confident when you get into a job.
Fully online. You can attend from anywhere. You just need a laptop and a good internet connection
Yes 100%. It is live and fully interactive. We dont believe in running through power point presentations.
Please contact on the given number.
Contact Us
+91 70198 30464 / +91 79911 97543
Enroll / Enquire
Address : Saroj Iris, No. 106 (Wing A), Gunjur, Varthur Hobli, Bangalore - 560087
Phone : +91 70198 30464 / +91 79911 97543
Email :
info@dakshahanalyticsacademy.com, dakshahanalyticsacademy@gmail.com