Predictive analytics is the next step in BI: not only can you be retrospective and see what has happened in your company in the past, but now we can distill new information from the old information to actually predict what will happen in the future. Jamie MacLennan, CTO of Predixion Software, explains the difference between business intelligence and predictive analytics and shares a program that Predixion has created in Excel to review the Practice Fusion data.

With the confluence of easily accessible data sources and powerful and available business intelligence and predictive analytic tools, we've entered a new era where data itself has become the platform for new application development.  Taking advantage of real medical data made available on the Windows Azure Marketplace DataMarket by Practice Fusion, a useful and compelling application inside of Excel 2010 using Microsoft PowerPivot and Predixion Insight was stitched together in less than an hour.

The application dubbed "Prescription Finder" uses historical medical data to allow a physician to display the top 10 medications prescribed for any particular medical diagnosis or set of diagnoses through a simple and effective Excel-based user interface.  Going one step further, it allows the physician to explore possible contraindications by using predictive analytics to suggest related conditions that a patient may have so the physician can make the best choice for their patient.

Watch the video below to see how this application was built using PowerPivot and Practice Fusion data on the Azure Marketplace DataMarket

 

  Join the BI TV LinkedIn Group to stay up-to-date with all the new releases

 Take the latest poll:  How do you acquire data for your company?