skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Re: Adventure Works Overview Report

    Re: Adventure Works Overview Report

    03-26-2018 00:51 AM

    carlosDash
    Advocate V
    8523 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    luthfur
    luthfur
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Adventure Works Overview Report

    ‎05-11-2017 02:40 AM

    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

    Preview file
    502 KB
    XCRMAdventureWorksDemoV2.pbix
    Labels:
    • Labels:
    • Business
    Message 1 of 2
    10,857 Views
    2
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    carlosDash
    carlosDash Advocate V
    Advocate V
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-26-2018 12:51 AM

    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! 🙂

    Message 2 of 2
    8,523 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices