Download - CRG VantageHealth
-
7/29/2019 CRG VantageHealth
1/13
CRG
VantageHealth
Business Profitability in a
Box
Corporate Renaissance Group
-
7/29/2019 CRG VantageHealth
2/13
2010 Corporate Renaissance Group 2
CRG VantageHealth: Healthcare Profitability in a Box
CRGs VantageHealth is a dynamic costing and profitability solution for Health Management organisations and is
part of CRGs VantagePoint portfolio of solutions . VantageHealth seamlessly combines the financial and
operational data and provides multi-dimensional insight into services, processes, activities and resource
utilisation. With VantageHealth, senior management can now make fact-based and informed decisions as it
provides:
A multi-dimensional end-to-end insight into the organizations profitability at the product class
(including channel) - client segment level
Performance of every service in the organization for immediate Business Improvement insights
Enhancement to divisional reporting
Consistent, transparent, and credible information
Simple and cost effective administration
The management information provided by VantageHealth will answer the following questions:
What is my cost-to-serve and is that good or bad?
How much are we spending throughout the organisation and how do I know we are getting
value for money?
I dont have the right information at the right time to support my decision making process.
Where do I start?
How do I fully utilize the existing IT systems, whilst understanding their cost and added value?
How do I create end-to-end cost transparency and awareness throughout the organization?
How do I create P&Ls on products and clients that will enable product managers to make the
right decisions and focus their efforts?
-
7/29/2019 CRG VantageHealth
3/13
2010 Corporate Renaissance Group 3
VantageHealth has two integrated components: a robust, flexible and enterprise scale costing engine,
FlexABMTM and TableauTM an exciting world-class multidimensional analysis and visualisation application.
VantageHealth also contains the FlexWebTM module to collect data over the web, which is not currently on
any system. An added benefit is that Tableau is a stand-alone rapid Business Intelligence (BI) development
tool that seamlessly integrates with most databases to provide added information without any technical (IT)
expertise required to generate ad-hoc reports. This enables management to access other data and
applications for better reporting and analysis.
VantageHealth provides:
Full tracking of resources to the activities that are being performed by various business units
and cost centres
Attribution of overhead costs to activities thereby providing the true cost of service delivery
End-to-end cost flow transparency from resources through activities/services to products and
clients
A typical process flow is shown in Figure 1
Figure 1: Process Flow
-
7/29/2019 CRG VantageHealth
4/13
2010 Corporate Renaissance Group 4
How does VantageHealth link Resources to Activities?
Once the financial data has been mapped to the activities, VantageHealth, through FlexABM imports the
financial data from the financial system. Employee effort is imported from the time management system or
captured through the FlexWeb module. The reports generated through Tableau will answer typical
questions such as:
What is the direct cost per process and activity?
What resources are being consumed by each activity?
What are the resources used and what are their associated costs within each business unit,
cost centre or work team?
What are the top 10 most costly activities?
What are the most expensive resources and where are they being consumed?
What are the Resource Drivers and their quantities?
Figure 2: Dashboard Visualising some Answers to These Questions
An unlimited number of multi-dimensional reports and dashboards can be created and presented as single reports or in
an executive briefing book. The dashboard depicted above shows at the top left the overall costs of the organisation by
Business/Support Unit. To its right the cost per activity for each cost centre is shown with full drill-down capability to
cost centre and activity level. The bottom right report shows the cumulative and total cost by activity. Annotations can
be included in the report or dashboard to enhance the communication and feedback process. The bottom left report
shows the Top 10 activities and as can be seen a mouse-over will provide additional information on each component
included in the report. No technical support is required to generate these reports or dashboards.
-
7/29/2019 CRG VantageHealth
5/13
2010 Corporate Renaissance Group 5
The True Cost of Providing Health Insurance Services
The direct cost model only shows how the various resource costs are linked to activities, which is an important
first step as it shows management exactly where they are spending their budget. However, what is more
important is that managers are made aware of the true cost of providing services to clients. It is here wherethe true power of VantageHealth, made possible by FlexABMs powerful calculation engine, is applied.
VantageHealth enables management to determine the true cost of services through accurate attribution of
overhead costs to the various services through the activities that are performed by the support and
operational entities within the organisation.
This functionality answers the following questions:
What is the total cost of providing services?
What is the unit cost of every activity output?
What proportion of the total cost of a particular service can be attributed to support services?
Where does this cost come from?
Figure 3 answers some of these questions.
Figure 3: Cost Visibility
The dashboard above shows the cost distribution associated with the various business units and activities within the
organisation. In the top left hand report, the question is asked where the external costs come from that are attributed to
the Maintain Systems activity. The report below it shows the answer. The two right-hand reports show the cost
distribution and it can be seen that the Application Development activity has the most costs associated with it... The
bottom report shows the total cost per business/support unit and the colours within the bars represent the departments
within the business/support unit. Legends are shown at the left of the dashboard and filters on the right hand side. All
reports are interlinked and an update in one will automatically update the others. The filters will also update all the
reports if so selected.
-
7/29/2019 CRG VantageHealth
6/13
2010 Corporate Renaissance Group 6
Unit Costs
Rising health costs are forcing both the public and private sector suppliers of health-related services to be more
effective an efficient with regards to the management and operation of these services. VantageHealth
provides health insurance organisations with the true unit costs of providing services due to the accurateway in which it attributes overhead costs to activities. Knowing the unit cost of services delivered will assist
healthcare managers to:
Align cost management initiatives accordingly and to institute best practices to reduce these
costs
Determine a pricing structure that is based on a true unit costs calculation
Attribute costs accurately to the various products and services rendered by the organisation
Figure 4 shows a dashboard consisting of two unit cost reports.
Figure 4: Unit Cost Dashboard
This dashboard shows the unit cost per activity for services rendered. The top report shows it in table format and the
lower one visualises the results making it easier for managers to see the cost comparison by activity as well as the
magnitude of the indirect costs per activity. The two reports are both linked to the filters embedded at the sides of the
dashboard. Once selected, only relevant descriptions will be shown making the filters part of the dashboard definition.
-
7/29/2019 CRG VantageHealth
7/13
2010 Corporate Renaissance Group 7
How Profitable are Services & Clients?
VantageHealth provides management with information on the profitability of all products, services and clients.
With revenue and cost information extracted from the financial system and linked to the operational systems
and data, VantageHealths costing engine calculates the profitability of all the services and products that theorganisation is providing, such as the profitability for customer segments, product groupings, individual
products and individual clients.
Figure 5 shows a profitability dashboard that contains examples of profitability reports.
Figure 5: Service and Client Profitability Dashboard
The profitability dashboard shows the cumulative profitability by client in the top report. The bottom left report shows
profits versus sales for customers by region and product category. The bottom right report shows a bullet graph of profit
versus sales by customer and product sub-category. Profits are represented by the blue bar and sales by the vertical line
at the end of each bar.
The power of visual analysis is clearly demonstrated in this dashboard. Bullet graphs are also a new way of displaying
information, they provide a lot of information in a very small space which makes them an excellent alternative for dials,
which take up a lot of space and say very little.
-
7/29/2019 CRG VantageHealth
8/13
2010 Corporate Renaissance Group 8
Showing the Business Footprint
VantageHealth, through Tableau, provides seekers of geographic intelligence with mapping visualisation
solutions that are easy to use and complete. No speciality map files, plug-ins, fees or third party tools are
required. Data is not only shown geographically but any of the dimensions and measures that are containedin the model can be projected on an embedded map. The user also has the ability to import custom maps
and geographic information. Full functionality in terms of data manipulation is possible.
Figure 6 shows an integrated visual dashboard containing geographical information focussing on profitability
information.
Figure 6: Linking Data to the World
This integrated dashboard is an excellent example of what VantageHealth can provide in terms of geographic
intelligence, combined with other operational data that normally resides on other systems within the organisation. The
top report shows the profitability by region and product over a span of four years. Changes in profitability and product
type over the years are clearly visible and it is possible to drill into a specific region or product. The bottom left report
shows sales and profitability by customer segment for each state. The right hand bottom report is a heat map showing
the profitability by region. The scale ranges from unprofitable (red) to most profitable (dark green). All reports in the
dashboard are interlinked and by filtering on one, the others will automatically be updated to reflect their information in
the same context.
-
7/29/2019 CRG VantageHealth
9/13
2010 Corporate Renaissance Group 9
Communicating the Information
VantageHealth through Tableau Server is an application that makes sharing live, interactive data visualizations,
dashboards, reports and workbooks fast and easy. With enterprise-class security and performance to
support large deployments and extract options that let you manage the load on your mission-criticaldatabases and cubes.
It deploys in minutes, and is easy to maintain. Users can publish and collaborate via a web browser or embed
Tableau views in other web applications. Business users can produce their VantageHealth and other reports
without the need of IT within the existing IT infrastructure. Users with Interactor licenses can interact, filter,
sort and customize views. Users with Viewer licenses can see and monitor views as published.
Figure 7: VantageHealth Reports Published on the Server
Features of the Web Server shown in the two figures are:
Share VantageHealth and other workbooks with anyone with a browser.
Deliver current data with every view.
Embed views in other web apps including Sharepoint.
Publish once - Server dynamically filters data based on whos viewing.
Set filters to limit the data in the view and page through slices of the data.
Sort, keep and exclude individual data values.
View details and export data and images.
Users see only data they are authorized to see.
Add explanatory notes, pose a hypothesis, ask a clarifying question, or just contribute an
opinion. Read comments to see the discussion happening on the data.
-
7/29/2019 CRG VantageHealth
10/13
2010 Corporate Renaissance Group 10
Publish interactive dashboards to the web.
Organize content in a way that best suits your needs by using tags.
Quickly identify interesting views by browsing thumbnail images.
Embed views in nearly any web app with just a URL.
Figure 8: Top 10 Customer Report with Quick Filters
-
7/29/2019 CRG VantageHealth
11/13
2010 Corporate Renaissance Group 11
Rapid-Fire Business Intelligence!
VantageHealth not only links the world to your data, it also seamlessly integrates with sixteen different data
sources without any programming being required. This is called, rapid-fire BI!
Rapid-fire BI is a self-service business intelligence approach that provides true business intelligence to
information users. It is much easier to deploy, administer and scale. It also allows users at all levels to ask
and answer questions themselves in a matter of seconds. Rapid-fire business intelligence lets business
users explore and analyse their data independently, while reducing the burden that heavy BI platforms place
on IT.
Rapid-fire BI has the following attributes:
It is user-driven The user creates the reports without IT intervention
Easy Visual Interfaces Results are visual and interactive. If people dont find the software
easy to use, they wont use the software. End of story.
Flexible Configurations
Single user, single data source or multiple users with multiplesources, the software handles it all.
High Performance -BI needs to run fast.
Easy Administration - IT can support the new BI application with existing staff and
infrastructure. No professional services (or fees) are required.
Figure 9: The Rapid-Fire BI Platform - From Data to Information on a Click
-
7/29/2019 CRG VantageHealth
12/13
2010 Corporate Renaissance Group 12
Summary
VantageHealth is an integrated solution for health management institutions with its core module providing
profitability and operational intelligence to business users. Further modules can be added that provide both
organisational and employee performance management and information, electronic Service LevelAgreements (SLAs), e-billing and Supply Chain Management (SCM) functionality.
However the power and uniqueness of VantageHealth lies in the robust calculation strength provided by
FlexABMTM and the flexible and easy to use reporting, analysis and visualisation capability of TableauTM,
which provides the WOW factor.
FlexABM is a proven, easy-to-use, enterprise-wide cost
and profitability solution that identifies the true cost of all
activities and provides decision-makers with the analytical
tools, models and methodologies to effectively evaluate
business processes.
FlexABM provides intuitive costing of activities and
processes, and is ideally suited to the services
environment. By utilizing a familiar drag and drop tree
structure, grouping and tagging, and roll up functionality,
data modelling is uncomplicated, yet extremely advanced.
FlexABM provides:
Unlimited modelling elements Group and tag activities with multiple roll-ups
Multi-level activity assignments and cost objects
Automatic attributions and activity driver weighting
Detailed models that accurately express
expenditures and use of resources across the
organisation
Models that incorporate revenue and profitability
Multi-dimensional reporting with any combination
of products, customers, or other dimensions
What-if Scenarios
With one of the most sophisticated, yet straightforward,
import wizards, FlexABM effortlessly allows you to import
the financial and operational data that is so vital to the rapid
and cost-effective implementation of any cost and
profitability system. Additional functionality includes:
Automatic data validation
Integrated view of cost/quality/cycle time
Incorporates costs as well as performance
measures
Populates models with data from a variety of
existing operational sources, such as ERP systems
Tableau Desktop is a software application that enables
anyone to analyse any kind of data quickly and easily. It
creates brilliant charts, graphs and other visualizations
with a few clicks of your mouse.
Tableau enables you to:
Extract actionable insights from raw data in a
matter of minutes.
Create visual tables of data to reveal relationships,
find patterns, and identify outliers.
Look at one factor a time or any number of factors
simultaneously.
Filters and zoom into data. Create Dashboards
Export vivid and beautifully annotated
presentations to other applications, including
Microsoft Office
Publish interactive reports on the Web to view
and interact with data using Tableau Server.
Tableau Servers functionality includes:
Intuitive filtering and sorting tools
Links that users can follow through a
recommended analysis path of related views. Links
can also invoke other web applications to display
related information
All Tableau Server visualizations can be exported
as images
Smart SearchTM capabilities
Control access and minimize IT management
Tableau Server is a complete solutionno other
prerequisite software is required. The only infrastructure
requirements are a Microsoft Windows environment, at
least one publisher using Tableau Desktop, and a web
browser. Users can be served analytical views using
Microsoft Internet Explorer 6+ or Firefox 2.x.
-
7/29/2019 CRG VantageHealth
13/13
2010 Corporate Renaissance Group 13
About Corporate Renaissance Group
At Corporate Renaissance Group (CRG), we have a single focus: driving better management and performance
through innovative solutions. And, we have been delivering results to public- and private-sector clients, both
large and small, around the world since 1989.
Our experience is wide and deep.
Our consulting services team is renowned for its expertise and experience in: strategy design and execution;
value creation; executive compensation; and costing and profitability analytics. We design all-encompassing
enterprise-level dashboards; business intelligence solutions; shared services strategies; and employee
performance management programs. Our implementations also leverage our own solutions FlexABM, Cost
Allocator, Shared Services Manager, and emPerform all deliver the best value for money in their class.
We pride ourselves on being go-to Microsoft experts for business solutions. We use Microsoft technologies to
help companies improve financial and operational performance and increase efficiency: Microsoft
Dynamics GP, SharePoint, PerformancePoint Services, Microsoft Dynamic CRM, and the MicrosoftBusiness Intelligence Suite of products. We also serve the Microsoft Dynamics GP community
through our products: Changer, AA Tools, QuickCubes, Re-Formatter, Reverser, and Merger
Series.
We have world-class software development capabilities and we have developed many customized solutions to
our clients. We are very proud of our software development centre, located in India. We customize business
applications to help our clients become world class performers; our over 3,000 satisfied clients are a
testament to our skill as software developers.
We are truly a global company with offices in Canada (Ottawa, ON; Toronto, ON; and St. Andrew, NB), South
Africa (Cape Town and Port Elizabeth), India (Pune), and the United States (Tulsa, OK) and affiliates in the
Caribbean and Europe.
Contact Us
CorporateHeadquarters
6 Antares Drive, Phase 1, Suite 200
Ottawa, Ontario K2E 8A9
Canada
tel: 613.232.4295
fax: 613.232.7276
e-mail: [email protected]
website: www.crgroup.com
South AfricaHeadquarters
9 Dolphin Drive
Blaauwbergrant
Cape Town
7441
tel: +27 21 557 5847
fax: +27 21 557 4180
e-mail: [email protected]
website: www.crgroup.com
IndiaHeadquarters
5 Ramagovind, Sahawas Society
Karvenagar
Pune 411 052
India
tel: +91 202 5457100
e-mail: [email protected]
website: www.crgroup.com
United StatesHeadquarters
7712 S. 232nd
E. Avenue
Broken Arrow, OK 74014
USA
tel: 918.357.9304
fax: 918.357.5374
e-mail: [email protected]
website: www.crgroup.com
mailto:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]:[email protected]