Data Mash-Ups for Non-Tech Users

To glean true insights, you need to be able to take all of your data into account. With the Data Integration capability, you can unify all your disparate data and analyze it together for the complete picture. No more data preparation nightmares! The BI Office Data Modeler is a step-by-step wizard that guides you to easily access, input, and employ disparate data sources into one data model.

Watch the video

Small Data to BIG Data

You can input all your disparate data from data sources of various types and structures, from well-formed structured RDBMS data, to structured spreadsheets to Big Data sources, including: organizational databases like SQL Server, Oracle and DB2, Big Data and unstructured sources like Hadoop Hive and mongoDb; web-based CRM sources like Salesforce and Marketo; cloud applications like Zendesk and Google Analytics; social sources like Twitter; and other data read in via Excel, Access, Text file or R script. All without code, complexity, or desktop constraint. Click here to see the comprehensive list.

Cloud Mashup

Data Mash-ups in the Cloud

The Data Mashup is driven in the “cloud” – on servers – rather than on your desktop. So designing and running a data model built on a huge database is possible through your web browser without ever having to download the entire dataset first. The imported data is automatically updated so that there is only one version of truth, ensuring that everyone in your organization is working with the same numbers. Better yet, they can easily be scheduled to auto-refresh without you ever having to start up your laptop.

Cloud Mashup

Data Mashups that Almost Build Themselves

In the BI Office Data Modeler, you can easily create an integrated model using multiple, disparate data sources that can be analyzed in one report or query. The data sources can be joined in the Modeler manually, or via an inference engine based on heuristics, a capability that automatically offers decisions for data selections, metrics, relationships and hierarchies that you can tweak or change as needed. Once joined, the model presents the fused data source in the analytics interface for ad-hoc querying.

Watch the Demo
heuristic logic

List of Data Sources

SQl Server
EMC Greenplum
Hadoop Hive
Microsoft Azure SQL
Microsoft Azure Hive
Amazon Redshift
Google Analytics

Sign up for a free trial

See your own raw data turned into actionable insights

Pyramid Analytics Free Trial

Stay up-to-date with product announcements

Popup Content