11 BI Tools to Analyze Healthcare Operations

11 BI Tools to Analyze Healthcare Operations
http://www.informationweek.com/news/galleries/healthcare/admin-systems/240001004#

However, most of the tools here looks expensive...

What are the useful resources which I refer while trying out AWS?

• Referring this  https://help.ubuntu.com/11.04/serverguide/mysql.html
• On how to start,stop mysql in ubuntu
• Referring this  http://www.keywordintellect.com/tutorials/amazon-ec2-scalable-web-hosting/
• Scalable web hosting with Amazon EC2 including launch instance, using putty with EC2
• Referring this  http://www.techsww.com/tutorials/database_management_systems/mysql/installation/how_to_install_mysql_client_ubuntu_linux.php
• Instructions for installing mysql client on ubuntu
• Referring this  http://www.wikihow.com/Install-Oracle-Java-on-Ubuntu-Linux
• Instuctions for installing Oracle JDK
• Referring this http://blog.peterdelahunty.com/2009/06/deploying-grails-app-on-ec2-in-from.html

• Download the Firefox plugins
• Instructions for starting baseline Linux image
• Instructions for installing Tomcat, mysql
• Referring this http://codingthis.com/applications/uploading-files-to-your-amazon-ec2-server-using-winscp/

• Using winscp with Amazon EC2
• Referring this http://hoodbook.wordpress.com/2009/10/13/into-the-cloud-migrating-my-apachejbossmysql-applications-to-amazon%E2%80%99s-ec2-part-ii/
• Get an Elastic IP
• Running JBoss on Amazon EC2
• Referring this http://matthom.com/archive/2012/03/26/using-amazon-rds-for-mysql-in-the-cloud
• Setup mysql on Amazon RDS
• Referring this  http://seamframework.org/153035.lace
• Setup JBoss 4.2.3 Mail service for Amazon SES
• Referring this  http://ubuntuforums.org/showthread.php?t=1696998 
• Setup build-essentials to compile swftools
• Referring this  https://designbye.wordpress.com/2010/02/23/installing-swftools-and-pdf2swf-on-ubuntu-linux/
• Remember to do this: sudo apt-get install --reinstall zlibc zlib1g zlib1g-dev 
• Setup swftools and pdf2swf on ubuntu

What Useful Resources for Pentaho BI CE?

SagoBI looks complex and it takes time to get familiar as compared to http://art.sourceforge.net

I proceed to try out Pentaho BI CE instead, here are the resources I have adopted in my journey:

Suites and Plugins

• This post got the latest update (CE 4.5). This post provides very comprehensive checklist for all the things to be install:  http://interestingittips.wordpress.com/2011/04/27/complete-pentaho-installation-on-ubuntu-part-1/
• Pentaho BI Server CE 3.7 setup but the step-by-step modifications to be perform on the various xml files is clearer than interestingtips -  http://www.prashantraju.com/projects/pentaho/
• Further instructions including including saiku and ctools 
• http://pablotips.blogspot.sg/p/installing-tomcat-and-pentaho.html
• How to add Saiku, BI Server and JPivot OLAP datasource?
• http://interestingittips.wordpress.com/2011/05/08/complete-pentaho-installation-on-ubuntu-part-3/
• The "Eclipses" to download  http://interestingittips.wordpress.com/tag/pentaho-tools/
• Pendular - Another front-end for Pentao BI Server

What interestingtips missed out?

