Helical IT Solutions Raises Funding

Hyderabad, May 6, 2013: Of the many IT start-up success stories there is a new one on the block to watch out for. Helical IT Solutions, a Hyderabad based technology company providing services in open source data warehousing and business intelligence services has bagged a seed funding of INR 2.5 million from Singapore based Citibank official within 6 months of starting operations.

The company which started in November 2012 from Hyderabad has catered to technology needs of clients in various domains including e-commerce, insurance, energy, social media analytics, healthcare and human resource while building and managing their Business Intelligence platforms.

The eight member strong team is quite excited with the fund inflow and plans to use it primarily for recruitment and partnering with leading BI vendors in the open source space such as Jaspersoft and Pentaho. They want to focus and build up their capability of providing sector specific BI offering with this fund.

Specializing in Open source technologies, Helical has proved to be a great bet for its clients cutting down on their costs and adding to their efficiency and turnover. Their services include Business Intelligence, ETL, Data warehousing and data modelling, data visualization to name a few.

About Helical IT Solutions :
Helical IT Solutions is an open source Data warehousing and Business Intelligence company based out of Hyderabad. The company works primarily on Jaspersoft and Pentaho BI suite and on talend, on Talend and Kettle. Other services provided are data visualization, data modelling, data warehousing etc.

Contact Person :
Nikhilesh Tiwari
Cell : +91-7893947676
Email : [email protected]

The companies funding news has been covered y many leading India based websites

http://www.watblog.com/2013/05/07/business-intelligence-startup-helical-it-raises-seed-funding/

http://www.vccircle.com/news/technology/2013/05/07/tech-startup-helical-raises-angel-funding-singapore-based-investor

http://www.iamwire.com/2013/05/data-warehousing-firm-helical-it-solutions-raises-angel-funding/

http://startupcentral.in/2013/05/helical-raises-seed-funding-from-spore-investor-22708/

http://www.dealcurry.com/2013057-Helical-IT-Solutions-Raises-Angel-Investment.htm

http://yourstory.in/2013/05/open-source-dwbi-company-helical-it-solutions-raises-angel-investment-worth-inr-2-5-million/

http://infotechlead.com/2013/05/07/helical-it-solutions-secures-inr-2-5-million-angel-funding/

http://www.nextbigwhat.com/helical-technology-solutions-funding-297/

http://www.dealcurry.com/2013057-Helical-IT-Solutions-Raises-Angel-Investment.htm

http://www.siliconindia.com/news/startups/Helical-IT-Solutions-raises-Rs25-million-In-Angel-Investment–nid-146582-cid-100.html

http://startupcentral.in/2013/05/helical-raises-seed-funding-from-spore-investor-22708/

Giving Hyperlink to text field.. Row banding implementation in Jasper iReport

Sometimes simple things might take lots of time….

Here is the tutorial …..
I’m using the following versions : iReport-Pro .5.0, Japserserver CE, Database : foodmart database in postgre SQL.
I’m using two reports
i) hyperlink
ii)hyperlink_second
I’m gonna show how we can give hyperlink in one report and how we will navigate to another report.
And How to give row banding in iReport?

In Report 1:
Step 1: Connect to database (Click on database icon and give all the details and test it )
Step 2: delete all the not needed bands(If we don’t delete it leads to page gaps in the output)
Step 3: Write a simple query in Report Query area ( Just right click on report name in the
Report Inspector then Select the query)
I’ve given like this : select 1 as One
Step 4: The bands I’m interested to take are : Column header and Detail bands respectively.
Step 5: Drag and drop the field to detail area And drag and drop a text field from palette to
column header.
The below image gives somehow idea.

Hyperlink to text field and Rowbanding for fields

Step 6: Giving Hyperlink to text field
i) Write text in double quotes like : “Hyper link”.( Text field should take double quotes whereas static text field doesn’t take double quotes and doesn’t applicable to create hyperlink)
ii) Right Click on the text field ->Click on Hyperlink-> It opens a window
see the sample in the following image

Hyperlink2

iii) Give Hyperlink target as : Blank
Hyperlink type as : ReportExecution
iv) Click on Link Parameters.. Give  Link parameter name as : _report
Parameter Class Name as : java.lang.String
Value Expression : location/Path of the second report in the server
for example the path is : “/reports/Demos_Sadakar/HyperLinkDemo/Hyperlink_Report2”
We can observe the location in the below image

