miMed
The solution focused on monitoring core metrics of miMed's daily activity, namely Appointments, Billing, Clients, Specialty Mix and Occupancy Rates.
Challenge
The miMed application portfolio consists of a set of separate applications that are essential to the business's daily operation. Each of these applications has its own isolated database (DB), which stores all the data generated and recorded in that application. Analysis and reporting relied on report extracts from the production databases, which were then worked on in Microsoft Excel and shared with the teams. As the volume of data generated and the analysis needs grew, the traditional, semi-automated data extraction and transformation processes gradually stopped keeping up with the daily pace of operations.
Solution
In response to the need to structure, centralize and automate existing processes, and building on two core operational systems, miMed turned to Gstep to develop a Data Warehouse (DW) and implement Microsoft Power BI, which allowed teams to query and explore information through interactive dashboards.
Result
- The solution focused on monitoring core metrics of miMed's daily activity, namely Appointments, Billing, Clients, Specialty Mix and Occupancy Rates.
Implementing this data architecture, together with the dashboards developed in Microsoft Power BI, made it possible to achieve several goals, namely:
- Information quality and consistency: there is now a single source of information, where business assumptions and rules are common to the whole company.
- Accessible, automated reporting: automated periodic integration of multiple sources.
- New decision-support analyses, made possible by integrating the different sources and by the processing power of the data visualization tool.
GSTEP delivered the proposed project, showed constant involvement at every stage and continues to do so now, after the project. We are grateful for the dedication, professionalism and commitment of the whole team.
More cases
See all cases-
ChallengeHelp choosing a cloud platform for a new Data Warehouse. ResultCloud-only environment for data analysis, integrated with AI and Machine Learning tools on Azure. View case -
ChallengeWith decades of experience managing health services, AdvanceCare had extensive knowledge of Fraud and Abuse, but needed to move forward in automating and systematizing how it was monitored. The company wanted to analyze a larger number of fraud scenarios through automated processes able to detect more suspicious cases and make them available faster, both to internal teams for analysis and to institutional clients, through a simple, fast Business Intelligence (BI) interface. ResultInsertion and update of around 300,000 records/day. View case -
ChallengeThere was a need to report on business indicators and obtain a global view of the Luz Saúde group, namely by collecting, analyzing, transforming, monitoring and sharing data from each hospital unit, both to support decision-making and improve the service provided to patients and to meet contractual requirements. In addition, the group faced continuous growth in the volume of information to analyze. It became essential to work with data from different sources in an integrated, unified way, adding value and fostering continuous improvement, as well as to meet business requirements in near real-time. ResultGreater capacity and speed for constructive analysis of information. View case
Have a challenge on your hands?
Tell us what you want to achieve and we'll bring together the right team to make it happen.
Book a meetingWant to join the team?
8 open roles, from internships to consulting. Apply on the site with your CV.
See open roles