Hello Business Intelligence! – Analysis and Design Part

We finished the requirement part and we were ready for the next phase, analysis phase.

Based on our agreement with client, we were going to use SQL Server 2005, SharePoint Server 2007 and PerformancePoint Server 2007 as tools for Business Intelligence system. What we were going to build was not pure BI system, but we were asked to build some features that is used for daily needs. So for that matters, we decided to build the system with Ruby on Rails. That means the system will be web based application. Continue reading “Hello Business Intelligence! – Analysis and Design Part”

Advertisements

What is Business Intelligence ?

I’ve told you my short-unfinished experience story about business intelligence. But, before I continue, I want to answer the first question came up on my first post. Yes, it is “what is business intelligence (BI) ?”

All you people should have known information system software like your university’s online registration system, your office’s task progress tracker system, government’s tax system, or anything else that you see or use it often. That kind of system is called with day-to-day data transactional system (at least I call it so). The system provide us with real time data, because every second, minute, hour, or day data transaction occurred is recorded in the database. So the data time information is very clear and precise. Continue reading “What is Business Intelligence ?”

SSIS – Lookup Component Problem

Right now, I’m doing task on SQL Server Integration Service 2005 (SSIS), and I have a problem with case like this.

Let’s say I have 4 data sources (tables), along with its data :

Table A

Column A1 (PK) Varchar(255) Column A2 (FK to Table B) Varchar(255)
1 11
2 12
3 11
4 14
5 11

You see that column A2 has several record with same values (11)

Table B

Column B1 (PK)

Varchar(255)

Column B2

Varchar(255)

11 A
12 B
13 C
14 D
15 E

Table C

Column C1 (PK)

Varchar(255)

Column C2 (FK to Table D)

Varchar(255)

1 0421095201
2 0414117102
3 0421095201
4 0414117102
5 0421095201

Here the data is same with Table A and also for column C2, it also has same values in its record.

Table D

Column D1 (PK)

Varchar(255)

Column D2

Varchar(255)

0421095201 F
0414117102 G

Continue reading “SSIS – Lookup Component Problem”

Hello Business Intelligence! – Intro and Requirement Part

what is business intelligence (BI)?

That question was never answered since it showed up in my mind 2 years ago until i started work on it 3 months ago. Our client asked us to create a business intelligence system running on Microsoft SQL Server 2005, along with PerformancePoint Server 2007 and SharePoint Server 2007. They expect to have a system so they could see their organization performance easily, only in 3 months. Wow! i could only respond in a good way, because it really was a challenging matter, though somehow it slightly possible. Not only that, we found out that they hadn’t had some automated system run for their daily operation. So far, they only depend on spreadsheet application to store their data. Continue reading “Hello Business Intelligence! – Intro and Requirement Part”