IT Reflexions

Archive for the ‘Business Intelligence’ Category

Some frequent tasks developers can do using Datastage:
Creating a job using the Design module. Here you have to define the source and the target of the job. This can be either a text file or an Oracle table. After choosing the source and the target, the job must be implemented and the unit tests executed.
Creating [...]

DataStage is an ETL(Extract, Transfer, Load) tool.
Like all the ETL tools it satisfies the following needs:

extract data from the datawarehouse or from files that arrive from different other applications
transform and modify the data and after
insert or load data into the datawarehouse.

DataStage is composed of more modules that will allow you to implement these three main [...]

What it does :
Enables the creation, management and delivery of both traditional, paper-oriented reports and the interactive Webbased reports(integrated part of the Microsoft Business Intelligence framework).
Architecture

Tools used :

Reporting Services Configuration
Report Manager
Report Builder
Report Designer
Model Designer

Adding reports directly to the server:

Using Report Designer from Visual Studio Business Intelligence
Using the programatic interfaces availbale

Management of reports :

using Report Manager [...]

14 Apr, 2008

First steps in Business Intelligence

Posted by: Anca A. In: Business Intelligence

As a beginner in this area, I thought the first things to do is to get a little familiarized with the main concepts it involves. So, some of the keywords to start with are :
Bussines Intelligence, Data warehouse, Data mart, Key performance indicators, Extract Transfer Load (ETL), Data mining, OLAP Modelling, Multidimensional analysis, Type of [...]


About me

Client-focused software engineer with high intellectual mobility and experience in international teams.

Some of my interests are open innovation, design patterns, networking, personal branding, blogging and study of foreign languages.

Enjoy your visit and don’t hesitate to leave me a feedback!