Write-back in any Power BI Model

Power BI enables connectivity to most useful data sources:



Not exhaustive list. Other datasources added monthly.

In Q3 2020, Power ON is expecting launch a new offering that will disrupt the way you think of Planning and write-back in Power BI.

In essence, our service will enable you to perform complex editing of datapoint values (spreading, allocations, goal seeking, etc.) in Power BI models based on a mashup of various datasources.

This new “Composite Writeback” feature will enable Business Analysts to take their existing Power BI models to the next level, by adding planning, forecasting, what-if capabilities, without having to rebuild them.


Here is how it will work:

Use Case:
Sales Forecasts in Power BI with Salesforce and Oracle Data.

  • A Sales Team wants to create a new Forecast scenario for the next 12 months based on the Covid-19 altered business landscape.
  • They need historical information that resides in Oracle
  • They need all current opportunities that are in Salesforce
  • The team would like to have Last Years Actuals copied 12 months into the future with a 50% reduction as a starting point.

You will end up with this in Power BI


Steps:

  1. Create a connection to the Oracle Database in Power BI
  2. Import the Salesforce Data to Power BI
  3. Create a Power Query or Calculated table that loads Last Years Data by month and move it up 12 months. Then multiply by 50%

     

    Enable End-User Input and Commenting:

  • Extend the model with a Writeback Table*
  • Add the Power ON Data Entry Matrix and connect it to the Power ON Writeback service
  • Distribute report for user input and commenting on datapoints

Note! Feature will be licensed separately from Visual Planning and is expected to be available in Q3.
Send us an email to learn more.

*Writeback changes are stored in a SQL Database or a relational database that supports OLEDB or ODBC and has direct query support in Power BI.