In this age of big data analytics, your collection of sophisticated desktop analytical data visualization tools can be forgotten. For all the power that big data warehouse solutions can provide, they’re not a complete replacement for all the departmental tools painstakingly custom-developed by your in-house Excel, Access, PowerPoint, and Data-Driven-Word-Doc gurus. There will always be a place for such precision tools. But those accumulated tools, and the data they use, can be difficult to fully utilize. That’s where a Hyperefficient DataMart comes in.

A Custom Datamart Solution
Consolidate and Empower
A custom-developed data analytics web application can centralize your many desktop analytical tools, and centralize the data they use, in one Hyperefficient Datamart. Store your many desktop analytical tools in central team directories of your own design, accessible to any authorized user with a browser. Access the data for them in the many ways possible in a web application. The same data pulled for say, an Excel Workbook, can be accessed via the List and Detail screens as shown in the dbRender Demo App. Multiple versions of this Excel workbook can be displayed on team screens that show version and document information, and enable collaboration on them. See some of the limitless collaboration feature possibilities at the bottom of this page.

For the desktop analytical tools, this system is a simplified alternative to the practice of sending multiple email attachments. For the data they report on, this system is an efficient storage solution enabling data to be rendered in multiple ways. As a web application, such a solution can combine the ground-level precision reporting needs of specific teams with the departmental and enterprise collaboration possible through the secure web.

This system can be thought of as the ultimate destination in data's epic journey on its way to a report: from disparate large proprietary source systems, to enterprise data warehouses, to more focused datamarts, to the final destination of the Hyperefficient Datamart.

Hyperefficient Storage
The Hyperefficient DataMart contains only the data called for in specifically developed data visualization tools. As an example, an Excel Workbook Model can be associated with a specific data query that would populate its “data tab” with continually updated data. That data—and ONLY that regularly queried data--would be stored in the Hyperefficient Datamart. As such queries are developed over time, they build a highly customized datamart. In the Hyperefficient DataMart, no excess data exists. By drawing from the infinite resources of your many enterprise data sources at query design time, and then storing only the final required data, the Hyperefficient DataMart stays compact and responsive.

A Full Web Application
As a custom developed web application, a Hyperefficient Datamart can be designed to your exact specifications. Instead of a random system of emailed attached documents, a customized application can centralize them and enable collaboration. The possible collaboration features are limitless in a custom-designed application:

• Store and Provide links to data tools in customized “private team websites”, using all the role and object assignment features available in a secure web application, as demonstrated on the dbRender Demo App.
• Create project collaboration pages containing links to project document versions, images from pages and areas of those documents, and a running text message thread beside them. A project manager can administer this page to make special versions of it accessible to authorized team members, and to eventual end users.
• Create “Infinite Desktops” for users to enable a custom set of data tool object links, organized by individual and project.
• Create new, completely web-based data visualization tools rendered in the web application itself.
• Design features of your own--this is custom development. Use the AppSpec page to submit your ideas.

A hyperefficient datamart can be thought of as a data warehouse created by the very data visualization tools that use it. Poorly targeted DataMarts have been disparaged as the place "where data goes to die." A laser-targeted Hyperefficient DataMart is a place where data goes to thrive.

Share your analytical requirements and ideas with Boulder Pass.