Activate your data warehouse for business users, generate reports in Excel, Google Sheets and PDF, and distribute via email, Slack, MS Teams and cloud storage.
Excel and Google Sheets are a great way to provide selected data from your data warehouse to business teams, allowing users to perform the analysis they need in the tool they know best.
Sync data into spreadsheets or PDF at scale and build comprehensive reports.
You can even sync data entry back from Excel and Google sheets into the data warehouse.
Start syncing data from your data warehouse into spreadsheets and PDF in minutes with scheduled updates. You can even sync data back from Excel and Google Sheets into your data warehouse.
Write SQL queries to prepare the data for reporting in Excel, Google Sheets and PDF. Easily filter data for personalized reports based on department, role etc.
Apply any custom logic using simple scripts. Interact with your reports using easy single line Python functions.
Your reports can be shared through OneDrive, Sharepoint Google Drive, shared links etc.
Send out emails at scale to inform recipients of new reports, using shared links in the email or by attaching an Excel export or PDF export of the report.
Send out messages using Slack and MS Teams to individuals or teams to announce new reports or share reports directly in channels.
Connect Excel 365 or Google Sheets with a few clicks, and start syncing data from your data warehouse into spreadsheets. Or generate PDF reports based on your data.
Choose how to distribute your reports, inform users using email, Slack, Teams etc.
Allow data entry in Excel and Google Sheets, for example setting sales targets based on the actuals in the report, and write back these targets into the DWH.
Write optional SQL queries to transform your data before writing to your reports, e.g. perform rollups to reduce millions of rows to a data volume suitable for Excel or Google Sheets.
Personalize reports at scale by filtering data based on department, region etc.
Activate data in your data warehouse using a combination of SQL and low-code Python. Interact with Excel, Google Sheets and PDF documents with intuitive single line Python functions.
Data activation is all the things you can do besides traditional BI, to make your business more data-driven, automate data-related processes and increase productivity.
Send out business alerts based on data changes in your data warehouse. Alert individuals and teams on Slack and MS Teams.
Generate personalized reports in Excel, Google Sheets and PDF. Distribute reports by email, SFTP or cloud storage (Google Drive, OneDrive, Sharepoint).
Set up web-based forms and interfaces for data entry or for data access. Writeback updates into your database. Send real-time query results to the UI.
Implement a Chatbot similar to ChatGPT (LLM) based on your internal company data and enable language-based data interaction.
Handle files at scale, both for data import into your data warehouse, as well as exporting data and distribution of files.
Easily handle cloud storage (OneDrive, Google Drive, Dropbox, Sharepoint), files on SFTP, and file attachments in emails. Work with any type of files: CSV, JSON, text files, Excel etc.
Easily publish Data APIs with selected datasets, for data sharing with partners, customers and suppliers. Handle custom logic in API endpoints with low-code Python.
Convert a custom query in an API endpoint instantly. Serve data using REST and JSON or any other data format.
Sync data between business applications or between your data warehouse and business applications (Reverse ETL).
Use the 250+ Peliqan connectors for both reading data and writing to business applications, databases, files and other APIs.
Use low-code Python, combined with SQL, to implement any type of automation or integration. Writeback to business applications with easy function wrappers. Access data as data frames, use Streamlit for interactive UIs.
Code in your favourite IDE or in Peliqan directly. Schedule runs and view logs.
Don’t worry. Peliqan is an all-in-one data platform with 250+ connectors and instant ETL pipelines.
Every connector can instantly be used to sync new data into your data warehouse or directly into your reports. No data warehouse yet ? Use the Peliqan built-in data warehouse.
