Qlikview Data Visualization Base and Advanced Level - Dvanalytics
dvanalytics whatsapp contact
dvanalytics whatsapp

Qlikview Data Visualization Base and Advanced Level

0 STUDENTS ENROLLED

    QlikView is a powerful tool in the field of business intelligence and analytics. It is an in-memory, business discovery tool. QlikView helps big and small organizations in data discovery and interactive dashboard preparation for decision support

    Course Curriculum

    Session 1
    Get familiar with QlikView environment 00:00:00
    • Qlikview software installation procedure
    • Qlikview interactive data architect and platforms
    • Qlikview windows navigations
    • Qlikview data source and connections
    • Get started with the main windows
    • Qlikview new sheet objects
      • List Box and properties
      • Statistics Box and properties
      • Multi Box and properties
      • Table Box and properties
      • Chart and properties
        • Bar Chart (Vbar and Hbar)
        • Lines Chart
        • Pie Chart
        • Combo Chart
        • Mekko Chart
        • Scatter Chart
        • Pivot Table
        • Straight Table
        • Gauge Chart
      • Input Box and properties
      • Current Selections Boxes and properties
      • Button
      • Text Object
      • Line/Arrow Object and Properties
      • Slinder/Calendar Object and properties
      • Bookmark Object and properties
      • Search Object and properties
      • Container and properties
      • Custom Objects
    Session 2
    QlikView data reading and scripting 00:00:00
    • Data Source
      • Importing data from flat file like .xlsx,.txt,.csv
      • Creating ODBC and OLE DB drivers
      • Extracting data from MS access
      • QVD and QVX files
    • Data Model
      • Dimensions and Measure
      • Associative data model
      • Star Schema
      • Synthetic Key
      • Circular Reference
    • Scripting
      • Create table using Inline
      • Importing data and scripting variable name with alias
      • Storing tables
      • Renaming tables and fields
      • Drop table
      • Deleting tables and fields
      • If nested if statement
      • Join statement
      • Keep statement
      • Concatenate and No Concatenate
      • Using mapping tables
    Session 3
    Qlikview advanced data manipulation technique and dashboard designing 00:00:00
    • Functions
      • String operators
      • String functions
      • Numeric functions
      • Datetime functions
    • Chapter9-Advanced Expression
      • Creating Variables using Set and Let
      • Using Variables in Expressions and Charts
      • Calling variables in objects
    • Chapter10-Conditional Functions
      • If function
      • Class function
      • Pick function
    Session 4
    Dashboard publishing and security 00:00:00
    • Security
      • Hidden Script
      • Section Access
        • Section access fields
        • Reduction fields
        • Initial data reduction
        • Omitting fields
      • Document Level Security
      • Sheet Level security