QlikView Training

LIVE

45 Hours

Course offered by Vara Prasad G

0 review

QlikView is a leading Business Discovery Platform. It is very powerful in visually analyzing
the relationships between data. It does in-memory data processing and stores the data in
the report itself that it creates. It can read data from numerous sources including files and
relational databases.
It is used by businesses to get deeper insight by doing advanced analytics on the data
they have. It even does data integration by combining data from various sources into one
QlikView analysis document. QlikView is a leading Business Intelligence and Analytics
Platform in Gartner Magic Quadrant.

Qlikview is different from another Business Intelligence tools.

It has a inmemory, automatic association and clever compression data.

Generally Qlikview loads tables from different types of data sources like oracle server, SQL server, Salesforce, SAP, Hive Database and etc.

We can load excel files, CSV files and etc through table files.

Qlikview 3 tier architecure is having 3 layers, they are Data layer, Business Layer and Presentation Layer.

We are fetching all source files from different types of data sources as mentioned above in Data layer and convert source files into QVDs by using store command.

Load necessary QVDs from Data Layer to Business Layer and do the transforamtion as per business logice and business requirements.

Load QVW file into presentation layer by using Bianry statement which have been created in business layer and built necessary charts as per KPIs.

About the Trainer

Avg Rating

0 Reviews

3 Students

2 Courses

Vara Prasad G

M Tech

8 Years of Experience

• Total 8.2 years of work experience and relevantly 6.6 years of experience as a QlikView Professional in designing, development, reporting and understanding the customer's business requirements.
• Good knowledge on different analytical applications using QlikView suite of products (QlikView Server, Publisher and QlikView Enterprise).
• Experience on importing data from multiple data sources and delivered reports, common dashboards, metadata, security, calculation, caching and intelligent request generation services.
• As per client requirement, loading data from multiple data sources like Oracle SQL, MS Access, QVD files, Text files, Excel by making connection through ODBC, OLEDB.
• Good experience in development, design, maintaining dashboards and BI applications using QlikView.
• Knowledge in developing data modeling, front end and BI reports in QlikView by preparing the test plans & cases.
• Experience in designing QlikView document, user setting and layouts to make consistent and professional optimized look to clients.
• Performed different types of loads such as incremental load, binary load, resident load and partial reload.
• Implemented alternative states and What-if analysis to provide custom functionality in QlikView Applications and hands-on experience on Set Analysis and Link Table.
• Strong experience in Data Warehousing concepts - Star Schema, Snow Flake Schema and Data Modeling (Normalization/De Normalization) Dimension tables and Fact tables.
• Good knowledge on design & developed QlikView dashboards using various QlikView objects
• Created many charts and analyzed that include Bar Chart, Line Chart, Pie Chart, Combo Chart,
• Scatter Chart, Grid Chart, Radar Chart, Gauge Chart, Block Chart, Funnel Chart, Mekko Chart
• Created many boxes that include List Box, Statistics Box, Multi box, Input Box, Current Selection Box during dashboard creation and familiar with box properties.
• Created objects like Text Object, Line/Arrow Object, Slider/Calendar object, Bookmark Object, Search Object, Button, Linked Object, Container and familiar with object properties.
• Used groups such as performed Drill Down and Cyclic.
• Strong knowledge on Joins and Concatenation to avoid synthetic keys and circular references.
• Used statements such as INLINE, RESIDENT, JOIN, KEEP and CONCATENATE to manipulate tables.
• Familiar with document properties such as General, Dimensions, Dimension Limits, Expressions, Sort, Presentation, Style, Number, Font, Layout, Caption, Variables.
• Performed Hidden Script concept for Security, Reduction in Data, things to make data reduction work.
• Created Master Calendar in data modeling involves dealing with dates and times.
• Used many functions like DATE, PEEK, Month Start, Auto Number Hash 256, Quarter, Ceil, Floor, Aggregate function, Interval Match and Mapping function.
• Creating QlikView application/reports and deploying on QlikView Server.
• Having knowledge on visualization and performance tuning.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.