Compare PivotData Microservice vs Looker vs Periscope

More Information Get a Demo More Information

Crozscore:

73%
what is this?
28%
interest falling

Crozscore:

88%
what is this?
94%
50%

Crozscore:

81%
what is this?
39%
no significant changes
PivotData Microservice screenshot view 1 more Looker screenshot view 1 more Periscope 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:

Looker is reinventing business intelligence for the modern company. Looker works the way the web does: browser-based, its unique modeling language lets any employee leverage the work of your best data analysts. Operating 100% in-database, Looker capitalizes on the newest, fastest analytic databases—to get real results, in real time.

How Looker works in 5 simple steps:
1. Connect Looker to any relational database, like Amazon Redshift or Google BigQuery.
2. Let Looker automatically generate a data model from your schema.
3. Embellish the data model with custom dimensions and measures that reflect your company’s unique business logic.
4.Give all your users—technical and non-technical—access to Looker to answer their own questions through reports, dashboards or just exploring the curated environment you have built.
5.Relax as Looker translates their business questions into performant (and dialect-specific) SQL.*

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.

Features:

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

Features:

  • Scheduling
  • 2-Factor Authentication
  • Customer Management
  • Analytics
  • Dashboard
  • Supplier Management
  • Notifications
  • Inventory Tracking
  • Multi-User
  • Link Tracking
  • Project Management
  • Forecasting
  • API
  • Data Export
  • A/B Testing
  • External Integrations
  • Data Visualization
  • Conversion Tracking

Features:

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

Summary:

    No key features associated with this application.

Summary:

  • A data platform for all.

  • A powerful data platform that's easy for everyone to use.

  • Business intelligence, big data analytics, or a 360 view of your customers. Whatever you need, Looker can help. Talk to our data experts.

Summary:

  • Templates

  • Collaboration

  • Data Cleansing

  • High Volume Processing

  • Data Mining

  • Analytics

  • Dashboard Creation

  • Filtered Views

  • Graphical User Interface

  • Data Visualization

SaaS monthly based / Annual contract

Free
Included in plan:
  • Free 21 Day Trial

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?
  • In addition to a dedicated support analyst and success manager, Looker offers a documentation library and discourse community to post questions, tutorial videos, etc.

    There is also in-app live chat where you speak to one of our technical analysts between business hours.

  • Does this service offer multi-user capability (e.g. teams)?
  • Looker offers user attributes and privacy settings to allow for permissions.

    While intended as an organization-wide solution for all of your data needs, Looker offers specific applications developed for departments or specific verticals that are a compilation best practices.

  • What are some applications this service is commonly used in tandem with?
  • Any relational database.

    Looker is also great to pair with a predictive analytics tool such as Python or R.

  • Does this service integrate with any other apps?
  • Looker connects to any relational datastore such as mySQL, Google BigQuery, Amazon Redshift, etc.

    Looker has over 44 Technology Partners and 50 Systems Integrator and Consultant partners.

  • Does this service offer an API?
  • You can use the Looker API with any programming language or application environment that can make HTTPS requests and process JSON responses.

    You can also embed Looker visualizations and explores into any website and give limited feature availability to clients, customers, or data digesters.

  • What platforms does this service support?
  • Looker supports:

    • Chrome
    • Firefox
    • Edge
    • Safari
    • Internet Explorer (version 11)

    Looker supports the current and previous major releases of Chrome, Firefox, Edge, and Safari. Each time a new version is released, we begin supporting that version and stop supporting the third most recent version.

  • What is this service generally used for?
  • Exploring and acting on data insights.

  • Who are the main user groups of this service?
  • All business and technical employees.

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.

Publisher:

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

Publisher:

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

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 Looker
  • Startups
  • SMEs
  • Enterprises
Desktop Platforms:
  • Web App
  • Windows
  • Macintosh
Mobile Platforms:
  • iOS
Languages:
English
Regional Restrictions:
Only currently available in English.

Other:

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