Thursday, March 31, 2011

Japanese Grping Movies

Ipad Mobile will soon be available

already been submitted for review in the Apple AppStore, Palo Mobile 1.0 which will run initially in Ipad.
hope we can soon have it in our hands ... Meanwhile

some pictures of what it looks like the application:



Tuesday, February 8, 2011

Maybelline Dream Concealer Swatch

New in version 3.2 SR1 Palo BI Suite

As you may know, is now available 3.2SR1 version of Palo BI Suite. Among the enhancements in this version include:

- Improvements to memory usage
- Improved performance of the rules
- Improved multi-user performance and scalability. It is recommended that those with many concurrent users migrate to this version.
- Availability of Verson GPU handling large cubes

There are a lot of improvements but this article I will focus on usability and web application design.

The new version of Palo BI Suite also brings some interesting new features that make the development of CPM applications on the web is increasingly easy and the result more attractive.

Next step to spell out some of these.

- NEW APPLICATION DEMO . There is a new feature but we can shed light on how best to build our applications. Demonstrates the use of framesets, navigation schemes and macros.

- WIDGETS . Now allows the addition of widgets within spreadsheets with which we can extend the functionality of our applications. Widgets can interact with our views transferring information and added to them HTML, Javascript and PHP. We can extend our applications with graphics libraries, mathematics, etc. which are available for those languages. You can interact with the libraries of Google, Yahoo, etc.



Here is an example of a navigation system with a banner and a map which are used to select the data view we want to see.

And this is an example using Google Maps. Each time you select a geographic region in our view the communication is made with Google Maps to show the selected region.
















And this is another example that mimics the "Slicers" in Excel 2010 or QlikView.












- USE OF FRAMES. Now there is a component called "frameset" to split the screen into quadrants which can be addressed from other reports which increases and improved navigation capabilities and building dashboards. Each frame is independent and which can achieve the effect of leaving a light frozen while we review some of the other frames.












- NAMES MANAGER. Has incorporated this functionality exists in Excel on the Web application that provides name a cell or cell areas with names which allows a higher order in our application.

- new formatting options for graphics. charts now support options such as transparency, orientation of the labels and viewing angles.

- EXPORT TO PDF . Now the setup installs the option to export reports to PDF leaves. Can defined options such as page orientation, scaling, etc.

- PRIVATE VARIABLES . By default each user variables were global. Now version 3.2 allows some variables are defined as private which are stored as such for each user.

- IMPROVEMENTS TO FLOATING OBJECTS. objects as widgets, combo box and graphics have been enhanced by the addition of properties such as blocking in one position, send backward / forward what makes working with these objects easier.

Equally important is the improvement in the documentation for the version and the same examples what we functionality provides greater clarity on that, although still present in the software was not evident nor had examples of their use. Special mention should be made examples of applications that demonstrate the use of macros and interaction with the application widgets.

- PUBLICATION OF REPORTS FROM EXCEL TO WEB . Reports can be published directly from Excel (excluding graphics for now) to the Web server. Can then be edited on the web or Excel as required.

Well, so far this post, although in reality there are many more innovations in areas such as security and performance but, as I said earlier, I only concentrate aspects of usability and web application building.

Friday, December 24, 2010

How Do I Get My Dog To Empty The Bowel

The potential of shared data as a service is already available

In EBICYS used to working with one of the most important assets of organizations: their data. For these are really good must be in a format that allows:

- Share them
- Debug
- Enrich
- Reusable
- We analyze
- Display

In many cases the format is not appropriate and only meet one of these objectives.

As an exercise we have taken data reconstruction grants awarded to the victims of the last major earthquake that struck Chile on 27/02/2010. The Ministry Housing published on its official website a list of more than 100,000 grants in a PDF file with a size of 75 MB which allows fairly (very large and slow to download) the first objective, namely to share, but this format only is useful for those who wish to audit one to one the list but fails to meet any of the other objectives mentioned missing the opportunity to get more out to them.

understand that the main objective was to communicate the list of beneficiaries but would be good places to start delivering state "data services", as do other states, for use and analysis. Using the parallel

with what happens in many organizations when faced with a draft Datamarts / Datawarehouse PDF file illustrates very well what happens in most cases:

- the data is not in the format we expected or were difficult to access
- need
data conversion - are not standardized (eg, cities Chillán, Chillan, Viña del Mar, Vina Del Mar, etc)
- do not meet all the same format and there is "dirt" in the same (lack of tabs / spaces)

just to mention a few things.

whole process of profiling, cleaning and normalization, extraction, transformation (the information enriching) is the one that took the longest amount of time for which data were useful.

As with any project of this type earlier stages were those who consumed 80-90% of the time and displays the remaining 10%. Finally

carry data at the level of detail and enriched in Google Fusion Tables (to be shared in a more easy and allows reuse) we display to allow their analysis and form a macro picture of the situation. Ultimately converted into information useful for analysis.

The tools we use are:

- FoxIt to convert PDF to text
- Google Refine, Excel 2010 for profiling, standardization and cleansing
- Google Fusion Tables as a data store and display

The following were the results.

WARNING: THESE DISPLAYS MAY CONTAIN ERRORS DUE TO THE FACTS WERE NOT AUDITED, THE SHORT TIME THAT HELD THE EXERCISE AND problems converting. This is done as an exercise to demonstrate the usefulness of SHARE DATA DISPLAYS AND PUBLIC ON THE NET. RECOMMEND ANY CONCLUSION FOR VALIDATING THE RESULTS FROM THE FILE IN PDF FORMAT POSTED ON THE SITE OF THE MINISTRY OF HOUSING.


The table with all the data can be browsed, queried y descargada   aquí



Los colores representan la concentración de subsidios siendo la escala : verde, amarillo, rojo y luego los íconos más grandes (mayor cantidad), amarillo y rojo.  Al hacer "click" en el ícono se muestra el total de subsidios de la comuna.