Blogs

Which brings Oracle Business Intelligence 11g

 

Last week I attended a Web Seminar Oracle that presented the new features of Oracle Business Intelligence 11g.

The truth is that I was pleasantly surprised, because these improvements solved what I considered so far the main weaknesses of the Oracle BI Suites .

Most significant to me is the integration efforts made in the portal since it can use most of the tools of the suite, and thus reduce the feeling of working with different products. For instance, you can create operational BI Publisher reports from the same portal, and has created an integrated scorecarding tool that allows you to define KPI's, and 'react' with Agents and Actions, another pending issue of the suite. The part of administración system has also been integrated into Enterprise Manager.

Other improvements are those which have been introduced in the creation and display Dashboard, the possibility of using interactive maps, and above all the possibility of using also Answers MOLAP data sources such as Essbase cubes, which enables integration Hyperion, greatly improves the analytic reporting and enables dynamic navigation for multi-dimensional hierarchies, and other features in the reports.

CRM solutions for SMEs

 

The customer

I've found an interesting Discussion on CRM Experts Linkedin Group baout the search of CRM solutions for small businesses.

The debate has many responses and, apart from good advices, have come many proposals for CRM applications aimed at SMEs, so I've decided to create a list, that I hope to be useful..

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 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, who kindly have sent me Roland Bouman (co-author of the book) and Wiley.

On that occasion will realize different reviews from different points of view, as I did with Pentaho Reporting. 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.

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]

http://bigdatamatters.com/bigdatamatters/2010/04/high-availability-with-...

Pentaho 2.0: Virtual Image

 

From Grupo eGlu, Dario Bernabeu and Mariano García Mattío, 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:

Syndicate content