EDITable provides a self-service platform that helps you manage reference data for your reporting & planning applications in Power BI. It complements your Master Data Management (MDM) solution and offers a lightweight alternative for business users that supports both reference data (such as customer, region, and product master) and flat tables (such as price list, contracts, projects, and discounts).

Highlights

Edit dimensions & measures in flat tables
Designed for business users; requires minimal help and setup from IT
Migrate your first Excel table to EDITable in three (3) minutes
Supports LIVE sync with data residing in Azure SQL, Databricks, Snowflake, Microsoft Fabric, RedShift, and Postgres

Features

Bulk Insert/Edit values
Custom approval workflows (table-level, dimension-level, and value-based)
Supports Slowly Changing Dimensions (SCD) Type II
Change log for enabling audit
Conditional formatting
Commenting & collaboration
Data integration with webhooks
Granular user activity permissions (add/delete/edit rows)
Columnar permissions (ACL)

Power Your Planning Applications Using EDITable

EDITable ensures that you have full control over master data supporting your planning applications. Be it products, regions, accounts, cost centers, customers, employees, or salaries - you can maintain everything with ease to ensure the integrity of your plans and forecasts.

EDITable makes it much easier to incorporate forward-looking master data that is needed for planning, especially master data that is not yet created in your transaction systems or data warehouses.

EDITable vs. Other Matrix Visuals with Writeback

Discover how EDITable is different from other matrix visuals with writeback capabilities:

Data Store: A matrix visual typically consumes data from Table A, and writes back data to Table B. With EDITable, the source & destination tables are (must be) the same as you are working on reference data (which can used by multiple other applications).
Connectivity: A matrix visual typically supports both Import and DirectQuery modes. EDITable can only consume DirectQuery (Live) connections.
Data Type: A matrix visual typically allows you to update measures; EDITable can be used to update both dimensions & measures.
Sample Use Cases: Matrix products are best suited for planning and forecasting applications; EDITable works well for maintaining reference data and flat tables such as price lists, vendor lists, etc.
Structure: Matrix products work well with hierarchical data; EDITable exclusively supports flat (non-hierarchical) tables, and offers support for slowly changing dimensions (SCD Type II).

Learn More

Visit our website to learn more.
Join our upcoming webinars / replay past webinars.
Follow us on LinkedIn and YouTube.
Post technical questions and interact with other users in the Inforiver community.
Schedule a demo with our sales team.

Inforiver EDITable

por xViz LLC dba Lumel