Book Image

Mastering QlikView Data Visualization

By : Karl Pover
Book Image

Mastering QlikView Data Visualization

By: Karl Pover

Overview of this book

Just because you know how to swing a hammer doesn't mean you know how to build a house. Now that you've learned how to use QlikView, it's time to learn how to develop meaningful QlikView applications that deliver what your business users need. You will explore the requirements and the data from several business departments in order to deliver the most amazing analysis and data visualizations. In doing so, you will practice using advanced QlikView functions, chart object property options, and extensions to solve real-world challenges.
Table of Contents (18 chapters)
Mastering QlikView Data Visualization
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Rotation and average days


At a higher level, we analyze each element of working capital using the same methods. The overall objective is to know the average number of days that it takes for an item in stock to be sold, a customer to pay, or a supplier to be paid.

Note

As a business owner, I want to know how long it takes from the day I pay my supplier to the day the customers pay me so that I can work to free up cash and make investments to grow the company.

We can help free up cash for the business if we reduce the number of days that an item is in a warehouse or the number of days that a customer takes to pay an invoice. Inversely, we want to increase the number of days that we can wait to pay our suppliers without any penalty. Let's start our working capital analysis by calculating the average number of days that an item is in a warehouse. We call this key performance indicator Days Sales of Inventory (DSI).

Days Sales of Inventory

If we store inventory for too long, then it takes up space...