Hyperlink3

NOTE : Remember that Hyperlink_Report2 in the URL is the ID of the jasperReport when we give at the time uploading report to server.. i.e, it is not the name of the Report.

 Hyperlink4

Step 7: Now save the report and upload to the server(Hope we know how to upload a report to server. Please find how to upload a report to server in the list of posts of my blog)

In Report 2:( A normal report with row banding functionality)
Step 1: Create a report and write query in query area
(Give same database details.. foodmart details)
I have taken this query : select * from employee
Step 2: Just drag and drop fields from Fields node of Report Insepector to Detail band.
( dragging only few fields)
Step 3: Now we are working on row banding.
i) Go to Report Inspector panel
ii) Right click on  Style option and Add some style.. I’ve given default name as style1
iii)Right click on style1 and select Add Conditional Style
iv) Now double click on it and i’ll open Expression Editor.. there we need to give the follwoing condition
new Boolean($V{REPORT_COUNT}.intValue() % 2 == 0)
In the above expression $V{REPORT_COUNT} is the default variable provided by jasperians in iReport. Check variables in the Report Insepctor.

Hyperlink5

v) Go to the properties of Conditional Style expression it opens it’s poperties( not click on Style1.. click on the conditional thing). In the properties window select give your favourite BackColor.
I’m showing the scenario in an image.

Hyperlink6

NOTE: do not check Opaque check box. just leave it.

Step 4:  Now select the fields you want to apply for the fields. I’ve selected all the fields that I’ve dragged to the Detail band. You can observe the multiple Objects properties window on the right side.
From the properties go to style and give the style1( just click on it it’ll show all the created styles.. In our example we have created only one style i.e, style1)

 Hyperlink8

That’s it. Now save the report and see the output of the report in the server . It’d look like the following

Hyperlink9

Execution of the Reports using hyperlink- Final Output.
NOTE : When we create an hyperlink and if it works fine then the color of the text changed to light blue and it’ll have underscore on mouseover.

First Report Output:

Hyperlink10

 Now click on “Hyper Link” that we are seeing on..

It’ll redirect to another page which we call it as hyperlink functionality in iReport.

Hyperlink9

🙂 🙂
Thanks for your time to read this tutorial 🙂 🙂 🙂
for any queries :  [email protected]

How is BI driving Data Decisions

In today’s world, companies use various software like ERP, HRM, CRM, Tally, Salesforce, Web services, etc. There are different databases like MySQL, Oracle, DB2, Ingres, Postgres, MongoDB and the list goes on. Data generation is rapidly growing with collation of personal data, financial data, sales data, business data, accounting data, so on and so forth. Though, there are different software and databases, but the missing element at this point is an insight on the information.

There is a need for centralized location, where one can login and view current news and updates. This location will be like a storehouse of information, collated from various location and data. For a profitable business establishment, numerous parameters and accurate information are required by the managers to achieve the right decision for the growth of an organization. At this point, business intelligence plays a pivotal role in providing accuracy in information and views to profitable paths.

Business Intelligence (BI) refers to technologies, applications, and practices for collection, integration, analysis, and presentation of business information. The purpose of BI is to support and improve business decision-making. A proper BI system helps with right information, at the right time, in the right format.

A single BI could help all the departments like:
1. Marketing Department – Helps in growing its top-line with features like analyzing campaign returns, promotional yields, and provide solutions to expenditure for profitable ROI, and tracking social media marketing
2. Sales – Finding the best path and practices, customer acquisition cost, and improvement in yearly turnover and sales
3. Inventory – Monitoring and adjusting inventory levels
4. Human Resource – Tracking and managing employee turnover, attrition rate, recruitment process, etc.

Correct usage of BI has shown excellent results in all the sectors, be it healthcare, e-commerce, NGO, government, media domain, etc.
– On an average, ROI is $10.66 for every $1 spent on business analytics
– Moneyball movie guided by BI was nominated for the best picture
– FEBREZE marketing campaign was aided by BI, sales now hit over $1 bn annually
– Correct usage of BI can help in reducing OPEX by up to 50%
– FT used high-end BI functionality to see a growth of 20%
– The US government uses BI to assign tasks to the police personnel

