Posts

Showing posts with the label Intelligence Business

Join Group Applied Database III

This group is created for the students who take Applied Database III lesson. this course consits of Datawarehouse expecially the transformation for OLTP to OLAP in the case study. mor oven this course should deliver Business Intelligence. here is the link to join : AppliedDatabase3

DSS with Balanced Scorecard

Image
Well..these days, programming languages are not only supporting TPS(Transaction Processing System) but also for some managers or decision makers. As a mater of fact some software like Balanced Scorecard Designer is supporting for decision makers. What we can find in the software, actualy we can easily export our file to Excell, HTML, even make Dasboard Report, some Graph or using chart. To run this program is so simple, we can just define weight of a strategy, as we know the first thing we have to do is defining the Vision and Mission and finally define some strategies. Actualy the software of balanced Scorecard Designer is licency, so..of course we have to buy it, or even we can just get trial for the moment, ge.., shal we try it.

Data warehouse

Image
well..talking about data warehouse is so interesting these days. Suppose that we have already mastered 'Database itself'. Data ware house looks like giant database that can support some principles for decision making. In Data ware house also contain of what we call Back room and front room. I just wanna give a sample, one day we well have lunch at "Food restaurant of Institute of Technology Bandung", what should we do is of course we request for the food. we can say the food is data, and int the kitchen we call it staging area where the food is cooked by good chef. when we wanna know about the food that we requested we aren't allowed to get to the kitchen and there is another worker who explain us about the food which is still cooked, in the dining room we can say it's front room. So, back room is a place for getting source from our system that we can get from such as transactional database or flat files and in this place there is also "staging area"...