Thursday, August 16, 2012

Data Warehouse: Facts and Measures

What is a Fact Table?

A fact table is a table that joins dimension tables with measures.  For example, Lets say you wanted to know the time worked by employees, by location, by project and by task.  If you had a dimension for employees, location, project and task you would create a composite primary key using these foreign keys and add an additional column for the time worked measure. (more on measures in a little bit)
Keep in mind that fact tables are huge unlike dimension tables.  Fact tables are usually built to contain a hundred thousand records on the low side up to billions of records on the high side.  Therefore, these tables must be normalized to be efficient.

Introduction to Dimensions

What is a Dimension Table?

A dimension table provides the description behind the analytic numbers.  It describes the who, what, when, where and why behind the facts. Dimensions are normally broken down into groups (tables) and they contain several attributes (columns).   Unlike a fact table the dimension table is not normalized.  Generally, dimension tables have many columns but a limited amount of rows. 
Dimension tables normally provide two purposes in a data warehouse, it can be used to filter queries and to select data.

Building a Data Warehouse with SQL Server

What is a Data Warehouse?

In its simplest form a Data Warehouse is a way to store data information and facts in an format that is informational.  Hopefully, you were able to pull this information from the photos above.   Personally, I like to think of a Data Warehouse as a tool used by decision makers to improve decision‐making.

Friday, July 13, 2012

5 Faktor Kegagalan Implementasi BI


Tidak semua implementasi Business Intelligence (BI) pasti berhasil di lakukan sesuai dengan yang diharapkan. Beberapa faktor yang dapat mengakibatkan kegagalan yang sangat perlu diperhatikan dan dipertimbangkan antara lain sebagai berikut :
  1. Pemahaman Konsep dan Sistem BI yang Salah

    Sebelum Anda memutuskan melakukan implementasi BI sebagai aplikasi pendukung keputusan yang sangat strategis, sangat dianjurkan pengguna dapat mengetahui sebelumnya pemahaman konsep-konsep dasar dari BI itu sendiri.

Wednesday, May 16, 2012

set prompt date to default value

Membuat tanggal default prompt date:
drag Date Prompt kedalam body page,
drag HTML Item dan pastekan syntax berikut:

<script language="javascript">
var dDate = new Date();
dDate.setDate(dDate.getDate()-1);
pickerControlStartDate.setValue(getFormatDate(dDate, 0, 'YMD'));
</script>


kemudian klik pada bagian prompt date dan scroll kebawah dibagian Properties
untuk properti Name beri nama: StartDate

Outputnya prompt date akan tampil dengan nilai default tanggal H-1.

createdBy. @aankdavid