Main Elements of BI are
There are many parameters on which BI tool are tested before selection

– Interactivity :- The various reports and dashboards should have high level of interactivity. Let say, if a person is viewing the total sales report, the report should be interactive and navigable so that one can drill down to view specifications like product sales, time period, etc.

– Data Visualization :- It is important to have an accurate format for data visualization. For example, month on month sales would be represented in the form of line graph, component wise contribution would be displayed in the form of pie diagram, etc. In case, the data is not represented in accurate format, drawing conclusion on the basis of unorganized format will lead to open ending decisions. Any BI tool should have really good data charting engines integrated with it.

– Connection to databases :- As explained earlier, BI tool has the ability to fetch information by connecting to different databases and webservices so that the right information is provided to the stakeholders. This can be implemented by the right ETL tools which are an additional part of BI tool.

– Mobile BI :- Increase of mobility among the workforce, is raising demands to create a space for information on mobile phones, tablets, and other such devices. Hence, the reports, dashboards, mashups, etc are being rendered to compatible with on the go devices.

– Ad-hoc Reporting :- Usually the requirements of a business user and an IT person differs on a large scale. This elongates the development cycle which creates a requirement for ad-hoc reporting. It helps the end users to drag, drop, and configure their own set of reports, visualization, and analysis as per their requirements from the dashboard.

– Application Integration :- BI tool is an easy integrable device, which is compatible with existing application/portal/software irrespective of its developed software of PHP, Java, Ruby, C or any other platform.

– Predictive Analytics :- By using high-end algorithms and using historical data, predictions can be made like propensity of a customer purchase and his return, machine failure, sales expected, revenue expected, region wise sales, etc. With this system adaptation, a company is set to be more proactive.

Apart from the above mentioned, there are other factors like speed, in-memory analytics, cloud BI, and security to name a few.

BI is an essential tool for companies to take concrete measures in their growth and decision-making aspects.  According to a survey, if a decision is made relying on data rather than pure intuition, the chances of succeeding are 79% higher. BI gives companies a more structured way to look at data while providing deep interpretations. It aids decision-making via real-time, interactive access to and analysis of important corporate information.

BI tools bridge the gaps between information silos of an organization. A company, which is not driven by metrics, might not be able to understand the problematic areas, whereas a company with BI has the capacity to access industry information and insight to the problem, and based on the data, a plan can be worked towards improving its business processes.

