Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Archive for the ‘Financial Intelligence’ Category

Financial Intelligence

13 Period Calendar

Posted by Dylan Wan on February 26, 2008

I will discuss the following topics:

  • What is the 13 period calendar?
  • Who uses the 13 period calendar?
  • How is it different from the 4-4-5 calendar?

Read the rest of this entry »

Posted in BI, BI Application, BI Work, Business Intelligence, Data Warehouse, Financial Intelligence, Sales Intelligence | 9 Comments »

Cost Center Hierarchy and Performance Management

Posted by Dylan Wan on January 27, 2008

Cost Center Hierarchy is an important dimension is the Performance Management system. The cost center concept is described in many Managerial Accounting books. I think that going back to where it was originated help us to understand how it should be designed and used in a Business Analytics Data Warehouse.

A cost center is described as an essential element used in the responsibility accounting reporting system. Here are the major concepts about the responsibility accounting and cost center described in the managerial accounting field.

Read the rest of this entry »

Posted in BI, BI Application, BI Work, EBS, EPM, Financial Intelligence, SAP | 2 Comments »

Aging Reports and DSO (Daily Sales Outstanding)

Posted by Dylan Wan on February 27, 2007

Account Receivables aging report and Daily Sales Outstanding are two metrics commonly seen in the Financial Analytics for measuring the performance of the Account Receivables, Credit Management, and Collection departments. Here are how they are calculated, who the users are, and how they may affect the business decisions. Read the rest of this entry »

Posted in BI, BI Application, Business Intelligence, Financial Intelligence, Siebel Analytics | 7 Comments »

Book to Bill Ratio

Posted by Dylan Wan on February 15, 2007

Book to Bill ratio is the ratio of orders booked for future delivery to orders being shiped immediately, and therefore billed. Read the rest of this entry »

Posted in BI, BI Application, Business Intelligence, Financial Intelligence, Project Intelligence, Sales Intelligence | Leave a Comment »

Typical Business Intelligence Applications

Posted by Dylan Wan on December 25, 2006

This arcticles examines the major business drivers of business intelligence and the typical business intelligence applications. Some BI applications are common for all types of enterprise, others are specific to some industries.

Posted in BI, BI Application, Business Intelligence, Customer Intelligence, Data Warehouse, Financial Intelligence, Human Resource Intelligence, Marketing Intelligence, Procurement Intelligence, Project Intelligence, Sales Intelligence, Service Intelligence | Leave a Comment »