Data Visualization Skill, MDS Program 1, MDS Program 2, MDS Program 3
Qlikview Data Visualization Base and Advanced Level
0( 0 REVIEWS )
0 STUDENTS
Instructors
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> |