(Article taken from my original article published on Dataquest magazine – http://www.dqindia.com/dataquest/column/186915/how-bi-driving-data-decisions/page/1)

Jaspersoft V/s Pentaho – Which one to use & Is there any need to purchase Commercial Edition?

Jaspersoft V/s Pentaho – Which one to use & Is there any need to purchase Commercial Edition?

Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same companies are caught up in an imbrogilo as to which tool to use, what are the technology/and end business user wise differences/ do i actually need to purchase commercial edition, is there any work around etc.

Differences :- In the below mentioned points, I have tried to cover functionality wise the differences

a. Reports :- Jaspersoft is known for its picture pixel perfect reporting. Jasper uses ireport for designing the reports. Hence, for having reports, Jaspersoft is the most ideal candidate. Pentaho uses Pentaho Report Designer.

b. Dashboards :- Pentaho provides much more capabililties, interactivity in terms of dashboards. Dashboards designed in Pentaho are far more superior in functionality, aesthetically as compared to Jaspersoft. Pentaho CE uses CDE/CDF, Pentaho EE uses PDD . Dashboard functionality is present only in the Enterprise edition of Jaspersoft.

c. Pentaho is having an intermediate layer known as Xactions & hence providing much more flexibility in terms of plugin designing, integration with applications, having out of box experience etc. Xactions supports scripting and scheduling of scripts execution. Jaspersoft dosent provide that much of flexibility in terms of intermediate layer, but never-the-less, Jasper server by default comes with some functionalities like scheduling, for plugin desiging they rely on ireport plugins and Jasper server plugins,

e. Mobile BI compatibility :- Jaspersoft scores higher than Pentaho here. They have BI for iOS, Android platforms. Functionality wise and user interface wise Jaspersoft mobile BI is better. They even have an opensouce Apple iphone application. Pentaho users have to often rely on third party tools to enhance mobile BI experience. But, Jasper provides native mobile API hence helping developers to create mobile applications. Pentaho mobile BI is only present in the enterprise edition.

f. Documentation : Jaspersoft invests a lot of time in documentation. Its pretty evident from that fact that they are having different case studies of the different clients on their website, explaining how Jaspersoft has helped them.

g. ETL : Jaspersoft uses Talend and Pentaho uses Pentaho Data Integrator (Kettle) as their default ETL tools. Kettle is developed by Pentaho organization itself unlike the case of Jaspersoft which uses Talend Open Studio version with some functionalities missing.

h. OLAP Analysis : Both Jaspersoft and Pentaho uses Pentaho Mondrian engine in their BI suite, and it goes unsaid which one will be stronger in this case.

i. Community support : Community support is more in Jaspersoft as compared to Pentaho. Also, the community members are more active of Jaspersoft community, hence if you are using CE, the chances of problem resolution is much more.

j. Plugin : Pentaho is having many plugin which are ready to use like CDE, CDF, Saiku etc. Pentaho is having a highly active community for plugin designing. Pentaho server by default comes with marketplace (just like appstore). Jaspersoft is a late entrant in this field and is currently having very limited plugins till now. They have also started Jasperexchange for their plugins.

k. Data Mining : Pentaho is having data mining module named Weka and Jaspesoft uses R. Again Weka is developed by Pentaho itself unlike the case with R. But toolwise, R is more advanced and more capable as compared to Weka

l. Big Data : Both Jaspersoft and Pentaho provides big data integration services.

m. Unlike Jaspesoft, Pentaho provides a much more tightly integrated BI suite since it has itself developed most of the components.

n. Jaspersoft EE has fusionchart integration. The latest version of Jaspesoft 5.0 EE is having Highcharts integration with it. Pentaho has open flashcharts integration. For geographical charting, Jaspersoft is having mapbox pro whereas Pentaho is having google maps.

o. Summarizing Jasper has a heavy focus on reporting and analysis. It has a better web 2.0 user interface than Pentaho and is generally easier to use. It benefits from better marketing, informational web sites, and documentation. Overall, it makes researching and finding what users need easier than Pentaho. Whereas Pentaho focuses on data integration, ETL, and workflow automation. It has a user interface that is more difficult for business users than is Jasper’s. The

documentation is also less robust than its competition. On the other hand, it has

strong data mining tools, ETL, flexibility via Xactions.

Which BI tools is to be used, whether enterprise edition has to be purchased or is there any other way out (like best of breed solution of different BI suites, plugin development, data visulization charting engines integration etc) – all these things can only be ascertained by a thorough discussion between the company and the solution provider. Its generally ideal to go and have a consultation with a company having exp in different BI technologies which will be able to give a comprehensive picture and can help the client towards business objective, rather than trying to push their software. Please get in touch with us for Jaspersoft, Pentaho, Data warehousing, ETL or any other DWBI related requirement – [email protected]

Radar Charts (Spider Chart)

RADAR CHARTS (SPIDER CHART)

What is Radar Chart? A radar chart graphically shows the size of the gaps among five to ten performance areas. The chart displays the important categories of performance and makes visible concentrations of strengths and weaknesses. The relative position and angle of the axes is typically uninformative. Radar charts are visually striking, and can add interest to what would otherwise be a dry data presentation.

Generally used with

– To visually depict the incremental improvements over a period of time

– To measure performance against benchmarks

– As a visual snap shot of progress over several criteria

Caution?

The following points need to be kept in mind while designing Radar charts.

– Also, with many data points, it becomes difficult to identify the values. In those cases, petal charts are used.

Industry Specific Example?

– Used to plot a players weakness & strength

– Control of quality improvement to display the performance metrics of any ongoing program

– Comparing various cars based on their fuel efficiency, manoeuvrability, pick-up and engine power

Marimekko Charts – Data Visualization

MARIMEKKO CHARTS

What is Marimekko Chart? A Marimekko chart is a two-dimensional 100% chart, in which the width of a column is proportional to the total of the column’s values. Data input is similar to a 100% chart, with data represented as either absolute values or percentages of a given total.

Marimekko charts are widely adopted in Marketing for example to analyze customer segmentation and market segmentation.

This graph encodes two quantitative variables: one using the height and one using the width of the bars. For example – By attending to the heights of each bar segment, we can see what percentage of each company’s total sales were handled by each of the three sales channels. By attending to the widths of the bars, we can see the relative magnitudes of each company’s total sales. Each company’s sales in each individual channel is encoded through the areas of the rectangles (that is, the individual bar segments).

For instance, comparisons between Reebok’s U.S. sales and Adidas’ International sales can be made by comparing the areas of the two rectangles that represent them.

Caution?

The following points need to be kept in mind while desiging Marimekko charts

 – Bars should be of the same heights

– Values in the columns to be preset in the percentage format

 Disadvantages of Marimekko Charts?

– Viewing graph as a whole is fine & reveals a lot of insights, but when we want to make comparisons between individual specific boxes, that is generally difficult.

– Marimekko graphs suffer from a problem that plagues any stacked bar graph: It is difficult to accurately make comparisons of the width or height of boxes that are not arranged next to one another along a common baseline.

Industry Specific Example?

– Generally used for marketing analysis all competitors in a particular market segment and individual share of competitors in each of the market segments. For ex – market share of three mobile handset makers (Nokia, Samsung, Motorola) in three segments (feature phone, smart phone, basic phone) and the share of each segment in the market itself using Marimekko charts

BUBBLE GRAPH / BUBBLE CHART

BUBBLE GRAPH / BUBBLE CHART

What is Bubble Chart? A bubble chart is used to visualize a data set with 2 to 4 dimensions. The first two dimensions are visualized as coordinates, the 3rd as color and the 4th as size. Bubble charts can facilitate the understanding of social, economical, medical, and other scientific relationships.

Bubble chart is often considered as an extension of scatter chart with the size & color factor also being introduced.

Caution?

Human visual system can feel the difference in the size, but with change in the radii (3rd dimension or variable), the corresponding change in the area is non linear. Hence proper care must be taken so that the change in the area is liner by mathematically altering the change in the radius according to the variables value.

Industry Specific Example?

– Project management to compare the risk and reward among projects. In a chart each project can be respresented by a bubble,the axis can represent the net present value and probability of success and the size of the bubble can represent the overall cost of the project

– Revenue contribution from different products & sales

Example of a Bubble Chart Usage

Pie Chart – Data Visualization

PIE CHART

What is Pie Chart? A pie chart (or a circle graph) is a circular chart divided into sectors, illustrating proportion. In a pie chart, the arc length of each sector (and consequently its central angle and area), is proportional to the quantity it represents. When angles are measured with 1 turn as unit then a number of percent is identified with the same number of centiturns. Together, the sectors create a full disk. It is named for its resemblance to a pie which has been sliced. The size of the sectors are calculated by converting between percentage and degrees or by the use of a percentage protractor. The earliest known pie chart is generally credited to William Playfair’s Statistical Breviary of 1801.

When to use :

Its recommended to be used when a piece is to be compared with respect to the total.

Pie charts work particularly well when the slices represent 25 to 50% of the data, but in general, other plots such as the bar chart or the dot plot, or non-graphical methods such as tables, may be more adapted for representing certain information.

Do the parts make up a meaningful whole? If not, use a different chart. Only use a pie  chart if you can define the entire set in a way that makes sense to the viewer.

Are the parts mutually exclusive? If there is overlap between the parts, use a different chart.

 

 

 

 

 

 

 

Difficult to compare individual pieces

Do you want to compare the parts to each other or the parts to the whole? If the main purpose is to compare between the parts, use a different chart. The main purpose of the pie chart is to show part-whole relationships.

How many parts do you have? If there are more than five to seven, use a different chart. Pie charts with lots of slices (or slices of very different size) are hard to read.

– While designing pie chart, make sure that slices are mutually exclusive; by definition, they cannot overlap. The data therefore must not only sum up to a meaningful whole, but the values need to be categorized in such a way that they are not counted several times.

Research suggests that we look at the angle in the center, essentially reducing the chart to just the crossing lines there. We are not very good at measuring angles, but we recognize 90 and 180 degree angles with very high precision. Slices that cover half or a quarter of the circle will therefore stand out. Others can be compared with some success, but reading actual numbers from a pie chart is next to impossible.

Industry specific examples of Pie Chart Usage :-

If a company has five divisions, and the pie chart shows profits per division, the sum of all the slices/divisions is the total profits of the company.

Pareto Chart – Data Visualization

PARETO CHART

What is Pareto Chart? Pareto chart is a data visualization tool which contains both bars & line graphs. In this, individual values are represented in decreasing order by bars & the cumulative total is represented by the line. Its named after Vilfred Pareto, an Italian economist and sociologist who conducted a study in Europe in the early 1900s on wealth and poverty. He found that wealth was concentrated in the hands of the few and poverty in the hands of the many. The principle is based on the unequal distribution of things in the universe.

Pareto Chart Example

When to use : Whenever we are having a number of factors, then pareto chart is used to highlight the relative importance (since the bar graphs are also arranged in decreasing order).

See the typical use cases highlighted below

– Used in customer care to show the most coomon customer dis-satisfaction factors

– Can be used in quality control to show common source of defects

The Pareto chart is generally used to you focus your improvement efforts on those issues that: 1.) Cost the most or 2.) Pose the highest risk / liability or 3.) those areas that occur the most often.

Dos & Donts :

If used properly, pareto chart can help a lot in understanding the key factors. The below mentioned factors are to be kept in mind & if used in conjuction, can provide a lot of actionable insight

a. Sub division :- It means, lets say at a customer care post using pareto they have found out that from a specific location maximum complaints are coming. Now, ideally they should further design a pareto for that specific location to get more insights (like in some cases there might be some complaints from a specific part of location because of some miscellaneous factor etc)

b. Multi-perspective analysis :- We should also do a multi-perspective analysis for ideal insights. For examples – if we take above case, not only they should do an analysis location wise but also reason wise & service wise etc. This might give them specific reasons for specific locations & hence counter measure can be taken to sort out the matter.

c. Repeast Analysis :- This depends on case to case or industry to industry basis, but based on their true knowledge & how they think the data dynamics are changing, the pareto charts should be updated & redesigned.

This is generally know as first level pareto analysis, second level pareto analysis (this is pareto analysis of the first bar of first pareto analysis) & third level pareto analysis (this is pareto analysis of the first bar of second pareto analysis)

Industry specific examples of Pareto Chart Usage :-

Below mentioned are some of the real world example usages of Pareto chart usage in industries & business organizations for data visualizations & analysis

  • Marketing – Where are the majority of my advertising dollars going? Which channels produce the most sales leads?
  • Healthcare – What types of infections are the most prevalent? What procedures are associated with the majority of return hospital visits?
  • Sales – Does a small percentage of customers account for a large percentage of revenue? If so, which ones?
  • Customer Service – How can I improve customer satisfaction? What do customers complain about the most?
  • Manufacturing – What defect types are most prevalent & key to improving an inspection process etc

