Orion Health Project Overview

This Project is based on BI which deals with product quality and reliability. I deal with the issue of reports being manually created as well as the data stored in an unreadable, unstructured form within Orion Health who provide products to many clinics and hospitals locally and globally. The process takes a lot of time and energy, it gets difficult for the Complaint Administrators to carry out the process to provide meaningful data to management in a fast paced environment. Many more companies follow a similar manual procedure who are also not using the best approaches carry out processes which come with data retrieval and reporting. I have come up with my own solution to reduce the effort that goes into this using SSIS and SSRS. I also review different types of software which can be used for storing data, carrying out the ETL process and reporting. This is considered as a concern as it is critical to pay attention to the complaints in a quick manner which companies receive to ensure the quality of the product is maintained, customers are satisfied and also increase due to good services provided.