HRDF Course-Basic Qlikview Data Analytics Training

QlikView is a Business Intelligence (BI) data discovery product for creating guided analytics applications and dashboards tailor-made for business challenge. QlikView is the one of the most flexible Business Intelligence platform for turning data into knowledge It allows you to Import your own data and drivefaster response to changing business requirements, shorter time to value and greater insight

This course will use QlikView Personal Edition for the training. QlikView Personal Edition is free and it runs without license key. Once you decide to do more with Qlikview, you can always upgrade to the licensed version later... The topics include:

• Qlikview Interface
• Connect to Data Sources such as CSV or XLS files
• Data Visualisation
• Pivot Table

Module 1. Get Started with QlikView

• What is Qlikview?
• Download and Install Qlikview Personal Edition
• Exploring Qlikview Interface
• Setting User Perference

Module 2. Data Sources

• Connect to Data Sources
• Upload CSV file
• Upload Excel file

Module 3. Data Visualization

• Sorting and Filtering Data
• Create Charts
• Review Statistics

Module 4.Sheet and FIles

• Managing Sheets
• Managing Files

Module 5. Pivot Table

• Create Pivot Table
• Filter Pivot Table
• Format Pivot Table

Dr. Aanand is a Full Stack Data Scientist who once had a torrid love affair with Physics. He has consulted and published in the area of Public Health, Electricity Markets, Telecom, BFSI, Advertising & Communication Strategies and Digital & Social Media Technologies. He has worked on assignments with international agencies such as International Monetary Fund, World Bank, Royal Netherland Embassy etc. besides MNCs like Tata Consultancy Services, Kie Square Consulting and several government organizations of national importance.

He regularly conducts general training programs in Python (Pandas, NumPy, SciPy, Matplotlib, Bokeh), R (dplyr, rstanarm, knitR, ggplot2), Data Visualization (Tableau, D3.js) and Machine Learning (Reinforced Learning, Scikit Learn) and specialized training programs on Structural Equation Modeling and SAP Hana.

He holds a doctorate in Operations Research from Indian Institute of Management Ahmedabad and a post graduate in Physics from University of Mumbai. He has advanced training in mathematical programming including optimization, advanced multivariate data analysis, and simulation techniques. When he is not teaching or consulting he can be found meditating or heading for an adventurous trek.