BI USABILITY: evolution and tendencies

Introduction

What is known today by the name Business Intelligence (BI) has an origin and evolution that should be looked at in order to introduce the concept that will be the subject of this article: “BI Usability”.

One of the principal goals of BI is that users find the information they need to make decisions in due time and proper form. The form includes, among other things, the format in which the information is presented and the level of interaction expected to obtain the desired result. The previous points make up the term “BI Usability”.

 

Usability can be defined as software’s ease of use, in which factors such as the familiarity of the design, comfort, attractiveness, level of interaction permitted, response time, etc. also come into play.

Various definitions of usability have been selected to complement the concept: (*1):

Results of the last Forrester Wave about Enterprise Business Intelligence Platforms

In his blog Boris Evelson explains the more relevant results of the las Forrester Wave about Enterprise Business Intelligence Platforms.

These are the last movements, extracted from it:

  1. IBM Cognos, SAP BusinessObjects, Oracle, and SAS continue to lead the pack.
  2. Information Builders, Microsoft, and MicroStrategy move into the Leaders category.
  3. TIBCO Spotfire and Actuate maintain their Strong Performer status.
  4. QlikTech and Panorama Software move into the Strong Performer category.

 

How to Twitter from a procedure in Oracle PL / SQL

API Calling Twitter from stored procedures PL / SQL can send status updates to a Twitter account. Apart from the funny thing it may be, can be a very effective method to warn us or our users of any event occurring in the database.

Twitter can easily convert an additional warning system for when we have problems in our Oracle database, or you simply want to learn or inform others automatically upon completion of certain processes, such as Enterprise Data Warehouse charges .

Twitteando desde un procedure de Oracle PL/SQL

Remember that Twitter accounts can be configured to be open to any user, or can be secured so that only users to access Twitter to be granted permission to 'follow'.

You can find the code and a detailed explanation on how to create a package for Twittering from PL / SQL in the Database Geek Blog , and updated source code in ORA_Tweet project has created the same Lewis Cunningham on Sourceforge.

Installation of SQL Server Management Studio Express 2008

Installation of SQL Server Management Studio Express 2008I just finished an installation of SQL Server 2008 Express and SQL Server 2008 Management Studio Express, and I had a few laps for a couple of points of the system that are not too intuitive. With this entry I hope to facilitate the job who is in the same situation later.
To begin with I thought that Management Studio already installed with the BD, and it does not. First you install the SQL Server engine, and then downloaded another package to install SQL Server Management Studio.
Installing SQL Server Express will not comment because I came up no problem worthy of note, and is well explained in many other places. I connect the Microsoft download page where the installation packages of SQL Server 2008 Express.

 

After installing the BD, download the installation package of SQL Server 2008 Management Studio Express, also available at the Microsoft website...