March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
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! 🙂