• Recently released : Saiku Report 1.0 ( http://mgiepz.github.com/saiku-reporting/)
• OpenI ( http://openi.org/)

Patches

• Things to modify for the charts in examples to run  http://interestingittips.wordpress.com/2011/05/05/complete-pentaho-installation-on-ubuntu-part-2/
• How to remove the warning messages?  http://interestingittips.wordpress.com/2011/06/05/complete-pentaho-installation-on-ubuntu-part-5/

Tutorials

• Creating Dashboards with CDE:
• http://type-exit.org/adventures-with-open-source-bi/2011/06/creating-dashboards-with-cde/ (no need to seperately download CCC)
• How to join two fact tables with Pentaho Metaeditor?  http://diethardsteiner.blogspot.sg/2011/02/pentaho-metadata-editor-joining-two_04.html

Documentation

• Pentaho Mondrian 3.0.4 Guide  http://docs.huihoo.com/mondrian/

What are the Alternatives to OpenReport?

OpenReports (http://oreports.com/) is being viewed to be DEPRECATED.

Alternatives include the following:

• Open Report V2 (http://code.google.com/p/openreportv2/) - newcomer?
• ReportServer (http://reportserver.datenwerke.net) - seems like not very popular based on the number of postings on the forum
• OpenI (http://openi.org/) - doesn't look comfortable ...
• ART (http://art.sourceforge.net/) - looks ok to try further

InfoQ: Dan Allen on Arquillian Testing Framework

Might be an interesting library to consider if you want to go beyond JUnit:
InfoQ: Dan Allen on Arquillian Testing Framework

What are the Free Cloud Services?

As metioned by Xeround:
http://xeround.com/blog/2012/03/free-cloud-services-for-application-developers

Where to find 3D Ribbon Generator?

Can use this to generate a CSS3 ribbon:
http://www.css3d.net/ribbon-generator

How to do XML <-> JSON?

One option found:
http://beckchr.github.com/staxon/

What is kuler?

http://kuler.adobe.com

What are the Date and Time Picker in ExtJS?

There are a few available:

• apleshkov DateTimePicker -  https://github.com/apleshkov/DateTimePicker
• DateTimeField -   http://www.sencha.com/forum/showthread.php?22661-new-version-DateTime-Field
• 
  

What are the Possible Ways to Draw a Timeline Widget?

Nothing come close in ExtJS (.

Possible methods:

1. This will be the first choice if there is no concern on the learning curve. SIMILE Widget - http://www.simile-widgets.org/
2. By Pure CSS Method, as mentioned in Pure CSS Timeline.
3. jQuery Timelinr -  http://www.csslab.cl/2011/08/18/jquery-timelinr/ - if you only need years
4. timeglider -  http://timeglider.com/jquery/  - it's not free for commercial use
5. Finally found something which might just be what we want: CHAP Links Library -  http://links.sourceforge.net/

What are the JSON Library Which Can Be Use in JDK 1.4?

I have found these links:

http://stringtree.org/stringtree-json.html

https://github.com/douglascrockford/JSON-java

http://www.rojotek.com/blog/2009/05/07/a-review-of-5-java-json-libraries/

How to Identify Color Code from Windows Screen?

One of the tool - Instant Eye Dropper
http://instant-eyedropper.com/

Kendo UI? Another ExtJS?

Kendo UI
http://www.kendoui.com/

Interestingly from Telerik

How to get Rounded CSS Corner (with No Images)?

This article gives the best summary:
http://jonraasch.com/blog/css-rounded-corners-in-all-browsers

How to create WSDL-first SOAP client in Java with CXF and Maven?

Try to use this to consume a webservice from Coldfusion:
http://www.logicsector.com/java/how-to-create-a-wsdl-first-soap-client-in-java-with-cxf-and-maven/

How do you develop a timeline widget?

Two possible ways:

SIMILE Widget - for Timeline
http://www.simile-widgets.org/

or

Ext Scheduler
http://www.bryntum.com/products/scheduler/

How to Convert Excel Data to JSON?

We came across this useful site:
http://shancarter.com/data_converter/

jPortal Homepage & Demo

Homepage at http://jqportal.com/index.html

Demo at http://demo.portalfin.com/

Liquibase Best Practise - The Old Article

The old version of the article is better than the latest version.

http://www.liquibase.org/bestpractices?rev=1237998242

Jasmine BDD with Coldfusion

BDD Javascript for Coldfusion
http://coldfusionmumbojumbo.com/cf/index.cfm/cfconferences/cfobjective-2011/test-driven-development-in-javascript-with-jstd-and-jasmine/

Testing tools comparisons: Gomez vs NeoLoad vs Loadrunner vs Selenium
http://bharath-marrivada.blogspot.com/2011/03/gomez-neoload-loadrunner-selenium.html

How to take a Java Web Server down?

This article mentions an approach by using a servlet filter

http://tutorials.jenkov.com/java-web-apps/web-app-maintenance.html

Tiny Java Web Server & Percona

Tiny Java Web Server - smallest java web server around?
http://tjws.sourceforge.net/

Percona's homepage at http://www.percona.com/software/ good enough to support mysql?

How to gracefully handle session timeout in ExtJS?

http://css.dzone.com/articles/art-gracefully-handling

How to schedule automated backup in Sql Server 2008?

It's very easy...
http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx

How to Increase File Upload Limit in IIS7?

There are 2 parts involve, refer to http://blog.twinharbor.com/2011/07/28/fixing-iis7-maximum-upload-size/ for more details.

How to automatically redirect HTTP to HTTPS in IIS7?

The link below shows the URL Rewrite 2.0 approach:
http://www.jppinto.com/2010/03/automatically-redirect-http-requests-to-https-on-iis7-using-url-rewrite-2-0/

How to Enable SSL on IIS7 with Self-Signed Cert?

It looks easy on IIS 7...
http://weblogs.asp.net/scottgu/archive/2007/04/06/tip-trick-enabling-ssl-on-iis7-using-self-signed-certificates.aspx

/actionName!methodName.action by Struts Zero Configuration?

This is not very clear in Struts documentation.

Posts which talks about /actionName!methodName.action syntax:

1. http://depressedprogrammer.wordpress.com/2007/04/04/struts-2-and-zero-configuration-for-actions-and-results/
2. http://blog.newitfarmer.com/j2ee/struts2/558/struts-2-crud-example/

How to perform Struts Validation (JSON Based)?

Good example in http://code.google.com/p/struts2-jquery/wiki/Validation

Custom Jackson's ObjectMapper in Spring Framework

Method No 1: Prevent cross-site scripting when using JSON objects using ESAPI and Jackson framework 1.7.x

 Another link showing JaxbJacksonObjectMapper.

 Another link showing option 3: How to customise the Jackson JSON mapper in Spring Web MVC? Method as described in jackson-module-hibernate

One example of how to write the JSONResult

Example 2: Creating a Login Interceptor in Struts 2 - Same concept can be use to write the JSONResult and configure in Spring

Where to get a Generator for Lorem ipsum?

Quite a handy tool to use

|| Dummy Text Generator | Lorem ipsum for webdesigners ||

OPPM 2 : YouTube Showing OPPM's Usage

OPPM 1: Good Powerpoint Slide

Using The One Page Project Manager

View more presentations from Performance People Pty Ltd