Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Want to know what other users are using for data reporting?

General Discussion

Last Post by joeg1962 7 years ago

8 Posts

5 Users

0 Reactions

70 Views

RSS

scottk

(@scottk)

Posts: 62

Estimable Member

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

jbarta

(@jbarta)

Posts: 12

Active Member

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.

Report screenshots

Posted : August 2, 2017 8:48 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

jbarta

(@jbarta)

Posts: 12

Active Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

jbarta

(@jbarta)

Posts: 12

Active Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
9 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0