As a special gift to you for the coming holidays, I am about to share a FREE Excel template that analyzes Salesforce opportunities. While the template is going to be available to all readers by end of 2016, you can be to first to try it, by subscribing to my blog.
Subscribe To DataChant
Join our mailing list to receive exclusive content that was used in the preparation of this article.
Thank you for subscribing to DataChant. An email will be sent to you shortly with more details.
The Salesforce Excel template, uses Power Query / Get & Transform to import the data from Salesforce.
Unlike the typical analysis of Salesforce data in Excel, where you are used to perform sisyphic work to manually export Salesforce data to a CSV file, clean the data and then create ad-hoc reports that can take hours, here, with this template, you have everything ready in a click of a button.
With this template, you can click Refresh All in Data tab to get the latest data from Salesforce.
The Salesforce Excel template focuses on the analysis of opportunities. In the future, I plan to extend the reports to additional Salesforce elements, but the main focus will be to share with you step-by-step instructions, that will empower you to create your own Salesforce reports using Excel Power Query and Power Pivot, or Power BI.
What to expect next?
If you subscribe to DataChant, you will receive an email with a link to DataChanr’s shared resources which are available for all the subscribers. The Saleforce template can be found there, its filename starts with “Salesforce Insights“.
You are welcome to share bugs and feedback in the comments below.
In two weeks, I plan to share the Salesforce Excel template as part of the first blog post in a series that will discuss Salesforce in Excel and Power BI. To follow the Salesforce series, stay tuned to this link or follow me on twitter.
If you have implemented Salesforce reporting in Excel or Power BI, and wish to share tips and tricks, you are welcome to email me at [email protected] I will be thrilled to host you as a guest author.
Stay tuned for the Salesforce Series.