Importance of Business Intelligence in Healthcare

What is Business Intelligence

To turn any business establishment profitable, the managers & the work force is highly reliant on decisions & those decisions are dependent on the kind of information available. This is where Business Intelligence comes into picture

Business Intelligence (BI) refers to technologies, applications and practices for the collection, integration, analysis, and presentation of business information and also sometimes to the information itself. The purpose of BI is to support better business decision-making.

BI systems provide historical, current, and predictive views of business operations, most often using data that has been gathered into a data warehouse or a data mart and occasionally working from operational data. Software elements that make up the BI system support reporting, interactive “slice-and-dice” pivot-table analyses, visualization, and statistical data mining.

Importance of BI in healthcare Industry :-

Today, healthcare establishments are also generating a lot of data (Data in healthcare – e.g., encounters, labs, pharmacy, membership, finance, claims, billing, CRM, EMR, HMS, etc). Though, they have lot of data, but information is very less.

There are three broad categories of data that any healthcare organization is interested in : financial, operational & clinical. Healthcare organizations must apply business intelligence to organize clinical, business and operational data for decision-making purposes. This data is used to support programs like disease management, outcomes management, clinical performance and process improvement, cost and waste reduction, quality accreditation and predictive analytics.

Forward-thinking healthcare organizations realize that data—and, thus, business intelligence (BI)—is at the center of informed and precise decision-making that will improve patient and service outcomes in addition to ensuring their organizations’ future, thus, many leading hospitals have already adopted BI

  1. Harvard Medical School, St. Jude Children’s Research, CIBA, & Mutual of Omaha
  2. Blue Cross Blue Shield of Florida
  3. Columbus Children’s Hospital
  4. St. Joseph Medical Center & St. Joseph’s Hospital
  5. International Federation of Red Cross & Crescent
  6. St. Luke’s Medical Clinic, Houston Infectious
  7. Diseases Associated
  8. Denver Health and Hospital Authority (BI is especially crucial to “avoid both waste and having patients fall between the cracks)
  9. Lincolnshire Partnership Foundation Trust (plunged into BI because of a specific need to better analyze the efficiency of its service lines)
  10. Hartford Hospital
  11. Nemours
  12. Hospital for Sick Children in Toronto
  13. University Health Network

