Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Write back data & comments to a database or file

by Inforiver | Jul 29, 2022 |

In the preceding blogs, we looked at why sales meetings are inefficient and how you can capture sales projections directly in your Power BI report. We then looked at how you can use Power BI reports to facilitate data-driven comments and conversations.

In this blog, we will look at how data can be persisted to a Snowflake, Azure or a SQL database, or even a shared folder like OneDrive or Sharepoint. We’ll then look at how these reports can be scheduled. We’ll also touch upon one final feature, the audit trail, which assures report integrity.

***

Continuing from the previous post, once the projections have been finalized, the manager clicks on the writeback prompt and chooses specific data that needs to be persisted.

Writeback Power BI report

He then chooses the destination which can be an on-premise or cloud SQL database, or a shared drive like OneDrive. In this case, he chooses a snowflake database and clicks Writeback.

Choose Database

When you query your Snowflake table, you will notice that the data has been stored along with the comments entered by the manager and sales reps.

Writeback database view

For a step-by-step tutorial on how to writeback data from a Power BI report, watch out for our upcoming blog on Power BI data writeback is as easy as 1-2-3.

***

User-Specific Email Scheduling of Reports

Finally, to streamline the process, the manager also schedules a weekly report that sends PDF and Excel extracts to his sales reps 15 minutes prior to the commencement of the meeting.

The manager can also configure it in such a way that each sales rep receives information only for the category they own. E.g., the sales rep for Computers sees only the subcategory line items relevant to Computers in his/her report.

Formatted PDF export of Power BI report

***

Audit trail of changes to the report

Finally, Inforiver allows the manager to keep track of all the changes made to the report using an interactive and filterable audit trail feature. This delivers a great level of data integrity and assurance to the report data.

Audit trail of changes to report

***

Closing Thoughts

Inforiver allows you to drive productive sales meetings using Power BI. You can

  • allow managers or sales reps to update projections instantly within the report and quickly analyze variances
  • add annotations & commentary to specific projections
  • initiate data-specific conversations
  • assign tasks and send email notifications right from within the Power BI report
  • schedule periodic email delivery of reports in Excel & PDF
  • track changes made to the report using audit trail
  • … and more.

The best part is that everything can be accomplished and managed right from within Microsoft Power BI, without having to resort to offline emails, chats and conversations – making your sales teams highly productive.

Weekly Meetings with Inforiver

***

This post concludes the 4-part series on Driving Productive Sales Meetings with Power BI. Visit other blogs in the series below.

Part 1: Drive Productive Sales Meetings with Power BI - Introduction

Part 2: Input, Edit & Update Data (sales projections) in your Power BI report

Part 3: Facilitate data-driven comments & conversations

Part 4: Write back and save your projections to an on-premises or cloud SQL database or a shared drive (e.g., OneDrive) and other considerations (e.g., email report scheduling, audit trail)


Inforiver Logo
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
ValQBI HubxViz
IBCS Certified
Power BI certified
5920 Windhaven Pkwy, #130
Plano TX 75093
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram