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 tidak sama dengan business intelligence pada dunia teknologi informasi.

Pada tulisan kali ini akhirnya saya dapat memberikan contoh perbedaan istilah business intelligence pada dunia bisnis dan teknologi. Hal ini berkat salah satu sesi pada salah satu acara kantor yang menghadirkan pembicara dari dunia perbankan, mantan Marketing Director Citibank Indonesia  yang secara jenaka dapat mendeskripsikan pengertian business intelligence di dunia bisnis.

Pengertian business intelligence di dunia teknologi sangat mudah dideskripsikan, lihat saja halaman wikipedia berikut .

Sedangkan untuk pengertian business intelligence di dunia bisnis, simaklah cerita humor berikut… (saya sedikit modifikasi agar bisa ditulis)

Suatu hari di sebuah hutan yang rindang dan luas, seorang anak menantu (sebut saja anak menantu satu) berjalan bersama dengan ibu mertuanya. Tiba-tiba sang ibu mertua terperosok ke dalam sebuah danau yang dalam. Seketika itu juga sang anak menantu pertama menolong sang ibu mertua.

Hari berikutnya, sang ibu mertua memberikan sebuah sedan BMW kepada sang anak menantu pertama.

Beberapa minggu kemudian, sang ibu mertua kembali berjalan menikmati keindahan hutan dengan anak menantu lainnya (sebut saja anak menantu dua). Tiba-tiba sang ibu mertua kembali terperosok ke dalam sebuah danau yang dalam, danau yang sama. Seketika itu juga sang anak menantu kedua menolong sang ibu mertua.

Hari berikutnya, sang ibu mertua memberikan sebuah SUV BMW kepada sang anak menantu kedua.

Beberapa minggu kemudian, sang ibu mertua kembali berjalan menikmati keindahan hutan dengan anak menantu lainnya (sebut saja anak menantu ketiga). Tiba-tiba sang ibu mertua kembali terperosok ke dalam sebuah danau yang dalam, danau yang sama…

Saat itu, sang anak menantu ketiga hanya melihat saja (tidak memberi bantuan) kepada sang ibu mertua tersebut. Akhirnya sang ibu mertua tenggelam dan pergi meninggalkan dunia untuk selama-lamanya.

Hari berikutnya,  sang anak menantu ketiga mendapatkan sebuah mobil sedan sport LAMBORGHINI AVENTADOR terparkir rapi di garasi rumahnya. Pada kaca depannya terdapat sebuah kertas dengan tulisan

“Mobil ini untukmu” tertanda bapak mertua.

Business Intelligence dalam dunia bisnis ? semoga anda bisa menggambarkan dengan versi anda sendiri ..#hahaha

Microsoft Analysis Service (OLAP) Front-End

Visual Business Intelligence - Tables and Graphs 1

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 Server 2010 is a performance management service that you can use to monitor and analyze your business. By providing flexible, easy-to-use tools for building dashboards, scorecards, reports, and key performance indicators (KPIs), PerformancePoint Services can help everyone across an organization make informed business decisions that align with companywide objectives and strategy. Scorecards, dashboards, and KPIs help drive accountability. Integrated analytics help employees move quickly from monitoring information to analyzing it and, when appropriate, sharing it throughout the organization.

3.Tantalum

4.Analyzer

Analyzer allows even non-technical users to become productive and self-sufficient quickly, performing powerful analysis and building visually compelling dashboards and flexible reports. A wide variety of components, including pivot tables, charts, Key Performance Indicator (KPI) scorecards, dashboards, web pages, Reporting Services® reports, geographic maps, heat maps, and more — lets users create custom reports and dashboards just by dragging and dropping.

5.Visifire

Visifire is a set of data visualization controls – powered by Microsoft®Silverlight & WPF. Visifire is a multi-targeting control which can be used in both WPF & Silverlight applications. Use the same API to create charts & gauges in Mobile, Web & Desktop environments. Visifire Silverlight Controls can also be embedded in any webpage as a standalone Silverlight App. Don’t take our word for it! Visit Visifire Gallery or design your own chart or gauge using Chart/Gauge Designer.

6.XlCubed

XLCubed’s product set empowers the business user. Bringing the power and flexibility of OLAP reporting to Excel, XLCubed leverages Excel’s strengths but mitigates the risks. Users have a rich Reporting, Analytics and Dashboard environment in Excel, and the ability to deploy the reports to XLCubed Web Edition with ease

7.Tableau

Flat files, databases, warehouses, or cubes: Access your data wherever it lives. Analyze it. Fast.The reality of business today is that no organization has data in a single place. Heterogeneous environments are the rule; exceptions to it are hard to find. You need the ability to analyze data wherever it lives to get the answers you need. Make sure your business intelligence solution can handle your data, everywhere.

8.Report Portal

Report Portal is an advanced web client reporting solution that lets you build, publish and view the following types of reports

9.ranet-uilibrary-olap

It provides parsing, generating and visualization of MDX language and MDX query results. Moreover it provides data input and Writeback to OLAP cube. It works under .NET and Silverlight.

10. DevExpress  –  Business Intelligence Suite

DevExpress Analytics controls allow you to deliver highly interactive data-centric applications to your end-users with minimal effort. From OLAP data mining with integrated charting to data export and analysis via our award winning gauge and reporting options, DevExpress allows you to deliver your very best and offer your customers a way in which to intuitively analyze data.

11. Viblend

VIBlend DataGridView for WinForms is a top of the line data grid control loaded with hundreds of powerful features. It provides a solid and highly extensive data visualization foundation ideal for a broad spectrum of data driven applications. You can build in-house Business Intelligence applications as easily as loading a set of records from a database.

