Call :+91 8055223360
Menu
Call :+91 8055223360
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.
Duration of Training: 6 weekends
There are no formal prerequisites for this course; however, previous operating system administration experience will be very beneficial.
What is QlikView?
How does QlikView differ from traditional BI?
Exploring data with QlikView
Navigating the document
Slicing and dicing your data
List-boxes
Selections in charts
Search
Bookmarking selections
Undoing selections
Cyclic Groups
Drill down Groups
Containers
The technology and components behind QlikView and the way the data flows
Reload, publish, and distribute content 25
Project
What is a SiB?
Preparing the workspace
Setting up the folder structure
Creating the QlikView document
Creating the app
Constructing the data model
What is a data model?
Loading the fact table
Playing with listboxes
Creating the dashboard tab
Creating and positioning the filters and user controls
One chart and multiple analyses with cyclic expressions
Adding a time drill-down group
Data Sources
Accessing custom data sources
Third-party custom connectors
Reading table files
Extracting data
Creating the OLE DB connection string
Querying the database
Reloading the script
The transformation
Refining the input table
QVD and QVX files
QVD files
QVX files
Loading an Inline table
Data Modeling
Dimensional data modeling
Relational databases and ER modeling
Dimensional modeling
The star schema
The snowflake schema
Creating the dimensional model
Dimensional models in QlikView
The associative data model
How associations are created
Avoiding data model conflicts
Table information
Field information
Table preview
Table viewer menu
Styling Up
Design requirements
The Document Properties window
The Sheet Properties dialog
Setting the object properties
Caption colors and style
Changing the caption colors
Setting the caption font
Setting the content font
Setting the global font
Propagating the object appearance
Setting the default Sheet Object Style
Hiding captions
Working with listboxes
Adding listboxes
The Expressions tab
The Sort tab
The Presentation tab
The Number tab
The Font tab
The Layout tab
The Caption tab
The Multi Box
The Current Selections Box
Adding a Bookmark Object
Aligning and resizing sheet objects
Selecting objects
Moving objects
Aligning sheet objects
Defining chart colors
Setting the default color map
Building Dashboards
Expressions and the Edit Expression window
The Edit Expression window
Auto minimize 200
The Report Editor window
Other charts
Radar Chart
Mekko Chart
Grid Chart
Funnel Chart
Block Chart
Trellis Chart
Course completion certificate and Global Certifications are part of our all Master Program
Course completion certificate and Global Certifications are part of our all Master Program
Radical Technologies is truly progressing and offer best possible services. And recognition towards Radical Technologies is increasing steeply as the demand is growing rapidly.
Radical Technologies is a recognized leader in training of Administrative and Soft ware Development courses since 1995 to empower IT individuals with competitive advantage of exploiting untapped jobs in IT sector
