QlikView for Finance Professionals

Theme

Key Topics

Introduction

When do we use, Downloading and installing, Loading data from Excel, How QlikView works, Adding more data, Loading more than one spreadsheet

QlikView Dashboard

Key performance indicators, Sales as a KPI, Adding ROI, ROA, and ROE, Expression shortcuts, Mathematical and set operators, Common size income statement, KPIs in the Financial Officer QlikView Dashboard

QlikView Asset Management

Assets under management, Fixed asset management, Adding data sources, Loading from files, Loading from databases

QlikView Sales Analysis

Sales analysis tab, Sales analysis dashboard, Improving the sales analysis dashboard

Forecasting and Trends

Trend and forecast lines, Monthly sales and margin chart, Extending a trend line, Trending dashboard, What If? Dashboard

Inventory Analysis

Four-quadrant layout, Inventory turnover, Inventory dashboard, Pivot table

Order Details

Analyzing the order details dashboard, CFO dashboard order detail tab, Export to Excel

Expenses Dashboard

Minimizing the pie chart, Improving the line chart, Bar chart formulas, Pivot table variances

Faculty profile

FEES for Corporates

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared.