QLIKVIEW

Registration for : QLIKVIEW

Register Now

Share This Course

Class.1

  • 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

Class.2

  • 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

Class.3

  • 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

Class.4

  • Data Modeling
  • Dimensional data modeling
  • Relational databases and ER modelingDimensional 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 fontSetting the global font

Class.5

  • Propagating the object appearance
  • Setting the default Sheet Object Style
  • Hiding captions
  • Working with listboxesAdding 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 ma

Class.6

  • Building Dashboards
  • Expressions and the Edit Expression window
  • he 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

Registration for : QLIKVIEW

Register Now

Share This Course