Enquiry Now !      

Qlikview training Pune | Best Qlikview training institute in pune, Data warehouse, Qlikview

    DURATION OF TRAINING : 6 WEEKENDS

    Syllabus

    Week-1

    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

    Week-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

    Week-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

    Week-4

    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

    Week-5

    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

    Week-6

    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
qlickview


Enquiry Now !