For clients who don't have tools in place, our consultants can refer you to a variety of sources to achieve your reporting objectives. CornerStar also offers a turnkey solution already incorporating pre-bundled reporting tools.
In contrast, a Data Mart is focused on a single line of business providing the opportunity for a company to build their Data Warehouse in stages as needed. ROI is rapid and a strong foundation is provided for future expansion. Additionally, since a Data Mart relates to a single area, its features are highly focused on the needs of that department. For example, the CornerStar Sales Mart allows for complete views of sales data including shipments, bookings, backlog, forecasts, quotas and revenue adjustments; consolidated world-wide views of sales; unlimited hierarchies for products, customer and salesperson related fields; historical and current view of dimension data like product line and customer type generally associated with detailed sales transactions.
Yes. Our Data Model supports up to 5 financial budgets in any given year. We have utilities available to load budgets to our Financial API which in-turn sends them to the Financial Data Mart. Many clients use an Excel front-end for budget entry. Using the Cognos/Excel add-in, you can provide managers with last-year's actuals to aid in creating this year's plan. Another option would be to provide a custom front end for users to enter budgets. CornerStar consultants have the expertise to help with this, including creating a browser based front-end for use over the company’s intranet.
Data Warehouse reduces reporting errors. Data Warehouse enforces a level of discipline that encourages clean and consistent data. Hours of analysis into the way your company does business occurs every time you write even the simplest report directly against your source system. Multiply this by the number of users and reports generated, and you may find that you are pulling the same information several times, sometimes incorrectly and often inconsistently. With a Data Warehouse the difficult analysis has been funneled through the transformation process. Report writing becomes easier and less time-consuming.
Data Warehouse is designed for reporting. Most OLTP systems are designed for very specific business functions like creating sales orders or releasing batches of work orders—not for reporting.
A Data Warehouse, on the other hand, is designed specifically for business users to retrieve and analyze large sets of records quickly and easily. The CornerStar model uses descriptive field names like “sold_to_region”. In other words, language that is meaningful and relevant to the user. In addition, CornerStar provides detail data as well as several levels of summarization and pre-calculated values. This makes it easy for non-technical personnel to perform their own ad-hoc queries without the need to create cross-tab reports.
Data Warehouse can consolidate data from multiple source systems. This is a difficult task with most reporting tools. The CornerStar Data Warehouse is designed to consolidate multiple databases into one place to provide a foundation for worldwide reporting.
Data Warehouse can capture historical data that would otherwise be “lost” from your source system. Master file data such as the ship-to address, or customer type can change in your source system and sometimes is not retained in historical files. A CornerStar Data Warehouse provides views to your data using both the current and historical attributes. Also, snapshot type data like sales order backlog or open purchase orders can be captured and trended by our Data Warehouse.
Business Intelligence is the process of analyzing meaningful information in order to answer questions about a business. Information Systems known as online analytical processing (OLAP) tools help managers and analysts identify trends, patterns and anomalies in their business' data.
The trick is knowing which questions to ask. At CornerStar we believe there are "sweet spots" of quality information within every business that when paid attention to, can result in significant improvement in the company's bottom line. Rather than giving managers all of the information, which would be overwhelming, Business Intelligence provides certain meaningful Key Performance Indicators (KPIs) organized around dimensions that are most meaningful to the company (product lines, customer geography).