Posts tagged "bi"

Apa itu Business Intelligence ?

Business Intelligence (BI) merupakan topik atau istilah yang cukup hangat diperbincangkan di dunia bisnis maupun teknologi informasi. Seringkali kita mendengarkan istilah ini diucapkan pada seminar maupun tertera pada artikel ilmiah. Sialnya pengertian business intelligence pada bidang bisnis dan teknologi informasi sangatlah berbeda. BI in Business != BI in Information Technology. Business Intelligence pada dunia bisnis… Continue reading

Microsoft Analysis Service (OLAP) Front-End

Option for MSSQL Analysis Service (OLAP) Front-End 1.Microsoft SQL Reporting Service SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface 2.Microsoft PerformancePoint Service PerformancePoint Services in Microsoft SharePoint… Continue reading

SSAS: MDX Average Script On SSAS 2008

The MDX script on Microsoft Analysis Service (SSAS) 2008 and 2005 are different from SQL 2000. Here’s an example how to calculate average using MDX script on Analysis Service 2008. SSAS 2008, How to calculate Net Value By Date (NetValue / Date) AVG( Descendants( [Time].[Calendar].CurrentMember, [Time].[Calendar].[Date] ), [Measures].[NetValue] ) Old one, SSAS 2000, How to… Continue reading

SAP BW, Documentation (1)

After getting to  know and familiar with SAP BW basic T-CODES. I found another website to help mastering SAP BW is Lots of goodies relating  SAP BW, such as tutorials, learning guides and help files containing PDF or Microsoft Documents (Doc) . Interesting, I thought the page/sub domain is a technic for Search Engine… Continue reading


Bagi penggiat Knowledge Management, mesin pencari Google seringkali dirasa belum cukup untuk memenuhi kebutuhan data yang diinginkan.  English Query yang digunakan mesin pencari google dan sejenisnya seringkali menimbulkan kekacauan bila dikaitkan dengan pencarian data yang membutuhkan output numerical atau perhitungannya, apalagi dikaitkan dengan aktifitas slice and dice ala Business Intelligence (BI) . Google and other… Continue reading


In many Business Intelligence implementation cases,  there’s a certain difficulty for IT Pro to explain or describe the difference  between OLTP (OnLine Transactional Process) and OLAP (OnLine Analytical Process).  I hope the table below might help a little. source: 360decisions [table id=1 /]