Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Analytics Dashboard fo...
Microsoft Dynamics RMS (Archived)

Analytics Dashboard for RMS Point of Sale

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have a retail Bicycle Store in Connecticut that uses Microsoft RMS Point of Sale.  I'm looking for a Analytics Dashboard solution.  Currently I'm exporting multiple reports from RMS to Excel so that I can look at the information in a Dashboard type format.  I would like a solution where the information is updated each night so that I can look a my business at a glance.  I'm assuming someone has already created a Analytics Dashboard that works with the RMS Point of Sale.  I know that Excel can be setup to connect to my RMS database via SQL Server but I just don't know how to do it or have time to figure it out.  I'm hoping someone has already created a solution for this or would someone be interested in creating a custom solution for me.

Thankyou,

Steve

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Analytics Dashboard for RMS Point of Sale

    Did you ever create something for your RMS Analytics? Interested to do the same here.

    Danny

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Analytics Dashboard for RMS Point of Sale

    Thanks for the suggestion - I'll look into Power BI

  • RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Analytics Dashboard for RMS Point of Sale

    This looks promising:  powerbi.microsoft.com/en-us

    The desktop version is free: powerbi.microsoft.com/.../downloads

    It is not plug and play but their community forum looks pretty active. ;->

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Analytics Dashboard for RMS Point of Sale

    I dont know or an existing solution.  But I do know how to connect excel to the rms database and how to use power pivot and advanced technics to create you a dashboard.  

    if your interested you can private message me.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans