Book Image

Qlikview for Finance

Book Image

Qlikview for Finance

Overview of this book

This book is an effective step-by-step tutoring guide for financial analysis using Qlikview. It begins by teaching you the crucial concepts of Qlikview Finance to help you develop an effective understanding of financial data analysis and finance. The book then goes on to cover real-world, practical examples on the use of Qlikview for financial planning and analysis, expense management, risk management, and more. Moving on, topics such as Asset Management QlikView Dashboard and Retail Sales Analysis are covered in a strategic way. We then shift the focus to deal with the concepts of Inventory, Supply Chain, and Plant Coverage Dashboards. The book then reaches its conclusion by dealing with ways to share your QlikView insights. By the end of this book, you will have a good understanding of how to use Qlikview for numerous applications in finance.
Table of Contents (18 chapters)
QlikView for Finance
Credits
Disclaimer
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

The good and bad of the Inventory tab


In the left-hand side upper-horizontal bar chart that we have been looking at, we can see Inventory Turns in orange and the total Value of the stock in blue. We also have a vertical bar to establish an average inventory value that we would like to maintain. At least, we assume that is what the bar represents since it is the same color as the horizontal Value bar and since it has the Target label next to it in the same color. Unfortunately, to see all the product lines, we need to use a scrollbar. Perhaps we should either forego the bottom row to add room to display everything, or group our product lines into a few high-level groups that can then be drilled down on for detail.

For example, if I use the bar graph, I can see Dairy, and it stands out because it has the fewest inventory turns. That seems very curious to me as I would expect dairy products to be perishable and require more inventory turns than Frozen Food, the row above Dairy. Also Dairy Products...