Introduction to EDITable

Master Data Management with Workflows, Audit & Governance

EDITable is a no-code, live writeback product that lets you create and manage your master tables, reference data, metadata, and flat tables for your reporting & planning applications.

It complements your Master Data Management (MDM) solution as a self-service data management platform within Power BI, empowering business users with little assistance from IT for setup and management.

Manage Reference data and Flat tables

EDITable creates a table for you in the database and provides a pre-configured Power BI report with a live connection to the table. This enables you to update and manage them in real time.

With EDITable, you can:

✅ Build your database from scratch on the required data platforms easily.

✅ Quickly migrate your Excel or CSV data files to your desired destination platforms to manage them.

✅ Update and work with your existing databases in real-time by connecting to them within Power BI.

Along with these core capabilities, EDITable provides robust data security and governance features, including row and column-level access controls, audits, and approval workflows. It also enables seamless collaboration and integration through commenting, webhooks, and historical data tracking with type 2 SCDs.

EDITable supports forward-looking master data that is needed for plans but has not yet been created in your tables. Whether you are a business user or a database administrator, you can leverage EDITable to suit your needs.

Databases Supported

Choose your preferred database connections to create, migrate and manage data seamlessly. EDITable supports a wide range of cloud-based and on-premise databases including Fabric Warehouse, Fabric SQL, Azure SQL, Snowflake, Databricks, BigQuery, Amazon Redshift, and PostgreSQL.

Whether you're importing your spreadsheet data into these connections or connecting to existing databases to manage them, Editable has it all.

Supported databases

Key Features in EDITable

The capabilities of EDITable include:

1. Centralized data management for both reference data and flat tables.

2. Execute CRUD actions on data platforms without any code or extensive customizations.

3. Writeback and sync your data in real-time, anywhere.

4. Robust data governance with row and column-level access controls.

5. Audit logs & approval workflows for change management.

6. Set up a rule-based approval system.

7. Support for lookup tables to create custom rules for approvals.

8. Support for Type 2 SCDs, table editing, and condition-based formatting.

9. Supports bulk edits and updates.

10. Collaborate effectively with your team with the commenting capabilities and also notify them via email.

11. No-code experience and designed for business users.

Key Features in EDITable