Power Bi - Inefficient Backend Development ?

Hi Anonymous 

I agree with Anonymous. He already said a lot of interesting things. I want to give you an example

Let say that you sell boats and you have access to all boats sold by the competition. You will be interested to look at what is your Market Share in the Industry.

Market share, being defined as a SUM over a SUM will be difficult to store it inside your database. You can store it but it will for a specific granularity and set in stone. Market share is a non-additive KPI in this case.

What if you want to look at the market share in all these contexts?
- By Product?
- By Year? Last Year, Last 3 months, Last 4 weeks
- By Segment of the industry?

Using Power BI, you'll definie only Once the KPI as a Measure and you'll be able to build different visuals and easily change the context by Drag and drop fields from your dimensions.

You build one Dataset with a lot of KPIs with predefined business rules that you document then you share the dataset to others where they can build different reports always using the same business rules and logic.

Hope it helps!