Compare PivotData Microservice vs Periscope vs MicroStrategy

More Information More Information More Information

Crozscore:

73%
what is this?
28%
interest rising

Crozscore:

82%
what is this?
39%
interest rising

Crozscore:

88%
what is this?
86%
48%
no significant changes
PivotData Microservice screenshot view 1 more Periscope screenshot view 5 more MicroStrategy screenshot view 5 more

Software Description:

PivotData Microservice is a cross-platform on-premise .NET Core app that provides a web API for real-time data aggregation and generation of pivot tables and charts. This application may be hosted either on Windows or Linux.

Data sources are configured with JSON config which can be either a static config file or provided dynamically by main web app; microservice can be supported by a multi-tenant/SaaS usage scenario and each user could have its own customized data source configuration. The following connectors are available:

  • SQL: SQL Server, MySql, PostgreSQL, SQLite, ClickHouse, and any other DB with ODBC driver
  • MongoDB
  • ElasticSearch
  • Local CSV files

Web API generates reports by JSON report descriptions and can be used for both canned and custom (ad-hoc) interactive reporting. Pivot tables advanced options: percentages, differences, custom formatting & labels, TOP-N limits, server-side pagination, formula measures, report parameters for database-level filtering. In addition to HTML rendering, reports may be exported to PDF, CSV, Excel, and even Excel PivotTable.

Microservice is shipped with front-end components (javascript) for pivot table/chart web report builder; these widgets could be easily integrated with any web application for embedding self-service ad-hoc reports, pre-configured reports, or BI dashboards.

Software Description:

Periscope Data is a data analytics tool that consolidates business data from various sources, making the connection directly with databases. It brings all parameters to one place, providing users with a comprehensive view of business results.

Analysts are able to transform their SQL queries into interactive dashboards, graphs, and summaries for data consumers, remove workflow boundaries and improve data literacy in the organization. The system connects to databases via SSL JDBC, quickly and easily.

The Periscope Data Warehouse is built on Amazon Redshift, meets all business demands, and gives its users the power to eliminate repetitive manual work. Its analytics feature provides a visualized display, presenting data in more understandable format. All reports can be emailed immediately, while graphic displays can be embedded to user's website.

Software Description:

MicroStrategy is a BI and analytics software, providing its clients big data processing, actionable across various deployments and devices. It is available as web-based or on-premise platform, along with native mobile apps.

This software features interactive dashboard, monitoring company's assets, and finance operations, enabling them to analyze data and evaluate risks. It makes it easier for businesses to make significant business decisions.

The solution is based on drag-and-drop tools and intuitive interface. It connects to enterprise resources, such as databases, directories, or software.

Features:

  • Multi-User
  • Data Import
  • Dashboard
  • Analytics
  • API
  • Data Export
  • Data Visualization

Features:

  • 2-Factor Authentication
  • API
  • External Integrations
  • Forecasting
  • Scheduling
  • Notifications
  • Data Export
  • Data Import
  • Data Mining
  • Multi-User
  • Analytics
  • Dashboard
  • Data Visualization

Features:

  • Data Import
  • Data Export
  • API
  • External Integrations
  • Data Visualization
  • Forecasting
  • Analytics
  • Dashboard

Summary:

    No key features associated with this application.

Summary:

  • Templates

  • Collaboration

  • Data Cleansing

  • High Volume Processing

  • Data Mining

  • Analytics

  • Dashboard Creation

  • Filtered Views

  • Graphical User Interface

  • Data Visualization

Summary:

  • Advanced and predictive analytics.

  • Business intelligence.

  • Cloud-based.

  • Easy to use and maintain.

  • High-performance business intelligence.

  • Self-service analytics.

  • Big data solutions.

  • Software as a service (SaaS).

  • Real-time WYSIWYG report design.

  • Scorecards and dashboards.

FAQs:

    Who are the main user groups of this service?
  • Startups, SMBs, and medium-sized companies which already have web-based intranet/management apps and need to embed BI capabilities by their SQL or NoSQL database(s).

  • What is this service generally used for?
  • Live canned reports and dashboards, ad-hoc reporting, custom end-user reporting (self-service), and scheduled reports generation.

FAQs:

    Does this service offer guides, tutorials and or customer support?
  • Support: FAQs, Knowledge Base, Online Support, Phone Support, Video Tutorials, Community.

  • What is this service generally used for?
  • Periscope is used as a comprehensive data analysis platform.

  • What platforms does this service support?
  • This is a cloud-deployed software.

  • What are some applications this service is commonly used in tandem with?
  • Periscope is commonly used in tandem with Data Warehouses.

  • Who are the main user groups of this service?
  • Main users of this service are medium-sized and large businesses looking for a cloud data analytics solution, focusing on SQL.

  • Does this service integrate with any other apps?
  • Integrations: Workable, Salesforce, Survey Monkey, New Relic, Unity, Amazon Redshift, BigQuery, Snowflake, MySQL, MemSQL, Microsoft Azure, Amazon S3, Aftership, Amazon Quicksight, Asana, Azure Storage, Bigquery, Delighted, Desk.com, Dynamo, Excel, Formkeep, Freshdesk, Google Adwords, Google Drive, Google Sheets, Harvest, JIRA, Localytics, Mandrill, Marketo, Mixpanel, NetSuite, Oracle, Paypal, Recurly, SAP NetWeaver, SQL Server, Shopify, Taboola, Vero, Xero, Zapier.

  • Does this service offer multi-user capability (e.g. teams)?
  • Yes, there is multi-user capacity provided.

  • Does this service offer an API?
  • Periscope's Embed API allows the user to programmatically specify filters and their values in the URL when embedding dashboards.

FAQs:

    What is this service generally used for?
  • MicroStrategy is used as a business intelligence software solution.

  • Who are the main user groups of this service?
  • Users of this service are SMEs and large enterprises.

  • Does this service integrate with any other apps?
  • This software integrates with Microsoft Office, Salesforce Sales Cloud, SharePoint, Excel, Word, Aspect CXP Pro, Google Maps.

  • What platforms does this service support?
  • There are desktop version and cloud-based deployment available. Platforms that support the platform: Windows, Linus, MacOS.

  • Does this service offer guides, tutorials and or customer support?
  • Support offered: Technical Support, Community, Knowledge Base, Online Support, Phone Support, Video Tutorials.

  • Does this service offer multi-user capability (e.g. teams)?
  • Yes, MicroStrategy offers APIs.

Publisher:

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:

Publisher:

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:
9.57k

Publisher:

Founded:
-
Based in:
-
Employees:
-
Likes:
Followers:

Other:

Who uses PivotData Microservice
  • Startups
  • SMEs
  • Agencies
Desktop Platforms:
  • Web App
Languages:
English
Regional Restrictions:
No restrictions.

Other:

Who uses Periscope
  • SMEs
  • Enterprises
Desktop Platforms:
  • Web App
Languages:
English
Regional Restrictions:
No restrictions.

Other:

Who uses MicroStrategy
  • SMEs
  • Enterprises
Desktop Platforms:
  • Web App
  • Windows
  • Macintosh
Mobile Platforms:
  • iOS
  • Android
Languages:
English
Regional Restrictions:
No restrictions.
Back to top