Democratization of Business Intelligence

 

Some information systems have exceeded the boundaries of the department and his knowledge has spread to all areas of the company. As the technologies are becoming easier to use and accessible for all business casuistry, his knowledge extends and extends beyond the field of "understood" by the experts, to be known by every company profiles. Concepts such as CRM, ERP, etc., Not long ago in companies known only to the department and the department involved (Marketing and Sales for CRM, ERP Operations, Human Resources for the intranet, etc.).. Concepts today are managed and understood by anyone in the business world.

As for Business Intelligence, I believe that unfortunately is still preserve of experts and technologists. Today it is very common to find a business decision makers are unclear about the functions, spheres of influence, potential and business benefits of a Business Intelligence system. The BI is still known by a few, there has been democratized, it has jumped the hurdles of technology to be part of each and every one of the departments of companies. In my opinion there are several reasons for this.

LifeDashBoard 4 Team Prelytis SaaS solution, you can use without paying for their use.

Prelytis, the company recently surprised us by being the frist to adapt its Business Intelligence solution (or Dashboarding, more specifically) to Apple's iPad, also excels in the world of SaaS solutions with its proposal LifeDashBoard 4 Team, which is not is nothing but the cloud version of its software LifeDashBoard Dashboards.

It has the usual characteristics of SaaS software, and soon afte a user register(link is external) and upload data from an Excel spreadsheet, for example, may have created an attractive dashboard. Collaborative options available, and also takes advantage of the features of mobile devices like the iPhone or IPAD.

But what makes this more special is that it's SaaS solution, but can be used without paying for its use, and without limitation in the number of users. A strong commitment by Prelytis, which seems to be really willing to put a dent in the world based BI innovative proposals.

 

 

Pentaho Solutions: Reviews

 

Good.
I finally finished reading the book Pentaho Solutions(link is external), who kindly have sent me Roland Bouman(link is external) (co-author of the book) and Wiley(link is external).

On that occasion will realize different reviews from different points of view, as I did with Pentaho Reporting(link is external). Here are the reviews:

 

1) Overview :  It is a very easy book to read and handled very well the theoretical and practical.

As the concepts are giving more complex and heavy, is always accompanied with an example, graphic or exercise.

This book is really very useful and indispensable reading both for those who are just beginning to work with Pentaho, and for that we have some time.

 

 

Information is the power, Business Intelligence on Corporate Governance

 

"The goal of Business Intelligence is to provide the information they need, when you need it and in a form appropriate to people who have to make decisions."

The aim of this paper is to support the Business Intelligence or BI should be, of all business software tools (including CRM, ERP, or BI himself), that is closest to the role of management, specifically the Executive Officer.

Since the computer revolution and the explosion of Internet, information is becoming more and more importance. Everything is or will soon be digitized, the amount of information available each year is multiplied and the activity of our business is computerized in most respects.

Studies tell us that the information maintained by companies is doubling every two years and that 80% of decisions are made with only 10% of the available information.

And all of this information is power! Is necessary, vital, to compete. 

How to disable autocommit option in SQL Server Management Studio

Have you ever wondered how to disable the autocommit option in Sql Server Management Studio?

The answer is quick. Simply uncheck the option SET IMPLICIT_TRASLATIONS. To do it follow next path from the menu:

Tools> Options> Execution of the query> SQL Server> ANSI, then Uncheck Option SET IMPLICIT_TRANSACTIONS.

 

 

It seems rather simple but is a common doubt when you start using SQL Server Management Studio. By sharing this tip I hope to save time to someone that wants to disable the autocommit option in SQL Management Studio.

[[ad]]

Defragment to optimize MySQL tables

 

In MySQL, when you delete records from a table, space is reallocated automatically. It is as empty space and forming new attachments will advantage.

The problem is that if a table perform many DELETE operations, the physical space of the table will become increasingly fragmented and the performance is reduced.

In the MyISAM and InnoDB, OPTIMIZE TABLE command available to perform an optimization on any table that, among other things, performs an automatic defragmentation of the table.

It is highly recommended to use this command regularly especially on tables that are more statements of disposal of records.

As a precaution, keep in mind that during implementation, of course, the table is blocked. You have to remember when you are going to use with large tables and busy.

Supersimples The syntax is:

 

OPTIMIZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE mi_tabla1 [, mi_tabla2] ...;

To make a fragmented table optimization can be selected to have free space, probably as a result of DELETE statements:

The cost of having high availability systems with Oracle

[quote]What's the cost of downtime to your business? $100,000 per hour, $1,000,000 or more? The recent volcanic ash that has grounded European flights is estimated to be costing the airlines $200M a day. In the IT world, High Availability (HA) architectures allow for disaster recovery as well as uninterrupted business continuity during system failure...[/quote]

https://bigdatamatters.com/bigdatamatters/2010/04/high-availability-wit…(link is external)

Pentaho 2.0: Virtual Image

From Grupo eGlu(link is external), Dario Bernabeu(link is external) and Mariano García Mattío(link is external), we have created a virtual machine (vmware) that contains a fully functional BI solution.

It has the following characteristics:

  • Operating System: Ubuntu 8.10
  • BI Platform: Pentaho 2.0
  • DBMS: MySQL

This demo also has the following modules:

  • Pentaho Data Integration: Through this tool we have designed the transformations and jobs that extract, transform and load the data to populate the Data Warehouse. (Select option 'No catalog')
  • Mondrian Workbench: Through this tool we have created multidimensional schemes.
  • Pentaho Metadata Editor: Through this tool we've created the Business Model.
  • Design Studio: Through this tool we have developed the xactions.
  • Pentaho Report Design: Through this tool we have created an ad hoc report that requests input parameters.

These modules can be accessed through the taskbar side: