Peliqan reinvented how data teams, business teams and developers collaborate. Data teams can quickly build data products, and share them with business users and developers. And if that is not sufficient, you can empower business teams with self-service access.
Connect to any data source in a few clicks and start exploring your data. Peliqan accesses your data in real-time without the need to set up a data pipeline.
The Peliqan federated query engine enables direct access to data in any source with a unified SQL interface, at an unprecedented speed.
You can join tables from multiple sources in real-time, define custom functions to transform your data in real-time and obfuscate PII on the fly.
Explore, wrangle, prep and edit data in a rich spreadsheet editor. Add your own rows and columns with notes, new data and apply formulas similar to Excel or Google Sheets.
Each connection to the source is read-only, to avoid any risk of data corruption. Still, every user can work with the data in a virtual copy that remains up to date with the source.
All edits, manually added data and transformations are magically applied on read and an optional write-back flow can be configured.
Need to share data down-stream ? No problem, simply materialize any dataset from Peliqan and use it in BI tools or ML/AI platforms.
Easily transform data to make it ready for ad hoc analysis or downstream usage. Data can be wrangled, prepped, de-duped and cleaned and unified using 3 types of transformations:
Power users can write SQL queries to combine data from multiple sources. You can join data from disparate data sources and share the resulting view with business users.
Business users consume the view in Peliqan’s rich data editing spreadsheet editor, and they can work on the data in a new virtual copy that magically stays up to date with the underlying query and sources.
Thanks to Peliqan’s “SQL on anything” approach, you can even access data from SaaS business applications in real-time by writing SELECT queries.
Need to combine data without a joined key ? No problem, Peliqan’s Magical Joins allow you to apply fuzzy matching in order to freely combine data sets.
Turn your data into charts and dashboards with a few clicks and share dashboards with business teams.
Go beyond traditional BI visualisations and turn dashboards into interactive data apps with a few lines of Python code.
Use Peliqan’s low-code environment to build custom front-ends. Capture user input, get feedback, build apps for what-if analysis and build custom data-entry screens.
Data engineers are over worked. Setting up ETL/ELT pipelines for new data requests from the business is time consuming. Peliqan empowers business users to take ownership of data transformations in order to prepare data for downstream consumption. Peliqan is also a working environment next to BI tools, to actively work with data including editing, adding columns, combining data and everything else that used to be done in Excel using one-off data exports.
The result is a new way of collaboration between data engineering teams and business teams resulting in new agile data products within the organization.
… and many other databases, data warehouses, data catalogs and SaaS business applications.
