AB Data

The same company performance indicator can be calculated in several ways. For example, to calculate revenue, you can take paid invoices from CRM or a bank statement in 1C. Or you can supplement them with other data from 1C: for example, data on profit or accounts receivable and accounts payable. What information from this volume of data should be taken for the BI system - all available or some specific information?

Solution: formulate the question correctly
To determine the data, you first need to understand what kind of decision needs to be made.

For example, a manager needs to regularly make nepal telegram database decisions on the timing of raw material purchases. At first glance, this requires information on warehouse balances. You can set up data downloads from ERP - this will be enough for analytics.

But if you ask additional questions, for example, why is it necessary to make a decision right now, what will the answer be influencing, it turns out that the results will determine whether the manager will attract borrowed funds to purchase raw materials right now or postpone the purchase until the budget is replenished.

Then the correct request to analytics is not just “to understand how much raw material is left in the warehouse,” but “to clarify the amount of raw materials in order to make a decision on attracting credit funds.” And to make this decision, specific data is needed:

availability of resources in the warehouse and warehouse capacity;
resource consumption over a given period of time;
data on expected consumption volumes based on production plans;
market prices for raw materials;
quantity of finished goods stock.
The right question affects the selection of data and the systems that contain that data. And this may lead to the next problem.