Solved

Best 3rd party SQL Dashboard Reporting Tool?

Posted on 2016-11-29
4
21 Views
Last Modified: 2016-12-01
We have two unique EMRs, both of which use SQL for data storage--we are looking at providing dashboard reporting for other end users.  Right now, we do a combination of Crystal Reports that farm out via automated emails--which works but is a bit cumbersome if new users would like the report, reports change, etc.

Ideally, we would like a dashboard where SQL Queries/Reports can be uploaded/built--then an end user can be assigned rights/services to access those reports.  It would be more granular and easier to update.

Our EHR systems offer unique dashboards for each--but both are $$ and then we ended up with two different platforms.  

Does anyone use SQL Dashboard Software they would recommend?  I'd prefer to stay away from the Periscope/Cloud platform if possible.
0
Comment
Question by:CMCITD
4 Comments
 
LVL 18

Expert Comment

by:vasto
Comment Utility
Check R-Tag (http://www.r-tag.com/Pages/Screenshots.aspx) It has Dashboards and support for Crystal reports too. It is possible to use your existing Crystal reports and extend them as Dashboards or create new dashboards from scratch.

You can check some of the big players too:
Qlick (http://www.qlik.com/us)
Tableau (www.tableau.com)
0
 
LVL 17

Accepted Solution

by:
Pawan Kumar Khowal earned 500 total points
Comment Utility
Prefer - Tableau <<(www.tableau.com>>  They are the market leader now.

You can also use Gartner Report .  <<http://www.tableau.com/about/blog/2016/2/fourth-year-gartner-names-tableau-leader-magic-quadrant-49719>>

EE
Hope it helps !!
0
 
LVL 12

Expert Comment

by:Arifhusen Ansari
Comment Utility
Hi ,

While we provide any report architecture. We have to think that what kind a report, we will provide to users.

Are they detail reports ( like traditional reports)  or dash board reports like Charts graphs and all.

I would suggest you to go with SSRS in SQL 2016.

You would ask why 2016. It just because in 2016 they have revamped the whole ssrs. It provides you not only traditional ssrs report but also dash reports, mobile reports and all.

So you can provide the traditional report plus new way of reporting like Dash board and Mobile reports.

You can handle user right on different reports and dash boards. You can also upload the

New SSRS also gives you the feature that you can upload the power bi file to report portal and so on.

Depends on your requirement. you can use the SQL 2016 reporting tool.

Below are the links those give you more insight for this.

New In SSRS 2016

https://www.youtube.com/watch?v=bJMrmET693o
https://www.youtube.com/watch?v=RzouVBpT1uA&t=115s


Power BI to SSRS implementation

https://www.youtube.com/watch?v=QhPQObqmMPc

Pricing Detail

https://www.microsoft.com/en-us/sql-server/sql-server-2016-features


Hope it will help you !!
0
 

Author Closing Comment

by:CMCITD
Comment Utility
Thanks all for the replies.  I'm playing with Tableau right now--and I think this is what I was going for.

SSRS in 2016 looks terrific as well.  Thanks!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now