9 minute read
THE POWER OF DATA
AMANDEEP S. MEHTA, DIRECTOR AT CYNOSURE SOLUTIONS, HIGHLIGHTS HOW MICROSOFT’S POWER BI SOLUTION IS EMPOWERING MEDCARE HOSPITALS & MEDICAL CENTRES, A LEADING UAE HEALTHCARE PROVIDER TO HAVE BETTER VISIBILITY AND UNDERSTANDING OF ITS DATA AS PART OF ITS EFFORTS TO MAKE BETTER INFORMED BUSINESS DECISIONS.
Cynosure Solutions, a leading UAE-based IT services company has disclosed the details of a successful project it delivered for Medcare Hospitals & Medical Centres.
Medcare Hospitals & Medical Centres, a premium healthcare network that operates out of the United Arab Emirates, is a venture of Aster DM Healthcare, a global healthcare group with 317 medical establishments across 9 countries, including the GCC, India and Africa. Committed to providing high quality, personalized medical care to every patient, Medcare lives by its simple promise: We’ll Treat You Well.
Medcare’s premium healthcare network includes four multispecialty hospitals (3 in Dubai and 1 in Sharjah), 4 specialty centres (in Dubai), 10 medical centres (9 in Dubai and 1 in Sharjah), and 350+ healthcare providers.
Cynosure has established a reputation for enabling business performance through its full suite of Enterprise IT services. However, within that Cynosure has its focus and specialization on areas like Microsoft business applications and Azure cloud infrastructure.
Cynosure was tasked with the responsibility of empowering the management of Medcare Hospitals and Medical Centres with the ability to access data being generated in real-time across all Medcare facilities.
Amandeep S. Mehta, Director at Cynosure, explains the customer requirement and the solution offered in more detail. He said, “The solution is known as Power BI. It is a tool from Microsoft that helps its users have more visibility of their data in the form of reports and dashboards. We engaged in a project with the Medcare Hospitals & Medical Centres here in the UAE as they are generating huge volumes of data so they wanted a tool that could empower them to analyze the performance of each facility and operational KPIs.”
The Microsoft Power BI solution enables the management of Medcare to access information ranging from how many walk-in patients they have, which doctor attended to them, what they were prescribed and what the billing and revenue was for the clinic as of yesterday. The unique component in this solution is that the management of Medcare have instantaneous access to all the information they needed without having to ask anyone for it, freeing their employees from additional administrative tasks.
Amandeep added, “When we started the project,
Customer Objective
Harnessing and understanding the data at their disposal
Formulated presentation of data through reports and
dashboards
Giving visibility and insight to make informed business decisions
Why Microsoft power BI?
Delivered actionable insights and analysis
Reliable and secure solution
Accessible across multiple devices
AT A GLANCE
OBJECTIVE: The objective of this project was to equip the Medcare Hospitals & Medical Centres management with access to all the data being generated across all the hospitals and clinics.
AMANDEEP S. MEHTA, CYNOSURE
Andre Daoud, CEO of Medcare stressed to us that the fundamental reason he was proceeding with this project with Cynosure is that he wanted the management of Medcare to have access and clarity to the performance of their business without having to call anyone within their facility. He wanted that information to be available to them on their mobiles, laptops and tablets. It’s the same interface across all devices so Power BI has the capability to deliver this requirement.”
“Agility is key to any industry and healthcare is no different, and to be agile you need the power of data. Without data you are just another person with an opinion. Numbers and data have a story to tell, and with analytics and great visualization key stakeholders are empowered to make informed decision, said Naushad Mohammed – General Manager of IT with Medcare Hospitals & Medical Centres.
Amandeep added, “The Microsoft Power BI platform is able to capture the billing system in realtime. Medcare will have access to comparative data and they’ve also got parameters that are coloured which indicate the status of their current business. This will enable them to make business decisions and actionable steps to respond to any insight flagged by the system. ”
One other important component in the Microsoft Power BI solution is the fact that it is 100% transparent and trustworthy.
He concluded by saying, “The important thing about the platform is that it is data that you can trust. Nobody can manipulate the reports that are being generated daily. There is no manual intervention allowed on the Microsoft Power BI solution. One of the biggest problems for large enterprises is that they may not be able to trust the data that is being relayed back to them? The past manual intervention on platforms has always created doubt about the data. However, with Power BI the data is 100% watertight and accurate.” n
How Cynosure did it?
Provided expertise and in-depth support
to ensure a seamless integration of the solution
Acutely understood the fundamental objectives of the client
Educated employees on the importance of harnessing data
CORE REQUIREMENTS: Easy visibility and access to the oceans of data that is being proliferated across all their facilities in a bid to assess the performance of individual hospital/medical centre and operational KPI.
SOLUTION IMPLEMENTED: Microsoft Power BI
WALID EL HADIDY, MANAGING DIRECTOR AT DATAPLUS, OUTLINES HOW THE BUSINESS-INTELLIGENCEFOCUSED FIRM DELIVERED A LARGE-SCALE DATA ANALYTICS PROJECT WITH TABLEAU SOFTWARE. THE GAME
PLAN
Egypt is one of the most populated countries in the Africa and Middle East region. Its current population is 100,752,498, according to the latest United Nations estimates. Tracking the number of births and deaths is crucial to planning government services in the country.
Based on the number of births, the government can plan schools, hospitals and other services. By gaining insights into the cause of deaths, the government can take precautions against infectious diseases and determine other factors. Also, rarely will a large percentage of death be found to be due to one particular reason; if this happens, then the government will know to investigate and ensure the details are being recorded accurately.
However, to be able to efficiently record and use this data across a large country like Egypt, the government will have to depend on sophisticated technology.
Egypt’s Ministry of Planning and Administrative Development approached Dataplus, an IT solutions provider focused on business intelligence and data analysis, to help create a national dashboard for the country’s birth and death database.
Carefully analysing the requirement, Dataplus was certain that Tableau Software was the ideal solution to address this challenge. Known as ‘Mechanization of Birth and Death Registration’ project, Dataplus together with the Ministry, began the work on proof of concepts (PoCs).
Walid El Hadidy, Managing Director at Dataplus, says, “We worked with the Ministry of Planning and Administrative development to create dashboards using Tableau Software for the birth and deaths system implemented all over the health regional offices in Egypt.”
The Ministry of Planning and Administrative Development is responsible for the automation and development of e-government services across all government entities.
“They have protocols with different government ministries to automate their services and business. One of the protocols was the Ministry of Health. While we were approached by Ministry of Planning and Administrative Development, the work was being done for the Ministry of Health.”
Hadidy highlights that working on a national project is very different from an enterprise one.
“This is because the value of the project delivered is seen across the whole nation,” he says.
Customer objective
To automate birth and death registrations
To create a dashboard that simplifies data monitoring
To gain insights to help streamline government services planning
To track exact causes of death and help take necessary precautions
Why Tableau Software?
Offered reliable and proven solution
Met all aspects of customer’s demands
Easily integrable components
Delivered insights accurately
WALID EL HADIDY, DATAPLUS
AT A GLANCE
OBJECTIVE: To develop a national automated dashboard to register birth and deaths in Egypt
CORE REQUIREMENTS: Easy visibility to number of births and deaths at any given time, have insights
Considering the size of the country, it was a challenging project. “We had to interact with health offices, which are scattered all over Egypt. The country has 27 governorates and each of them houses a number of cities and each city has a number of villages. The health offices are located near the 4500 plus village municipalities,” he explains.
Through Tableau Software and expertise from Dataplus engineers, the Ministry now had visibility to a detailed health board, housing all the required parameters over Egypt.
“The project was completed over a period of three to four months. We have worked on the map of Egypt, right up to the village level. We have helped the Ministry to automate the process, part of which includes delivering data into a dashboard. This data will further enable decision-makers to take actions and plan effectively.”
One of the main challenges that Dataplus faced was obtaining information on the map of the country.
“We needed to have X and Y coordinates for every village across Egypt. This was easier said than done. However, we managed to do it with the support of the Ministry.”
According to Hadidy, the map visualization capability of Tableau Software was innovative.
“Another challenge we faced was matching the names of villages in the maps against the dashboard. This is because some of the villages had really old names and some were repeated. A lot of data consolidation was needed, and this was possible thanks to the map visualization capabilities of Tableau Software.”
The implementation was awarded first place and golden shield in the Management Innovation Competition hosted by the African Organization for Public Administration. The event was held in Gaborone, capital of Botswana, from 5th to 9th November 2018 under the theme ‘Innovation in Public Administration’. n
How Dataplus did it?
Understood the challenges of the customer’s requirements
Worked on the PoC to create an automated dashboard
Enhanced implementation through in-depth support and technical expertise
into causes of deaths to take precautions against diseases and determine other factors, plan government services better for general public
SOLUTION IMPLEMENTED: Tableau Software
