I have been given a hypothetical medical sales representative data. The raw data comes in a spreadsheet. I am to analyze this data and provide an interactive and meaningful report. To achieve this I will be using Microsoft Power BI.
The following is the final output of our analysis:
Many people might not of heard of the term KPI or key performance indicators. KPIs are very popular in the business world, but are they known or used in health care? Most importantly, are they reliable?
The ER is always a hot topic because of how busy it gets and not enough staff to serve incoming patients in a timely manner. With the data we have, we will look at emergency room throughout or length of stay. This will help us understand the status of patient access, patient volume and health system support.
Analysing what people come in for medical care can be important to identify what procedures are needed the most to improve and ehance support. Procedures are not necessarily surgical procedures, but could be medication reconcilation or lab result interpretation.
Knowing our population is important for further development and the improvement of care. Looking at volumes helps us understand the flow and activity of patients in our healthcare institutions.
You are given a dataset with a lot of patient information and you want to look at patients' blood pressure measurement for medication adherence purposes. You may be inerested in who pays for theses visits for the management of bloood pressure.
The ever-growing health information generated by providers and physicians is managed by health information (HIT) systems. Health information technologies have revolutionized our health care systems.… Read More »Usability of Health Information Systems
Our health care industry is flooded with data and it keeps on adding with the advancement in industry. With so much information gathered most of it gets unnoticed. Health care professionals need relevant data more quickly which helps the health care professional in day to day decision making. Be it evidence base practice, patient history or a similar past case health care professional need it ASAP.
Our health care industry has evolved dramatically over the past few decades. It is definitely not the same as it was 50 years ago. As… Read More »Mismatch Between Meaningful-Use Criteria and Clinical Practice
With the advancement in health care systems, the world is shifting towards better, faster and sustainable technologies. Health care systems are inclined towards a decrease in mortality rate, numerous errors have been reported by health care professionals in past due to misdiagnoses or by prescribing wrong medications. Of course, physicians/prescribers are human, and errors can be made when they must go through multiple steps for patients, including:
• Prescribe
• Transcribe
• Administer
• Monitor
