Sign up to receive our monthly newsletter, and get the latest insights, tips, advice, and all the resources you need to transform your business with data.
Count on us to be a resource for you. Our webinars equip you with data and analytics best practices and expert insights about the industry. You can also find us guest speaking at industry conferences and user group meetings.
To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Thanks for your inquiry! Someone will be in touch shortly.
MS Azure, Power BI
Care Services, LLC was founded in 2011 and manages a family of companies that provide services and solutions to long-term care pharmacies and hospice providers.
Care Services needed to access and utilize detailed data surrounding its customers, including drug inventory levels, shipment and location, and claims. They wanted to use this data to improve the analytics it provided to its customers, so they could make better decisions around prescription drug types, claims, inventory levels, and more.
However, Care did not have a formal data strategy or a consistent approach to analytics. The organization’s data lived in many places and staff was spending time and effort maintaining two separate data warehouses and data flows. This led to redundant maintenance activities and the inability to perform the breadth of analytics that it desired due to incomplete and unconnected data. The organization also relied on manual reporting in Excel which was time consuming and prone to error.
Care Services looked to Analytics8 to develop an improved data strategy and improve how it collected, used, and analyzed data throughout the company.
To get Care on the right path, Analytics8 first conducted a data and analytics assessment. During this process, we interviewed business users to identify their daily processes and understand how they were currently using their data. We reviewed their existing IT processes, data structures, and documented their requirements for a new analytics solution.
Taking this information, we created a long-term roadmap and detailed implementation plan that included the development of a data warehouse, reusing logic from existing data flows where possible, and development of dashboards in Power BI. Due to HIPAA security requirements, we suggested a hybrid cloud deployment approach with sensitive data being live queried from its source and non-sensitive data living in the cloud to help with performance.
Moving forward with the solution outlined in the assessment, we developed a data warehouse that integrated Care’s disparate data sources (including data from Claim Adjudication Systems (Laker/PDMI), Salesforce, NetSuite, CDS, TracRX, ScriptCare Pharmacy Network, ScriptCare Pricing, and Microsoft Access) into one centralized data repository. We deployed the solution via Power BI Service on Azure (sensitive data remained only in the data warehouse and was not pushed to the cloud). We also consolidated and standardized its existing data structures and processes according to modern best practices.
With a solid data foundation in place, we then developed and deployed a modern analytics solution using Power BI that automated Care’s manual and customized reporting process. The analytics solution provides Care customers with enhanced reports so they can better understand details about prescriptions, claims, top drugs, and much more. For example, Care’s customers are able to better understand details around brand name vs generic drug usage and tweak their utilization of these drugs to realize cost savings.
The roadmap from the strategic assessment provided Care Services with a plan to improve its data and analytics processes, solutions, and technologies. With the implementation of the data warehouse and analytics solution, Care now has one single version of truth, reduced maintenance costs, improved data quality, and gained a streamlined data management process and better analytics.
The new data and analytics solution allows Care Services to:
Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.