Previous  Next          Contents  Index  Navigation  Glossary  Library

Data Warehouse Uses

The following list provides just a few examples of applications for your data warehouse solution:

Business Analysis

You can analyze project performance and other details across various dimensions, such as projects and organizations. In addition, you can create variance reports to compare actual costs to budgeted amounts.

For example, you can create a graph that compares the actual costs for all projects by expenditure type for your company's organizations, as illustrated in the following figure.

Figure 1 - 55.

Using Sales Analyzer to compare actual costs for all projects by expenditure type

Forecasting

You can use historical profitability figures to estimate future revenue. Use estimated revenue figures in your budget planning and analysis.

Note: Oracle Project Analysis Collection Pack does not support this functionality directly. To perform forecasting, you must customize your implementation of Oracle Project Analysis Collection Pack.

Product Line Analysis

Monitor profitability and identify trends using project classes and categories to distinguish your different product lines.

Benefits of Multiple Dimensions

With multidimensional analysis capabilities, you can generate a variety of reports to view the information most important to your company. For example, you can perform the types of analysis listed below:

You can also combine different types of analysis in a single report. For example, you can search for values based on exception criteria and then generate a report that ranks the results, as illustrated in the following figures.

Figure 1 - 56.

Selector features of Oracle Sales Analyzer enable you to create and format ranking reports

You can use your analysis tool to search for expenditure types based on their total values and rank the top five results, as illustrated above.

Figure 1 - 57.

The resulting ranking report

The resulting report displays, in descending order, the expenditure types with the top five totals between $1000 and $200.

In addition, you can easily modify your analysis by changing one or more dimensions in your query. You can analyze your project information by selecting any of the standard dimensions available in a list of values (as illustrated in the following figure), or you can create your own.

Figure 1 - 58.

Use the Selector window to choose and organize the dimensions of your query

         Previous  Next          Contents  Index  Navigation  Glossary  Library