Posts Tagged ‘analytics’

In the age of ACOs and value based payments, there is a constant pressure on the healthcare industry to reduce costs without damaging the quality of care provided. While there are many factors in this balancing act, hospital readmissions and lack of medication adherence are two issues driving up costs that can be addressed and […]

Healthcare organizations face a constant pressure to reduce costs and improve performance, all while meeting changing regulatory regulations. Fortunately, with constant developments in technology, health IT can help organizations gain a competitive advantage. Healthcare analytics can provide organizations the ability to use their data to improve the quality of care, increase financial efficiency and operational […]

We have been using a number of database management system (DBMS) such as SQL Server, DB2, and Oracle, but probably we don’t care about how the data is stored and organized in disk. Actually most of popular DBMS are built upon the row-oriented structure which stores its content by row; while today’s DB market, column-oriented […]

Problem: Following error occurs when a Common Table Expression (WITH) has been used as SQL override, when connecting to SQL database: RR_4035 : SQL Error [Microsoft OLE DB Provider for SQL Server: Statement(s) could not be prepared. SQL State: 42000 Native Error: 8180 State: 1 Severity: 16 SQL Server Message: Statement(s) could not be prepared. Microsoft OLE DB Provider for SQL […]

Value based purchasing in healthcare has been discussed several times on our blog, most recently in the posts “Taking back the reins: Value-Based Purchasing in Healthcare” and “Maximizing Financial Rewards from Hospital Value Based Purchasing.” Last month, Perficient’s Martin Sizemore also co-presented a webinar with CitiusTech called “Hospital Value Based Purchasing: Leveraging Analytics Platform for […]

 As we know, in MSSQL, we could set column identity property as yes to get incremental value, and we could also use sql function RowNumber() to get this. But in SSIS, there is no RowNumber() function, and setting column identity property is also not very flexible, and here is another way that using script to […]

Nowadays when people talk about IT technology and trend, there was overwhelming world of big data as we entering the new technology era. I know that big data has been promoted to national strategy in many countries. A few days ago I found an interesting debate whether the traditional data warehouse will be replaced by […]

Business Objects provides a tool named Metadata Integrator to import relationship between universe and report. You need configure CMS(Central Management Server) and target database in Metadata Integrator first, then run, then it will load those relationship into target database. Below is window when data loading starts Here is description of related tables: Table Name Description […]

When browsing through your Google Analytics account, you might have noticed that the Search Engine Optimization Queries report under Traffic Sources does not show any data:

In a period of rapidly rising costs for healthcare and nagging questions about whether paying more for healthcare results in higher quality outcomes, purchasers of healthcare are looking for tools to measure, monitor, and improve the quality they are receiving for the health care dollar spent. Although there are numerous ways purchasers have approached these […]

Hospital payments should be based on the quality of care delivered, not the number of people treated or tests run. So says Medicare’s Hospital Value Based Purchasing Program, which has put the pressure on hospitals to perform high quality care, not just quantity of services. Medicare delivers reduced reimbursement rates and hospitals earn back this […]

My colleague, Lesli Adams, is a regular blogger on Perficient’s Oracle technologies blog. As the Director of Oracle Healthcare Business Intelligence, she often posts about topics that are also relevant in the healthcare world. She recently posted a blog about data reporting standards that would be a good read for those interested in healthcare analytics, […]