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