OSBI Technologies

Data Warehouse and Data Mart Technology

Databases
Open source database technology is now enterprise class. With features like clustering, partitioning, bitmap indexing and columnar storage engines, OS databases can be effectively used for data warehouses, data marts, and other analytical data structures.

The open MySQL and Postgres platforms have spawned a new generation of databases, like Infobright, Vertica and EnterpriseDB, that rely on their core technology. 

Accelerated development by the communities has made open source databases viable alternatives for companies that want the features of enterprise class technology at a fraction of the cost.

OpenBI has experience in both proprietary and open source database technologies, and the skills needed to make the most of your database investments.

Extract, Transform, and Load/Data Integration Technology
In the past, when  organizing and accessing data, you had two choices: build a series of complex, hard-to-maintain SQL programs, or spend hundreds of thousands of dollars on a proprietary ETL package.

Open Source ETL packages have made this thinking obsolete. OSETL offers advanced technology to access, integrate and organize data across hundreds of sources, and to deploy it anywhere you need it, all with an easy-to-use, graphical interface.

This new generation of data integration technology has been built from the ground up with open standards, allowing you to deploy data integration as traditional batch programs, or directly into websites to power real-time, dynamic reports.

OpenBI has spent decades solving data integration problems. We have the experience in OSETL technology to unleash your data, while keeping your infrastructure investments in check.

Dashboards
When executives need answers, but don’t want to invest in expensive technology to get them, turning to open source dashboard technology just makes sense. Open source dashboards offer the same features as proprietary technologies, like drill through on interactive charts and dials, while also enabling integration with existing websites.

OpenBI has built integrated dashboard applications with open source technologies for all levels of users, from executive to analyst. Let OpenBI help you turn your data into the tools users need to make decisions with advanced open source dashboarding technology.

Parameterized & Ad-Hoc Reporting
There are times when all that’s needed to inspire, is the data from a simple report, spreadsheet or web page. OpenBI works with all leading open source technologies to deliver your financial, operations, and sales data in easy to access reports.

Open Source reporting can be delivered to the people who need it via web sites and email in any number of popular document, spreadsheet, and HTML formats. Users can specify parameters, schedule the reports, and deliver them automatically or on demand. The power is in their hands.

OpenBI can help you take your data and reporting needs and distill them into a comprehensive reporting platform that uses advanced open source technology. The PDF with sales numbers produced from open source reporting, looks a lot like the PDF produced from proprietary technologies. Your users won’t know the difference. And they’ll appreciate you investing in their data needs, not in expensive proprietary software.

OLAP
When your users like to explore their data, open source OLAP technologies are the answer.  The advanced open source ROLAP engine supports all types of dimensional analysis, and maps directly to your relational database. The ROLAP engine caches each answer to keep response time lightning fast. And since it’s aggregate aware, and supports virtual cubes, you can give your users drillable OLAP access to data without breaking the bank on proprietary technologies.

Open Source OLAP technologies give users a web-based, interactive tool to drill and explore trends across time, person, division, office, or any other dimension in the data. They can drill up, down, and through data to find the answers they need. The OLAP engine can also power other open source components, including dashboards and reports.

OpenBI can get your data into shape and deploy OLAP analysis as part of a comprehensive reporting solution. If you’ve been constrained by long running queries and costly license fees, take a look at what OpenBI can do for you with open source OLAP technology.

Statistical Analysis
Reporting, OLAP and dashboarding often aren’t enough to find the trends and make the decisions you need. Fortunately, open source technology is. Currently considered the standard in higher education and other centers of learning, open source statistical technologies offer the latest analytic techniques without the significant up-front licensing costs of commercial alternatives,

OS stats showcase all techniques available in expensive proprietary technologies. Whether you’re looking at simple regressions, clustering, or advanced bootstrapping techniques, you’ll find that open source statistical analysis provides what you need. OpenBI has decades of experience in statistical analysis techniques. We can help you boost the power of your business intelligence environment in ways that weren’t possible just a few years ago. Open Source technology has changed the game for statisticians. Let us show you how it’s done.