Benefits of using Business Intelligence in a healthcare establishment :-

a. Consolidation & protection of data since there would be a single point access of data Better protection of patient data is also possible by providing access to data only to those with appropriate access levels.

b. Improved Efficiency :- Since any type of information & report, whichever is required at any time. This will enable better decision making and improved efficiency

c. Increased revenue & reduce costs :- BI makes it possible possible to eliminate waste and mine data stores to examine and recoup denied claims in healthcare organizations. Costs of: healthcare professionals, lab equipment and consumables, pharmaceuticals/ medical material, treatment per diagnosis and cost per type of medical intervention (e.g. specific medical operation) can be reduced as well

d. Improved Margins :- BI (BI/balanced scorecard program) helps to improve gross margins of healthcare organizations.

e. Improved patients satisfaction by using BI and analytic tools.

f. Improved Patient Treatment & Care :- Through the use of BI, healthcare professionals have easy access to patient’s data and they can create a variety of classifications/reports based on demographic data, sex, age, and so on. Thanks to the evidence based medicine and capture of medical history of the patient doctors can accurate diagnosis and apply efficient treatment with reduction of risks during treatment (e.g. related to on time admittance, the use of medicine, biomedical equipment, blood transfusions). Timely and effective clinical decisions are better facilitated by increasing the potential of BI.

 g. Reduction of medical errors and improved patients safety. It could be reached by supporting medical research and data treatment. BI systems can support a larger Healthcare system, by the exchange of medical information on a patient. Improved decision-making in the area of comprehensive health care policy by the authorities of the organization of the health sector. It can be reached with monitoring the performance of doctors, departments and medical material requirements. Multiple groups or individuals can be put together by emphasizing the analysis and accurate data, which brings them closer to the point of service in order to enhance decision making & make data actionable.

h. Better data management helps in better patient treatment in terms of timely admittance, diagnosis and risk in casualty.

i. Some other benefits includes supply cost optimization, fraud detection

Main KPIs & Performance Indicators

The main KPIs which can be used to be displayed via reports & dashboards are mentioned below.

Clinical Data KPI

Healthcare establishment can improve clinical quality and resource utilization by effectively monitoring and measuring clinical performance and outcomes data. By delivering analysis from multiple sources at once, BI enables organizations to track large amounts of information stemming from clinical activities and identify the most efficient practices. BI helps providers identify trends and anomalies, and analyze risk in clinical care. With a lot of stakeholders involved like doctors, diagnostic centers, pharmacy etc all of them cant function as independent silos. With BI, all constituents can work from the same data over a secure extranet with information personalized based on security credentials. BI’s unique centralized administration and role-based security assures that healthcare providers have security measures at every layer of the architecture. With secure, essential clinical information, individual practitioners can diagnose and prescribe more quickly and provide top quality care with greater peace of mind.

The different types of reports permissible are

Avg cost per case Clinical outcomes
Cost & clinical data Cost affectiveness
Disease management In-patient admission rates
Investment in research programs No of procedures vs benchmarks
Patient safety & staffing Performance reporting
Population risk Resource cosumption vs benchmark
Response time Treatment

