AncaA's tech journal

Archive for the ‘Business Intelligence’ Category

13 Aug, 2008

Creating and designing jobs with DataStage

Posted by: Anca Alimanescu In: Business Intelligence

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 [...]

  • Share/Bookmark

13 Aug, 2008

General things about DataStage, an ETL tool

Posted by: Anca Alimanescu In: Business Intelligence

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 [...]

  • Share/Bookmark

21 Apr, 2008

SQL Reporting Server 2005 fast overview

Posted by: Anca Alimanescu In: Business Intelligence

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 [...]

  • Share/Bookmark

14 Apr, 2008

First steps in Business Intelligence

Posted by: Anca Alimanescu 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 [...]

  • Share/Bookmark

Arhive

Mobile Barcode

qrcode

This is a 2D-barcode containing the address of my mobile site.If your mobile has a barcode reader, simply snap this bar code with the camera and launch the site.

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!


Software entropy

1. A computer program that is used will be modified.

2. When a program is modified, its complexity will increase, provided that one does not actively work against this.

Switch to our mobile site