Notifications
Clear all
Topic starter
Want to know what most users are using for Data reporting for measures for Diabetes, HTN, etc? Reports built or interfaced software?
Posted : August 2, 2017 3:54 am
I am the database analyst at our community health center and we mainly use SQL server report services reporting (SSRS) and SQL server integration services (SSIS) for data warehousing. Using SSRS and SSIS I am able to create dashboard like reports. I really like SSRS because it is allows me to be creative and display data in different way. Below is a link to a couple screenshots of dashboards I have create. Both of these allow for drill down into patient level details. First time posting, so hopefully the link works! We are also looking into using Power BI now that Microsoft has released Power BI Server, which allows you to deploy Power BI Desktop reports on-premise verses to the cloud. Hope some of this information has helped and feel free to reach out to me directly if you have additional questions.
Posted : August 2, 2017 8:48 am
Another vote here for SQL Server Reporting Services (SSRS), which is what we use for both on-demand and automated reports.
Posted : August 2, 2017 9:32 am
That looks very slick. I currently write a whole lot of reports in Crystal, with most of them using either database views or crystal Commands (which are SQL queries)
We are on CEMR (Oracle). A quick Google query shows that SSRS can connect to an Oracle database. In your opinion would this be worth looking into or should we look elsewhere?
Posted : August 2, 2017 10:32 am
It might be worth looking into. Fortunately for me, when I started here at this CHC, we had multiple copies of SQL Server 2008R2. So I was able to spin up a report server for a data warehouse very quickly. So you would definitely need to weigh the cost of SQL Server versus other data analytics software. The cost might be bigger upfront, but there is no per month per user cost, like Tableau or other solutions have. Also if your organization is a non-profit you can get huge savings using Techsoup.
I would also look at Power BI desktop if you are looking for something to start exploring Microsoft products. It is free and you can share the files from the reports with other users that have Power BI desktop. Mircosoft is really starting to grow the SQL Server product so I believe it is definitely worth exploring.
Posted : August 2, 2017 10:45 am
Was this dashboard written on SSRS SQL 2008? I am assuming the way you upgrade SSRS is to upgraded to a newer SQL server? We have multiple SQL servers in our environment, one of them being the data warehouse for our PM system which is running SQL 2008.
Would you be willing to share any of the reports for measures that you have written? It would be great to have a starting point or at least an example to start from, something that I could pick apart and learn from.
Posted : August 2, 2017 11:02 am
Yes they are written in SSRS SQL 2008r2 and I am in the process of converting them over to a new SQL Server 2016 server. I didn't upgrade my current environment because I did not want to take the current environment down for an extended time. So I have both currently and am working on migrating when I can. I am more than willing to share some reports, but the dashboards are tough to share because they have a very complex SSIS package that extracts the data from our production database nightly and builds the tables in the data warehouse. So it get complicated really quickly with those. But I have multiple other reports that I could share. I have a pretty busy end to this week, but I could jump on next week and share some examples.
Posted : August 2, 2017 11:13 am
We use Crystal Reports for many of our requirements. Lately, I have built Excel dashboards that read the automated output of the CR (to xls). Does both summary data and drill-down data. Kind of complicated to write the Excel commands, and took some planning, but it is nice for Providers to see how they are doing with metrics and for Administrators to review how the entire practice is doing.
Posted : August 3, 2017 6:43 am
