Skip navigation.

Dylan's BI Notes

Syndicate content Dylan's BI Study Notes
My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management
Updated: 7 min 56 sec ago

Cloud to Cloud ETL

Fri, 2015-01-16 20:24
I found that Cloud to Cloud ETL is different from the regular ETL running in the on premise env in several ways: 1. Direct Database Access is not available 2. Complex / Nested Objects 3. Paging 4. Volume Restriction 5. File base approach 6. Data Streaming 7. Data Security / Protection 8. Change data capture […]
Categories: BI & Warehousing

BI Applications in Cloud

Mon, 2014-10-06 18:28
Prepackaged analytics applications are available as cloud services. The idea is that the client company does not need to use their own hardware and does not need to install the software or apply patches by themselves. What they need is just simply the browsers. For the end users, there should not be much difference.   The BI apps built […]
Categories: BI & Warehousing

Working Capital and Inventory Management

Sun, 2014-09-28 23:24
The importance of the inventory management can be best described via working capital management. Cash is the blood of the company. Cash conversion cycle is measured as ( ( Account Receivables + Inventory – Account Payables )  / (Total Revenue / 365) These Youtube videos from Mark West from Redstack Analytics describes this CCC metric very […]
Categories: BI & Warehousing

Supply Chain Questions

Sun, 2014-09-28 22:42
The key question are about inventory and orders. What is our inventory status? by product and by location? Do we have enough inventory on hand and in process to meet customer demand? How can we maximize customer satisfaction while minimizing cost and size of inventory on hand? Both over stocking and under stocking are bad […]
Categories: BI & Warehousing