# Welcome to PowerTable Welcome to PowerTable!!! PowerTable allows business users to build **no-code, writeback-enabled** **table apps** on Microsoft Fabric. In the following sections, we’ll take a look at the following: 1. [**PowerTable: A Quick Overview**](#id-1.-powertable-a-quick-overview) 2. [**PowerTable’s High-Level Architecture**](#id-2.-powertables-high-level-architecture) 3. [**What makes PowerTable unique? - A Summary**](#id-3.-what-makes-powertable-unique-a-summary) 4. [**Additional Resources**](#id-4.-additional-resources) ## **1. PowerTable: A Quick Overview** PowerTable allows you to do the following: ### 1. Build Data Apps that connect LIVE to your modern OLTP or OLAP data platforms PowerTable helps you to build tabular data apps that connect LIVE to your data platform. The product is engineered to support both write-optimized **OLTP** (Online Transaction Processing) platforms and read-optimized **OLAP** (Online Analytical Processing) platforms. The following platforms are supported: ![Supported data platforms](https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2F9j6JygnKPeFJyML7E67Y%2Fimage.png?alt=media\&token=c888424d-ae21-44b3-b42b-aaad59e2cbbc) One of the benefits of using PowerTable is that it maintains LIVE synchronization between the apps and underlying tables. Note that the source and destination tables for the App are the same in this case. ### **2. Consume semantic models and build writeback-enabled apps** PowerTable also allows you to build Data Apps on top of your existing semantic models. These apps can capture user inputs and write back data to your data platform. Unlike the [previous scenario](#id-1.-build-data-apps-that-connect-live-to-your-modern-oltp-or-olap-data-platform), the source and destination data stores are different when you consume semantic models.
### **3. Leverage built-in no-code workflow, automation and governance capabilities** PowerTable comes with built-in access control, workflow, approval, automation, audit, and governance capabilities. These no-code, out-of-the-box capabilities are a great value add for: 1. Migrating your spreadsheet apps such as lists (e.g., Products) or trackers (e.g., Project status). 2. Managing your reference data supporting your reporting and planning applications. ![](https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FkSB126b4TRgkOT149wCu%2F2.png?alt=media) Note that the master data maintained in your ERP or CRM systems have rigid rules to capture forward-looking data (e.g., a product that is yet to be launched, a company that will soon become a customer, a position for which a candidate has not been hired yet, etc.). PowerTable empowers business users to manage these scenarios with ease without relying on IT. ### **4. Leverage push-down SQL for enhanced scalability** Unlike other products in the market that typically struggle to handle more than tens or hundreds of thousands of rows, PowerTable is highly scalable and can support millions of rows. This is possible as our architecture segregates the user interface from storage and compute and uses pushdown SQL to perform all processing on the underlying database. ![](https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FFSuuNfLQUUNOZtAhxdCf%2F3.png?alt=media) ## **2. PowerTable's High-level Architecture** PowerTable leverages a unique, industry-leading architecture that helps enterprises increase their Return on Investment (ROI) on their modern data platform. Enterprises have already invested in modern data platforms such as Microsoft Fabric, Databricks, and Snowflake. However, all applications in the market today (such as the Enterprise Planning software) require you to replicate or transfer your data to their designated data store. Any updates you make to the data through these apps are retained in the same store, resulting in a data silo. This approach increases cost & complexity for enterprises as they need to perform ETL and complex integrations. Most often, they also need to move the data from such dedicated data stores back to their data platform. PowerTable, on the other hand, syncs LIVE with your modern data store, avoiding replication of data. In addition, it utilizes push-down SQL to run all processes on the data platform, enhancing scalability and performance. The modern architecture is summarized below. ![](https://1781349671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKyXRCFh0c08ryiUFvyMV%2Fuploads%2FUJvXTC0fMQGPiAImfp4d%2F4.png?alt=media) ## **3. What makes PowerTable unique? - A Summary** Compared to other products in the market, PowerTable is unique as it allows you to do the following: * Build modern data apps that sync LIVE to your modern OLTP/OLAP data store * Consume semantic models and build writeback-enabled apps * Leverage no-code workflow, automation and governance capabilities * Utilize push-down SQL for enhanced scalability * Leverage your existing security and authentication provider ...and more. ## **4. Additional Resources** For any questions or feedback, visit our community portal here: [https://community.powertable.com.](https://community.powertable.com/)