Qlikview Training and Certification Course In Pune

• 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

Download Curriculum

• 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

Download Curriculum

• 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

Download Curriculum

• 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

Download Curriculum

• 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

Download Curriculum

• 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
• Hands on project, interview preparation

Download Curriculum