Data warehouse module

TRAQ Manager offers an extensive data warehouse that can store and organize years of orders, production history, inventory, shipping and transportation information. The data warehouse is used for sophisticated online analytical system (OLAP) that processes queries required to discover sales or quality trends and analyze critical factors such as transportation and manufacturing costs.

Data cubes and interactive reports let you explore historical data such as sales by region, by representative and customer group, transportation rates and manufacturing losses.

The key business benefits of TRAQ Manager analytical reporting, based on SQL Server Analysis Services, include:

• Increased speed and quality of decision-making
• Streamlined data analysis that shortens reporting cycles and saves resources
• Increased reporting flexibility through rich, highly customized, and refreshable reports
• Consistency of information and "drill through" capabilities.

Integration of TRAQ Manager data warehouse with Microsoft Office enables users to analyze data and to create rich, customized reports directly in Microsoft Office Excel.

Related Information:

   All Spec Sheets in PDF format (926K)