Indexes and Performance
Prelude: The article Scan vs Seek gives a quick preview into performance considerations of queries. Performance of a database can be boosted using several methods. […]
Reports
Mean, Median & Mode – BI Perspective
“Mean, Median and Mode” is the first topic that anyone encounters when they start learning Statistics. Within BI context, these three methods of measuring numerical […]
Pareto Analysis – 80/20 Rule
Pareto Analysis, which is more popular with its nickname i.e. 80/20 rule is a standard analysis option in BI tools today. For example Cognos has […]
The Currency Conundrum – 2
In BI context, currency is a critical component for any report or dashboard. Currency based reporting is simple and straightforward in majority of cases. Users […]
The Currency Condundrum
“Think Global & Act Local” has gained popularity due to the nature of businesses in today’s world. Globalization has reached its tentacles into all nooks […]