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.

My first Python game

My first Python game This is a non data-related article. However, learning Python might be helpful to master for future data projects, especially when it comes to Data Science. Python has great data related libraries such as Pandas, Seaborn and Matplotlib. They can be used in tools such as Power BI, and I already noticed…

Details

Working with organizational hierarchy in Power BI

Organizational hierarchy or account mapping adds complexity to reporting. Being able to work with it with basic reporting tools like Salesforce report is impossible. For example, if your company sells to big customers with hundreds of subsidiaries, chances are that account mapping is quite important for your selling strategy. Account executives need analytics suited to…

Details

Computing run rate in Power BI

A run rate is a forecast based on current performance. For SaaS companies, this metric is interesting to compute as their future performance is highly influenced by the actual ARR of the company. For example, if a company sells yearly subscriptions, the sales “seasonality” will be influenced by contract anniversary. Business intent The purpose of…

Details

One query to convert them all

One query to convert them all Change management is one of the main key success factors in any Salesforce project. How do you track adoption? How do you ensure that Salesforce users follow your new process? In this blog post, I’ll show how to query the “LightningUsageByPageMetrics” object to get some insights about user adoption.…

Details