A date (or calendar) table is a SQL table containing a variety of date-related parameters. By joining to this table, one can rapidly access the pre-calculated values, thus significantly simplifying & speeding up your queries. Using 18 December 2013 as an example, the following parameters would be available: Parameter Value Date … [Continue reading...]
What data should a BI system track to gain (or maintain) a competitive advantage? Well, that all depends on your organisation’s unique circumstances. The following management frameworks provide insight to the internal and external parameters to be considered. Internal Organisational Data: The Value Chain Framework created by Harvard Business … [Continue reading...]
Litigation Medical doctors with the covering of their insurance company are seen in the western world as easy targets for litigation. In some cases the plaintiff is an opportunistic gold digger however in others the doctor truly messed up. Mess up in IT and you get a couple of bugs that HOPEFULLY are picked up in in testing. Mess up in … [Continue reading...]
Big Data applications are moving from their search engine origins to the affordable commercial realm, providing dataphiles with sharp new tools to dissect and analyse massive volumes of electronic data. What is even more impressive than this sexy new technology is the marketing hype. I recently read a Big Data article in Forbes referring to … [Continue reading...]
Its mid 2012 and the marketing drums are beating, pushing their message to sceptical enterprises. There is a shiny new toy in town and its name is BIG DATA. In a style that Donald Draper of the Mad Men TV series would be proud of, sensationalist headlines like “it is almost too late for big data”, and “BD: You need to do something about it … [Continue reading...]
Business Intelligence systems can track, interrogate and analyse data in all three time periods: PAST: Historic data that provides an indication from where you have come. It is static and whilst it can be used for analysis, trending, benchmarking etc, it has a small impact on your organisation's current performance. For the sake of … [Continue reading...]
Author: Unknown Used For: Accounting, KPIs, Measuring Cash Flows Overview The Cash Flow from Operations Ratio is a method that helps to determine a company’s short term liquidity, or whether or not it is able to pay off its current liabilities. One may also say that the cash flow from operations ratio is a measure of … [Continue reading...]
Author: Anelda Used For: Accounting, KPIs, Measuring Cash Flows Overview Cash Value Added Ratio is a financial measure to gauge the amount of cash generated by a company through its operations. It’s also known as the Cash Value Added, CVA or the Cash Value Added Model. It is used by investors to measure the … [Continue reading...]
Author: HOLT Value Associates Used For: Accounting, Financial Management, KPIs Overview It is not easy for potential investors to draw any significant conclusions about the health of a company based purely on accounting earnings. Accounting data can sometimes be misleading and so cannot be completely relied upon to … [Continue reading...]
Author: N/A Used For: Accounting, Financial Management, KPIs Overview The Cash Ratio (CR), also known as the Liquidity Ratio or Cash Asset Ratio, is a measure of a company’s immediate liquidity, i.e. its ability to pay off all its liabilities immediately without having to sell off any of its inventory. The … [Continue reading...]