Panoply, Stitch and Chartio today announced the availability of the world’s first Automatic Cloud Data Stack. The combined offering enables data analysts and business users to connect to disparate cloud applications and databases and gain business insight by visualizing their data. The platform includes a self-optimizing petabyte-scale data warehouse, a self-serve ETL pipeline, and a modern business intelligence platform with pre-built business dashboards, all accessible in an integrated environment for an optimal customer experience.
“In July of this year, Gartner said that augmented analytics, an approach that automates insights using machine learning and natural-language generation, marks the next wave of disruption in the data and analytics market. Two months ago Larry Ellison dedicated the lion’s share of his Oracle OpenWorld keynote specifically to this topic,” says Panoply CEO Yaniv Leven. “We’re seeing huge customer demand from professional analysts and citizen analysts who want more and faster access to data. The challenge has always been that to extract information from data, the data had to go through the IT department, and demanded incredible coding resources and technical expertise to put it in an accessible place and format. Well, no more. This collaboration unshackles data from the IT bottleneck and provides analysts with the ability to control the entire pipeline.”
The new offering lets users entering the Chartio self-service business intelligence platform choose their data sources and move on to powerful dashboards with just a few clicks. The flow of data from the Stitch-powered ETL process into Panoply’s Smart Data Warehouse and thence to the Chartio cloud analytics solution happens seamlessly behind the scenes. Generally, setting up a software ecosystem similar to the Panoply, Stitch and Chartio stack requires a lengthy process of researching, implementing and integrating various tools that aren’t guaranteed to work (or cost) as expected at the end of the process. Implementing the Automatic Cloud Data Stack eliminates the need for lengthy warehouse setup and configuration, and does away with the need for coding to integrate disparate data sources, perform ad hoc queries, and create interactive charts and dashboards.
By migrating to the Automatic Cloud Data Stack, business users and data analysts free themselves from IT shackles:
- Zero management – There’s no need to wait for data engineers and developers to deliver data. The joint platform enables users to extract, transform and load data with a click of a button and make it available to Chartio’s drag-and-drop analytics interface.
- Full flexibility – The platform can be extended and modified easily with a large ecosystem of compatible data tools to select from.
- Universal data support – The platform supports structured and semistructured data, and automatically converts JSON, XML and data from MongoDB and other NoSQL databases into columnar form in a structured database.
- No coding required – Using Chartio’s drag-and-drop interface, users can create ad hoc queries and custom interactive dashboards. Chartio creates native SQL queries based on the database used in the back end and uses machine learning to choose the best chart type for each query.
- Speaks SQL – Every part of the joint platform speaks SQL. Anyone who can write SQL can manipulate data – no programming needed.
- Faster queries – Panoply machine learning algorithms detect slow queries and improve performance through data caching.
- Full elasticity – The joint platform is based on a serverless infrastructure, allowing it to autoscale, distribute workloads and perform seamless storage and performance optimizations, including metadata and query executions.
- Enterprise-grade privacy and security – The platform incorporates secure multistep authentication and access control, and industrial-grade encryption for data both in flight and on disk. It employs Panoply’s strict privacy and security measures, and offers compliance with GDPR, SOC2 and HIPAA regulations.
Stitch CEO Jake Stein says, “This platform enables a best-of-breed data stack at the touch of a button. Users get the time to value and user experience of an integrated solution while maintaining the extensibility of three first-class independent products. For companies that want to build a culture of data-informed decisions, there's no better option.”
“We’re putting the power into the business users’ hands,” adds Chartio CEO Dave Fowler. “By incorporating Panoply, Stitch and Chartio in a single platform, we can extract, transform and load business data into an Amazon Redshift data warehouse that has Redshift columnar storage and connect it to Chartio all in a few clicks. We’re removing the onboarding bottleneck and allowing everyone in the organization to access and understand data without having to depend on data engineering or IT for setup, approval or access.”
Panoply is the world’s first Smart Cloud Data Warehouse. Panoply delivers the industry’s fastest time to insights by eliminating the development and coding typically associated with transforming, integrating and managing data. Panoply’s proprietary AI technology automatically enriches, transforms and optimizes complex data, making it simple to gain actionable insights. The company, based in San Francisco and Tel Aviv, is privately held and funded by investors such as Intel Capital, 500 Startups, Blumberg Capital and C5 Capital. For more information and a list of career opportunities, visit https://www.panoply.io, or find us on Twitter, Facebook or LinkedIn.
Stitch is a simple, powerful ETL service built for developers. Stitch connects to all your data sources – from databases like MongoDB and MySQL to SaaS tools like Salesforce and Zendesk – and replicates that data to your data warehouse. With Stitch, developers can provision data to analysts and other team members in minutes, not weeks. To learn more, visit https://www.stitchdata.com, read our blog, and follow us on Twitter (@stitch_data), Facebook and LinkedIn.
Chartio is on a mission to democratize data across organizations so that everyone can access, explore, transform and visualize their data. To that end, Chartio has built a cloud-based data exploration tool that’s simple enough for every department yet powerful enough for the data team. Chartio has been named a “High Performer” BI tool by G2Crowd in 2016 and 2017. To learn more, visit Chartio.com or follow us on our blog, LinkedIn, Facebook and Twitter.