| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 16.12 MB | Adobe PDF |
Advisor(s)
Abstract(s)
O mundo dos negócios é orientado pela tomada de decisão. A diferença entre a decisão certa e a errada
é a informação. No mundo corporativo, ganha vantagem quem tem acesso mais rápido às informações
que oferecem suporte à gestão empresarial. A Business Intelligence (BI) é o processo que recolhe,
organiza, analisa, compartilha e monitoriza as informações necessárias para o crescimento de uma
organização.
Os dados são armazenadas e transformados em informação qualitativa que ajuda a definir as melhores
soluções. Isto acontece, pois ao conhecer melhor o negócio e ao ter uma visão sólida, bem
fundamentada e completa dos dados corporativos, é possível analisar todos os pontos e arquitectar um
planeamento estratégico. No contexto prático existem várias ferramentas que auxiliam os
programadores, analistas e responsáveis de negócio a desenvolver aplicações de BI sobre dados
existentes em sistemas relacionais (ou outros). No entanto, a maioria está associada a licenciamento. O
objectivo do projecto é desenvolver uma plataforma online de BI utilizando apenas ferramentas
gratuitas, sendo que, para além de um possível produto final, será estudada a viabilidade da(s)
ferramenta(s) a utilizar, em projectos futuros.
Neste trabalho são apresentadas várias ferramentas gratuitas que permitem desenvolver aplicações de
BI. Existem, actualmente, diversas opções no mercado, desde ferramentas que fazem reporting,
passando pelo dashboarding, data mining, entre outras e acabando nas consultas do tipo Online
Analytical Processing (OLAP). Todas as ferramentas apresentadas foram estudadas e experimentadas.
Estas foram alvo de comparação e análise crítica, no fim uma delas será escolhida para um problema
de aplicabilidade prática. A ferramenta escolhida foi então utilizada para criar uma prova de conceitos
prática, tendo como objetivo mostrar a qualidade da solução produzida por este tipo de ferramenta.
Esta destina-se a ser utilizada pela organização Pessoas e Processos, para solucionar um problema real
que consiste na possibilidade de obter dashboards e outros elementos BI com ferramentas gratuitas,
podendo substituir, em determinadas situações o uso de uma ferramenta paga, com uma qualidade
semelhante e assegurando compatibilidade com a infraestrutura informacional pré-existente.
Depois de estudadas várias ferramentas, foi desenvolvida uma aplicação de BI com a prova de
conceitos prática. Com este trabalho prova que existem muitas alternativas viáveis para fazer BI de
forma gratuita. Dependendo dos objectivos a atingir, as organizações, têm ao dispôr várias ferramentas
gratuitas, que podem utilizar para desenvolver soluções de BI. A qualidade das soluções produzidas
por estas ferramentas é assinalável, e deve haver um esforço por parte das organizações, em optar por
este tipo de software. Estas soluções conseguem reduzir os custos das empresas em software
comercial, que oferecem praticamente os mesmos resultados que as ferramentas gratuitas.
ABSTRACT: The business world is driven decision making. The difference between the right and the wrong decision is information. In the corporate world, takes advantage those with faster access to information that support business management. The Business Intelligence (BI) is the process that collects, organizes, analyzes, shares and monitors the information necessary for the growth of an organization. The data is stored and transformed into qualitative information that helps define the best solutions. This is because the best know the business and have a solid vision, well-grounded and full of corporate data, you can analyze all points and at elaborating strategic planning. In practical context there are several tools that help programmers, analysts and business leaders to develop BI applications on existing data in relational systems (or others). However, most are associated with licensing. The goal of the project is to develop an online platform BI using only free tools, and, beyond a possible final product, is studied the feasibility of (s) tool (s) to be used in future projects. This work presents several free tools that let you develop BI applications. There are now several options on the market provided tools that make reporting, through dashboarding, data mining, among others and ending in consultations type Online Analytical Processing (OLAP). All the tools presented were studied and tried. These were compared to target and critical analysis at the end of which will be chosen for a problem of practical applicability. The chosen tool was then used to create a proof of practical concepts, aiming to show the quality of the solution produced by this type of tool. This is intended to be used by the People and Process organization to solve a real problem which is the ability to get dashboards and other BI elements with free tools and can replace, in certain situations the use of a paid tool with a similar quality and ensuring compatibility with pre-existing informational infrastructure. After studied various tools, a BI application with proof of practical concepts was developed. This work proves that there are many viable alternatives to BI for free. Depending on the objectives to be achieved, organizations have to dispose of several free tools that can be used to develop BI solutions. The quality of the solutions produced by these tools is remarkable, and there should be an effort by organizations, in opting for this type of software. These solutions can reduce business costs in commercial software, offering virtually the same results as the free tools.
ABSTRACT: The business world is driven decision making. The difference between the right and the wrong decision is information. In the corporate world, takes advantage those with faster access to information that support business management. The Business Intelligence (BI) is the process that collects, organizes, analyzes, shares and monitors the information necessary for the growth of an organization. The data is stored and transformed into qualitative information that helps define the best solutions. This is because the best know the business and have a solid vision, well-grounded and full of corporate data, you can analyze all points and at elaborating strategic planning. In practical context there are several tools that help programmers, analysts and business leaders to develop BI applications on existing data in relational systems (or others). However, most are associated with licensing. The goal of the project is to develop an online platform BI using only free tools, and, beyond a possible final product, is studied the feasibility of (s) tool (s) to be used in future projects. This work presents several free tools that let you develop BI applications. There are now several options on the market provided tools that make reporting, through dashboarding, data mining, among others and ending in consultations type Online Analytical Processing (OLAP). All the tools presented were studied and tried. These were compared to target and critical analysis at the end of which will be chosen for a problem of practical applicability. The chosen tool was then used to create a proof of practical concepts, aiming to show the quality of the solution produced by this type of tool. This is intended to be used by the People and Process organization to solve a real problem which is the ability to get dashboards and other BI elements with free tools and can replace, in certain situations the use of a paid tool with a similar quality and ensuring compatibility with pre-existing informational infrastructure. After studied various tools, a BI application with proof of practical concepts was developed. This work proves that there are many viable alternatives to BI for free. Depending on the objectives to be achieved, organizations have to dispose of several free tools that can be used to develop BI solutions. The quality of the solutions produced by these tools is remarkable, and there should be an effort by organizations, in opting for this type of software. These solutions can reduce business costs in commercial software, offering virtually the same results as the free tools.
Description
Keywords
Business Intelligence ETL Reporting Dashboarding OLAP Data Mining Data Integration Data Warehouse