Skip to content
Nathan Prats
Data into Actionable Insights
  • Home
  • Sales Operations
  • Business Intelligence
  • Tools
Search:
Search
Linkedin page opens in new windowTwitter page opens in new windowMail page opens in new windowGithub page opens in new windowWebsite page opens in new window
  • Home
  • Sales Operations
  • Business Intelligence
  • Tools

Category Archives: Business Intelligence

You are here:
  1. Home
  2. Category "Business Intelligence"

My first Python game

Business IntelligenceBy Nathan PratsApril 21, 2020Leave a comment

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…

How to build a Pipeline Waterfall from scratch with Power BI

Business Intelligence, ToolsBy Nathan PratsFebruary 21, 20208 Comments

How to build a Pipeline Waterfall from scratch with Power BI The pipeline waterfall report is one of the advanced visuals the sales department can benefit from. Sales Operations often get access to this analysis through third-party forecasting software companies. However, it’s not uncommon to have data issues with this visual. In another article, I…

The one or many date tables dilemma

Business IntelligenceBy Nathan PratsJanuary 15, 20202 Comments

As a data modeler, you need to understand the “one or many date tables” dilemma. You don’t want having to switch from one option to another after a few weeks of development, as it’d be a painful change to go through. In this post, I’ll try to give you a clear overview of these two…

Working with organizational hierarchy in Power BI

Business IntelligenceBy Nathan PratsAugust 13, 2019Leave a comment

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…

Computing run rate in Power BI

Business IntelligenceBy Nathan PratsAugust 12, 20192 Comments

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…

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

Business IntelligenceBy Nathan PratsJuly 18, 20195 Comments

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…

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

Business IntelligenceBy Nathan PratsJuly 17, 2019Leave a comment

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,…

Getting started with Business Intelligence

Business IntelligenceBy Nathan PratsJuly 17, 2019Leave a comment

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…

© 2017 by Nathan Prats
Go to Top