Data into Actionable Insights

The art of sales operations, business intelligence and any data related roles is to turn Data into Actionable Insights. I build business applications for software companies to help business leaders leveraging their data. 

In this blog, you’ll find articles related to Sales Operations, Business Intelligence and Business System Architecture. I mainly worked with Salesforce, SQL Server and Power BI.

Data migration best practices

Data migration best practices Salesforce data migration projects can be a hassle if you don’t have any best practices to follow. I recently had to split an object into 2 objects as we were storing information of 2 separate “elements” into 1 object. This kind of architectural mistake causes many issues. Namely, fields are getting…

Details

When the Waterfall just doesn’t line up right

When the Waterfall just doesn’t line up right Pipeline waterfall charts are great to analyze your pipeline. Recently, Salesforce launched Einstein Analytics, and it comes with these amazing charts. However, some Salesforce Orgs will face some “bugs” with these charts. Bars on these charts won’t even out, and the following equation can be false: Open…

Details

Pipeline Management with Mario charts

Pipeline Management with Mario charts Pipeline management is the key to generate predictable revenue. KPIs like win rate, pipeline coverage, and Mario charts can provide significant insights on pipeline management. Let’s say your 10 sales reps team has to close 10M€ per year. On average, they win 1 opportunity out of 4.  Each sales rep…

Details

The benefits of designing Sales territories

The benefits of designing Sales territories Territories benefits remain a bit gloomy for many people. In this post, I’ll explain why developing and maintaining sales territories in Salesforce is essential.  Territory implementation means assigning one or many users for each account. Thus, having a table with “accounts” in column A and account owners in column…

Details

Tell a story through your dashboards

Tell a story through your dashboards Analysts build so many reports and dashboards that it gradually becomes impossible for the management team to focus on the primary key performance indicators – or KPIs. Together, they should choose the KPIs that they want to track on a daily, weekly or monthly basis. Let’s say the business…

Details

Help sales managers analyze CRM data

Help sales managers analyze CRM data Today, sales managers have access to more data than ever. Salesforce login times, calls, meetings, new contacts, new opportunities, Sales managers can monitor anything they need. Sales operations create new processes and make sure that data is reportable. The more information they create, the more they’ll be able to…

Details

How to improve Salesforce user adoption?

How to improve Salesforce user adoption? Salesforce user adoption is one of the significant challenges Sales Operations faces every day. New business processes don’t worth a penny if users don’t adopt them. Change management is the hardest thing to get right. In this post, I share a few tips to increase Salesforce user adoption. Reduce…

Details