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

Daily Archives: July 17, 2019

You are here:
  1. Home
  2. 2019
  3. July
  4. 17

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