cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI for: Ever ?!

 

In the business application virtual launch there have been presented so many things that look (almost) too good to be true. Also check out the in-depth-demo of Power BI and you might understand why my absolute favourite is the common data model and the new common data service for analytics. They are real game changers in combination with the tools to bridge the last mile.

 

They provide the basis for reporting to become a commodity instead of requiring a substantial amount of resources like today. Once you've mapped your data sources to the entities in the common data model, you can use the standard reporting templates that will work out-of-the-box. Set up a basic reporting in no time and adjust it to your needs as you go along.

 

Another aspect here is that once you've set up your reporting like this in Power BI, you can use it basically forever. Your source systems change? No problem: Just re-map your new tables to the existing CDM and ...: That's it. Nothing more to do.

... OK, in order to re-map you might have to shape your new data a bit (or more), but that's all there is to be done: Set up the transformation rules once and the adjustment to new source systems is done.

 

As a consultant, this doesn't frighten me, because I can shift my services towards helping customers to bridge the last mile (adjusting the standard to their individual business model) and to develop the sexy things within the "Insight to action"-area.

 

I cannot wait to see the standard entities evolving and have set up a CDM-Explorer that let's you explore and discover the current model and will also track and highlight changes and additions in the future. So this is still WiP :-)

 

Link to file: CDM Explorer

 

Images:

CDM_Explorer_p1.jpgCDM Explorer: Entities and their relationshipsCDM_Explorer_p2.jpgCDM Explorer: Attributes, details and relationships

Link to file: CDM Explorer

 

The data for this report is taken from the project site on GitHub. Go and check it out and see how you can contribute.

 

Enjoy & stay queryious ;-)

 

 

Comments

This is really fantastic, thanks for this Imke!

I get a: "This content isn't available"

Hi @Larstc,

sorry for the inconvenience, but this links breaks from time to time unfortunately.

I've updated the link now.

/Imke

Hi @ImkeF, I don't understand how I can effectively leverage mapping to CDM (since in this case there is no CDS accessible, for example, by Power Apps). If I map my Customer.csv to Account standard entity, is it something I can leverage from Power BI report template, which is mapped to Account? 

Hi @Picci,

my file is just to navigate and view the elements of the model.

I'm not a aware of a mapping app for Power BI for that purpose.

Hi @ImkeF, thanks for your reply! I got it about the content of the interactive report in Power BI. My question is about this point, which I'm really try to understand: "Another aspect here is that once you've set up your reporting like this in Power BI, you can use it basically forever. Your source systems change? No problem: Just re-map your new tables to the existing CDM and ...: That's it. Nothing more to do."

 

Thanks,

Elisa