Business Intelligence

Business Intelligence is all about delivering business applications, reports and dashboards to help business users making data-driven decisions.

In the following articles, I’ll share my business intelligence knowledge. I mainly work with SQL database and Power BI.

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

4 different ways to dynamically change table’s rows in Power BI

Users often need to see the data in different angles to find the business insights they’re looking for. Instead of creating dozens of visuals in your reports, solutions exist to reduce the number of visuals while giving users control over it. In this post, I’ll detail 4 different ways to achieve this, and I’ll discuss…

Details

Implementing a dynamic Pareto’s rule for products in Power BI

The Pareto principle says that about 80% of the effects come from 20% of the causes. In this article, I’ll create a Power BI measure to rank products from Adventure Works into 4 categories, to show that a few products represent most of the sales from the FactResellerSales table. It’s similar to the Pareto’s principle,…

Details

Getting started with Business Intelligence

Getting started with business intelligence is easy. In this post, I’ll share a few steps to follow to get access to data, start building a data model and create a report in a client application like Power BI. To do business intelligence, you need to: Access data Clean data Organize data Present data Business Intelligence…

Details