datapine product overview
datapine is an all-in-one business intelligence platform designed for businesses of all sizes and all industries. Its comprehensive self-service analytics approach enables data analysts as well as non-technical business users to merge, analyze, visualize, and share data. The software is made to support all-important business departments such as finance, marketing, sales, human resources, customer service, procurement, or IT.
This SaaS BI solution helps companies to unify all their business data into one central point of access in order to perform cross-data source analysis and make data-driven business decisions anytime and anywhere. Additionally, datapine offers customized on-premises solutions.
Data connectors for all common data sources (databases, flat files, marketing analytics, social media, ERP-, CRM- and helpdesk systems, etc.) guarantee smooth data integration. An intuitive drag & drop interface allows users to analyze and visualize complex data sets and take advantage of a wealth of analytics features such as trend indicators, conditional formatting, AI-based data alerts, or predictions. Dynamic, interactive business dashboards’ important key performance indicators (KPIs) can be organized and tracked in real-time, which enables everyone within the company to answer important business questions immediately. Interactive dashboard features such as drill-downs, chart-zooms, click-to-filter, hierarchical filter, or time interval widgets give decision-makers the flexibility they need to view business data from different angles. Finally, datapine offers multiple ways to share generated insights with professional dashboard reports, including among others, automated Email reports, live dashboards, manual exports, and secure viewer areas as well as embedded dashboards.
Pros of datapine
- Interactive dashboards
- Comprehensive self-service analytics approach
- Intuitive drag-and-drop interface
Cons of datapine
- No natural language processing
- No support for the automatic integration and analysis of unstructured data
- Some of the advanced features may require knowledge of SQL
Breakdown of core features
All common data sources such as databases, flat files, marketing, and social media data as well as CRM-, ERP- and helpdesk data can be connected with a few clicks. Connect remotely or transfer the data into datapine’s high speed, in-memory data warehouse, which enables users to manage large amounts of data and boost querying speed by sparing IT resources. For technical users, datapine offers advanced connection options such as a secure connection to a user’s database using an SSH tunnel, the possibility to define foreign keys, or take advantage of a customized SQL View.
With the help of an intuitive drag & drop user interface, even non-technical business users can analyze and visualize complex data sets. datapine’s easy-to-use analyzer offers multiple advanced analytics options, including among others, combining different chart types, conditional formatting, calculated fields, intelligent data alerts, predictive analytics tools, comparisons to previous periods, as well as custom chart tooltips. Users can choose from over 15 different chart types such as gauge, map, (stacked) column or bar, area, as well as bubble charts. More technical users knowing SQL can switch to an SQL mode, where they can manually write queries on their own or use already existing statements or scripts directly in datapine.
Dashboards & Reports
One of the core functions of datapine is the innovative, interactive business dashboards. These enable businesses to gain a consistent view of important KPIs, track performance in real-time, and enhance the overall decision-making within the whole company. datapine’s dashboard platform offers dashboard templates, global style options, text-, image-, and icon features, sophisticated global dashboard filter, 24/7/365 cross-device accessibility (big screens, desktop/laptop, tablet, and mobile), interactive dashboard features (drill-downs, chart-zooms, click-to-filter, hierarchical filter, time interval widgets, etc.), dashboard tabs, rotations and animation options, intelligent data alerts, as well as multiple sharing options (automated Email reports, live dashboards, manual exports, secure viewer areas, and embedded dashboards).
datapine offers an intelligent alert system to automatically track the most important KPIs with the help of artificial intelligence and machine learning. This allows companies to stay on top of metrics’ performance and reach goals per automatic notifications whenever something unexpected is happening, or a goal isn’t reached. Users can set up alerts with a few clicks for a selected KPI and can choose from 3 different alert types: neural network, pattern recognition, and threshold alerts. The neural network alert is based on an artificial intelligence algorithm using advanced neural networks for anomaly detection. The pattern recognition alert is a machine-learning algorithm using historical data and patterns to predict future values. For these two intelligent alert types, users can adjust the sensitivity as well as in which time frame and at which concrete time the data should be checked. If an alert is triggered, they automatically receive a notification email and get detailed information such as the deviation from the expected value, alert accuracy, degree of seasonality as well as an overview of the last 30 days. Finally, the threshold alert is a simple way to define manually absolute or relative values for a KPI to get notified, when this pre-defined value was hit.
(Last updated on 01/29/2020 by Pam Van Loon)