Power BI for: Ever ?!

by Super User ‎03-30-2018 08:54 AM - edited ‎10-23-2018 07:31 AM

 

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
by webportal Member
on ‎07-23-2018 05:56 AM

This is really fantastic, thanks for this Imke!

by Larstc Regular Visitor
on ‎10-01-2018 01:02 AM

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

by Super User
on ‎10-23-2018 07:34 AM

Hi @Larstc,

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

I've updated the link now.

/Imke

by Picci Frequent Visitor
on ‎02-11-2019 01:50 PM

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? 

by Super User
on ‎02-11-2019 11:03 PM

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.

by Picci Frequent Visitor
on ‎02-12-2019 12:02 AM

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