Business Intelligence - Make Better Decisions

Your Business Problems - Our Solutions

Every customer is unique with varying operating environments. However, there are are similar needs and problems which the right Business Intelligence solution can solve.

Below, we've listed some of the most common issues customers face and how we can help you not only solve your problems, but provide you a path forward from data collection and free from analysis to web friendly distribution and download.

 

Integrating data from multiple sources

Your Problem: You have several data sources and locations using various platforms and formats. Integrating multiple data streams is crucial to getting a unified view of your business. However, integrating data and applications throughout the enterprise and presenting them in a unified view can be a complex and lengthy proposition.

Our Solution: Whether your data resides in SQL tables, flat files, spreadsheets or proprietary vendor formats, DI’s Data Integrator can access, verify, and transform these sources. The Data Integrator is a robust Extraction, Transformation, and Loading (ETL) tool that accepts input from virtually any data source and combines them. The Data Integrator contains a large suite of powerful data manipulation functions including joins, table lookups, and filters.

 

BI is Too Expensive

Your Problem: You are paying high maintenance fees to your existing BI vendor. Or, you have dropped BI projects because of the often high costs of deploying databases, data warehouses and additional specialists.

Our Solution: Often we can provide more functionality for a lesser cost without a database and data warehouses. Talk to us, we'd be happy to replace some of our competitors licenses for ours! Moreover, we don't require expensive data base licenses or third party vendors so typically we are less than half what you will pay for the large BI vendors including implementation.

 

BI is Too Complex

Your Problem: Too often, traditional BI solutions require deploying database(s), data warehouses, specialized data marts, and/or memory heavy servers. You want better business analysis, not an entire new IT infrastructure.

Our Solution: With 20 years of experience, Dimensional Insight provides a powerful yet easy to master suite of tools and is architected to drive results, not IT expenditure. From a Visual Integrator to a easy to use web editor to securely and effortlessly publish reports and graphs, we provide tools that deliver results.

 

You have a Multi-terabyte Data Warehouse and its taking too long to extract data for new projects

Your Problem: Data warehouses are now in the terabytes, making it a challenge to access timely and precise information. And your Data Warehouse is growing between 10% and 25% annually, making queries even slower.

Our Solution: Different users have different requirements and some may suggest building out data marts. Our solution is to build "models". For example, a sales analyst is provided a model which contains the data in a free form format so they can run their analysis and reporting independently from the Data Warehouse.

 

Excel Hell! (But some want to keep using Excel)

Your Problem: You are moving in the direction of deploying better reporting tools, but you have some users that won't give up their Excel tools.

Our Solution: Dimensional Insight provides an Excel plug-in solution called Cell Diver. Cell Diver accesses the same models that your BI users utilize so you provide a single source of data, but different users use their own preferred tool to report and analyze data.

 

Free Form Analysis

Your Problem: You already have a BI tool such as Cognos which is considered "reporting-centric" solution by Gartner. You need more free form analysis, not another structured solution that produces more structured reports.

Our Solution: From the beginning, the solution architecture was built around a "sphere" concept. The design of free form models allows a user to literally, "dive" into a data field and continue to dive in different directions into the data. This unique design truly provide free form analysis so you can uncover opportunities and discover risks before they discover you.

 

Multiple User Levels and Requirements

Your Problem: You have some users that want finished reports, some users who just want to see dashboards, others who want to analyze data in detail and publish their findings.

Our Solution: Dimensional Insight provides 3 levels of access: Advanced, General, and Casual. Advanced access is usually the IT administrator who manages the overall system and ensure security integrity. The General user are those power users that want to "dive" into the data free form and conduct analysis, create reports, and publish to files such as PDF or to a Web. Finally, the Casual user is the person who just wants to see updates, single click to download a report, chart or Excel spreadsheet.

 

Near Real Time Analysis - Scheduled Extraction

Your Problem: Your competitive advantage relies on near real time analysis of your operations. How can I get up to date data?

Our Solution: We have a Scheduler product which instructs the Integrator (ETL) to retrieve and update data for the users. This can be run nightly, hourly or even more frequent and you can program specifically what data is to be updated. Moreover, you don't have an entire database since we utilize models, you can select which models need more frequent updates.

 

Incorporating External Data

Your Problem: You want to incorporate externally retrieved data with your own internal data.

Our Solution: We have a Tunnel product which “tunnels” out and grabs data from external sources in real time. This data can then be incorporated via our Integrator (ETL) to update both internal AND external data for your end users.

 

Don't Have the BI Expertise, or Limited IT Staff

Your Problem: Many organizations want BI and fully understand the need for better reporting and analytical tools, but they don't have the time nor budget to put together a traditional BI Team of a data base administrator, ETL expert, data warehouse expert and a systems analyst to build reports.

Our Solution: The Dimensional Solution has been architected with customer feed back for over 20 years. The solution is designed for you to make fast progress while providing facilities for more advanced requirements when you're BI needs advance. Case in point, our Visual Integrator provides an easy to use interface, yet provide a code editor for those that want to do more detailed programming.

 

Want to Start Small

Your Problem: Many BI project never get approved simply because most of the current architectures require heavy infrastructure along with lots of in house expertise.

Our Solution: We can show you how we can meet your business objectives within a given budget and not simply just deliver software, but a working BI solution with customer reports which you can easily modify and expand on your own.


Copyright 2002 Inroads Limited Hong Kong