12.Syncfusion – ASP.NET – For BI Edition

We offer more than 60 AJAX-enabled controls/frameworks with complete documentation and samples for the ASP.NET platform. Our unique wrappers for jQuery UI controls allow you to easily add advanced jQuery UI features to your Web Forms applications.

anything else..??

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 calculate Net Value By Date (NetValue / Date)

AVG(
Descendants(
[Time].CurrentMember, [Date]
),
[Measures].[NetValue]
)

Other source from MSDN
http://msdn.microsoft.com/en-us/library/ms146067.aspx

SAP BW, Documentation (1)

sap logoAfter getting to  know and familiar with SAP BW basic T-CODES. I found another website to help mastering SAP BW is http://sap.seo-gym.com/.

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 Optimation(SEO), and it works!

Theese are the list of tutorial that i copy paste from sap.seo-gym.com

  • SAP BW Authorizations docs in detail
  • SAP BW BPS Planning Folders and Layouts
  • How to integrate SAP BI with XI PDF
  • How to install SAP BW
  • SAP BW Netweaver Installation MEDIA_LIST_NETWEAVER
  • Online Analytical Processing(OLAP)
  • SAP BW Sizing Help for estimating the hardware resources needed
  • SAP BW Business Explorer(BEX) a detail learning document
  • ABAP Required in SAP BW for ABAP routines,Functional modules in detail
  • SAP BI Accelerator for high performance in queries
  • SAP BW Cell editing in BEX
  • Control and profitability Analysis in SAP BW
  • Exit Function in SAP BW
  • SAP BW Front End Designing
  • How to handle inventory in SAP BW
  • SAP BW Transaction Codes (t-codes)
  • SAP BW Performance Tuning for queries
  • SAP BW BPS WEB Based Planning

SAP NW7 Deleting Bex Web Analyzer Bookmark (Bex Portfolio / KMBookmark)

sap logoSAP Net Weaver 7 (SAP NW7) has a capability to store query bookmark on web application (Bex Web Analyzer). If we execute query from Query Designer, than it will launch a query in web application. The other way running a query is from Excel Ad In (Query Analyzer).

I like to run query from web application  compare to Excel Ad In, it has great presentation look and it can run anywhere with in browser.

The Problem is the “Save As” menu to My Favorites“,”Bex Portfolio“,”My Portfolio” on web app query is visible and easily use , but there’s no “delete” button on web application query for “Bex Portfolio” item .  User can easily save layout but cannot delete them. Whoott……..!!

To delete a Bex Web Analyzer Bookmark – Bex Portfolio , follow this steps:

1.) Go To:

http://<servername>:<port>/irj/servlet/prt/portal/prtroot/com.sap.km.cm.navigation

or

http://<servername>:<port>/irj/go/km/navigation/

note:don’t forget to add ‘slash’ (/) at the end of the url

2.) Fill User Name and Password , then click  Documents > Public Documents (see picture below) Or Entry Points> Public Documents

public documents my portfolio

3.) Click the icon at the right corner of the Bex Web Application Item (see picture below)
public documents my portfolio delete

and it is DONE! for Bex Portfolio” item

4.) To delete another  Bex Web Analyzer Bookmark – My Favorites or Personal Folder :

Go To: http://<servername>:<port>/irj/go/km/navigation/

and explore the navigation menu. I can’t describe in detail because i’m not testing it on non admin user, yet.

Reference:

  1. SDN Forum – Bex Web Favorites

WolframAlpha

wolframalpha 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 traditional search engine is just way behind.

Sampai akhirnya ada layanan ini…

http://www.wolframalpha.com/

Income Per Capita Indonessia

diambil sebagian dari faq:

Is Wolfram|Alpha a search engine?
No. It’s a computational knowledge engine: it generates output by doing computations from its own internal knowledge base, instead of searching the web and returning links.

Penggabungan pencarian dan aktifitas Business Intelligence sepertinya sudah lebih nyata dan memungkinkan.

Link

  1. WolfranAplha
  2. Tentang WolframAlpha
  3. Blog WolframAlpha
  4. Faqs WolframAlpha

Selamat mencoba…

OLTP vs OLAP

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

OLTPOLAP
PurposeAutomate the businessOptimize the business
UseTransaction processing
Reporting, analysis planning, forecasting and trending
Schema2–dimensional normalized
Multi-dimensional,
de-normalized
NavigationBased on transaction flow
Based on user requirements
OperationMostly insert, update and deletes
Mostly selects
CalculationAggregation, simple matrix
Aggregation, simple matrix, X-dimensional, formula-based
Implementation
Slow to deploy and difficult to change
Fast to deploy and easy to change
Data Usage
Operational
Historical trending, analysis and discovery
Data level
Atomic
Consolidated and customized
Availability24/7 dependency
No dependency on source
Refresh Frequency
ImmediatePeriodic refresh
(Hourly, daily or weekly)
ExampleFlight online systems, order processing systems
Sales per employee
GoalCapture complete data
Retrieve data in seconds / minutes
DesignRelational (RDBMS)
ROLAP, MOLAP, HOLAP
(star, snow-flake or hybrid)
Data Mining & Discovery
Difficult to perform
Easy to perform
Clean Data
NoYes
Transformed Data
NoYes
View of Data
SingleMultiple (sales regions are separate then financial regions)
IT dependency
YesSome IT dependencies for complex query
ScalabilityPoorly scalable
Highly scalable