Our data

So, in our organization, financial analysts must supply projections for values for forecasts on each product revenue, which is also broken down by retailer country, order method, and period.

In Planning Analytics, there is a multi-dimensional cube defined with the following dimensionality:

Using the extract, transform, and load (ETL) tool that is native to Planning Analytics ( known as TurboIntegrator), product performance information such as quantities sold and revenue is automatically loaded on a schedule from the organization's general ledger system into the Planning Analytics cube at the end of each and every business day.

Analysts use Excel-based linked worksheets to view product performance information or can use the Planning Analytics Cube Viewer to view detailed information for the products they own or are responsible for creating a forecast for:

The Planning Analytics cube is memory-based, and so an analyst can slice and dice the data in any number of ways and the numbers will be recalculated and/or consolidated in real-time, helping the analyst better understand the results. The preceding data view is Revenue and Quantity for the United States, All Methods, All Product Types, and All Products, but broken down by Product Line, across periods (at the quarter level).

Another view—or sliceof the data may be Revenue, year-over-year by Retailer Country:

Another useful feature provided by Planning Analytics is its ability to dynamically chart most of the views you create using data in the Planning Analytics cube, by using the cube viewer:

 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.30.62