Monday, May 25, 2015

Cognos Training

DNAstudio membuka kelas training 3hari IBM Cognos dengan materi pembahasan:
#Hari pertama:
-Overview Business Intelligence
-Komponen IBM Cognos
-Framework Manager Workflow
-Operasional dan Reporting Database
-Membuat Star Schema
-Fakta dan Dimensi
-Determinan
-Double Counting
-Instalasi dan Konfigurasi IBM Cognos

#Hari kedua:
-Overview IBM Cognos Framework Manager
-Membangun Model dengan IBM Cognos Framework Manager
-Menambahkan Business Logic ke dalam Model
-Menciptakan Objek Dimensional untuk Pelaporan Model OLAP
-Menciptakan dan Mengkonfigurasi sebuah package
-Mengimplementasikan security di IBM Cognos Framework Manager
-Tips Toubleshooting

#Hari ketiga:
-Mengeksplorasi Report Studio (list, crosstab, chart, map, statistic)
-Membuat dan Memformat Laporan menggunakan grouping, header, footer dan opsi lain
-Memfokuskan Laporan dengan Memfilter data dan menggunakan prompts
-Menambahkan Kalkulasi dan Laporan Tambahan
-Meningkatkan Report dengan Format tingkat Advance
-Laporan menggunakan Model Query
-Mengatur akses dan menciptakan laporan Drill – through
-Membuat Dashboard & Report.

Info lebih lanjut hubungi:
info@dnastudio.web.id
DNAstudio.web.id

DNAstudio Web

Tempat training  DNAstudio telah membuka kelas kursus membuat web, paket materi kursus web : web design, web programming dan web master, web cms.
Peserta tanpa latar belakang IT pun bisa mengikuti kursus membuat web di DNAstudio.Web.ID Dengan Garansi sampai bisa membuat website serta gratis konsultasi terkait materi ataupun pengetahuan lain seputar IT selamanya.
Semua peserta kursus web disini mendapatkan Gratis Sub Domain.dnastudio.web.id


Friday, September 7, 2012

IBM Cognos 10 Highlights

Released in October of 2010, IBM Cognos 10 is a vastly improved release and sets the bar high for integrated business intelligence platforms and performance management.
Here are ten reasons to consider upgrading to (or making an initial investment in) IBM Cognos 10:

1. Statistics and Predictive Analytics

One of the most significant additions to IBM Cognos 10 is the integration of IBM’s SPSS Modeler. SPSS became part of the equation when IBM acquired SPSS a few years back and began to incorporate it into Cognos’ report-authoring area of the Cognos BI platform. Its Statistics and predictive analytics capabilities give users the ability to gain insights through analysis of historical and real-time data and then deliver predictive information through integrated dashboards. Additionally, the application provides key statistical tests so that decision makers can verify the assumptions that are modeled.

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.