Adventure Works Overview Report 05-11-2017 02:40 AM - last edited 11-01-2017 02:42 AM

[luthfur]

Here is a report I've created over the popular Adventureworks database. I have inserted all the data into a CRM instance (Xynics CRM) and imported data directly from the CRM tables (SQL Server).

There is absolute minimal DAX used, I use this report to show users how easy it is to use Power BI and what they can achieve. I've tried to use a variety of visuals, both custom and standard, 

I always like to point out that the amount of information one can retrieve from a single page in a report is almost without boundaries, with the ability to use the filters (slicers), drill down, filter across visuals etc. Users who make use of one visual more than others are obviously able to pin that particular tile to a dashboard.

All feedback is welcome.

Any questions:

Twitter: @Luthfur123

Email: luthfur.rahman@xynics.com

LinkedIn: https://www.linkedin.com/

Website: www.xynics.com

Enjoy!

eyJrIjoiY2NkNWYxOTUtOGYyZC00OTAzLThmNjMtNzkzN2M3OGI2NmZjIiwidCI6IjY4ZWVjZjcyLWQwOTEtNDI5OS05YmM2LTg2ZjMyNzgwZDdiMiIsImMiOjh9

[carlosDash]

Hi,

This is a cool demo and very useful since it uses the readily available Adventure Works database. 

Could you explain a bit more how you processed the data and created the model? You mentioned using "Xynics CRM", how does this application process the data? Do you think this PBI report can be created straight from raw AdventureWorks data or does it have to be refined first?

Thanks for taking the time to create this!