Читать книгу QlikView Your Business - Troyansky Oleg - Страница 12

To lead an organization that can answer the questions about what happened, why it happened, and what it means to the business, you need measures of results and measures of drivers of results. QlikView allows you to get at the data to do this. The data elements required to analyze your sales in ways that we have discussed are:

● Invoice information at the line level, including units and amounts

● List price information by product and by customer

● Invoice or line discounts (discounts used to get from list price to invoice) by customer or channel

● Customer master information

● Customer grouping designation (usually by channel or class of trade)

● Product master information

● Product classification (brands, categories, styles, and so on)

● Sales person information and sales hierarchy

● Date dimension, if available, including fiscal calendar data

These data elements can involve data from invoice tables, as well as product and customer master tables. Some information may need to be integrated from spreadsheets.

If your company is managing sales on multiple systems (typically a result of a recent merger or acquisition), you might need to merge data from multiple systems and map the master data from one system to another.