Patient Care KPI

Healthcare providers want to offer the highest-quality patient care in the most efficient way possible with improved patient access to care. BI enables the right people to access the right information at the right time, delivering a single platform to healthcare providers for sharing information with patients for better decision-making and connecting patients across hospital, nursing home, physician office, and community social support settings. By providing easy, secure access to crucial information, BI supports safe care delivery, assists clinicians in evidence-based clinical decision-making, and facilitates seamless care coordination across clinical settings. Providers use BI to monitor patient diagnoses and use of healthcare services in order to improve patient care, reduce wait times, and administer more effective treatments.

Clinical Outcomes Day to next appointment
Dispatch request & monitoring Patient functionality
Patients wait time in admission Patients wait time in pharmacy
Service complaints Service Level Agreement reporting
Services performed Timeliness of service

Financial KPI

Healthcare organizations need visibility into the full scope of their financial operations. BI provides full transparency, analysis, and delivery of financial and operational data. BI enables healthcare providers to drill from reports into detailed analyses of costs and revenues, view data underlying cash flow statements, and compare planned versus actual income and margin. BI’s analytical capabilities allow providers to analyze current care practice patterns to identify unnecessary or under-utilized services, execute cash flow analysis, forecast collections, and monitor underwriting requirements. In addition, BI enables healthcare organizations to meet statutory reporting requirements and ensure accountability from financial analysts to business unit management, executives, and directors.

Accounts payable Accounts receivable
Accrued expenses Assets in current vs prior period
Bad debt as % of net revenue Budget variance analysis
Capital expenditure growth rate Cash & equivalents
Cash collected vs target Cash on hand
Current asset turnover Current Ratio
Customer Plan migration Net assets
Net income Operating margin
% of capital expenses % of cash flow to total debt
% of cash flow to total liabilities % of charitable revenue
% of debt to capitalization % of out patient revenue

Quality & Performance KPI

Providing safe, quality care is a top priority for healthcare organizations. BI allows providers to improve performance by leveraging evidence-based performance data, tracking variations in quality, providing patient dashboards, setting alerts, and checking drug interactions. Providers can use BI to monitor the quality of their care according to the Health Plan Employer Data and Information Set (HEDIS) standards established by the National Committee for Quality Assurance to allow for performance comparisons across quality, patient access, patient satisfaction, utilization, and financials. Additionally, Dashboard can be used for improving quality at healthcare organizations, which empowers managers to make more timely decisions and participate in on-the-spot quality improvements. BI allows providers to identify the presence or absence of interventions recommended by evidence based medicine.

Dose Frequency of attacks
Handling costs Avg length of stay for patients
Length of visit with nurse practitioner Length of visit with physician
Medication error Monthly drug cost
% of follow ups No of emergency room visits
No of hospitalizations No of patients admitted
No of patients referred outside No of patients with infections
No of patients with vaccinations No of physicians visit
Packaging cost Patients satisfaction

Marketing KPIs:-

With a No. of hospitals, clinics & nursing centers, healthcare providers must place a greater focus on their marketing efforts to stay competitive. BI helps analyze the success of marketing efforts designed to demonstrate the clinical effectiveness of their products and services, create an increased feeling of overall wellness, and reduce workplace absenteeism. BI also allow providers to determine the most cost-effective marketing techniques by tracking campaign costs against budget, calculating the return on investment for campaigns, and comparing performance against goals. In addition, BI allows healthcare providers to use dashboards to show which products and services are profitable in specific patient segments and measure how their marketing efforts and corporate communications alter brand perception and affect brand performance.

Acquisition Advertising budget per procedure
Avg visit length to website Brand Management
Churn Analysis Customer Profitability
Customer Segmentation Demographic Analysis
Loyalty Program Market Share by Business
Marketing Focus group scores No of visit to website
Patient satisfaction Physician practices
Preference & permission bundling Retention

Above mentioned are some of the commonly used KPIs. Keeping a tab on them via selecting a proper Business Intelligence tool & correct implementation, can surely help them to rise above the competition & deliver a world class service to the patients.

For any query regarding Business Intelligence implementation, plz mail [email protected]

Nikhilesh

+91-7893947676