Have you ever wanted to give your viewers the possibility to filter a widget with a single click? Somewhat like the image below, that lets a user click on either the Best Selling Products or Least Selling Products and see the appropriate products in the pivot and their respective sales, cost and profit...

We're used to think about BI in terms of business use only. But BI is applicable at home too. If we have the tool to analyze any sort of data, why not use it at home? Here's an example: Most credit card companies let you download your personal spending data in Excel format. I put all these Excel...

One day I was browsing around Amazon looking for a book about some boring technical stuff (diving into the company pocket is always a good way to start a lazy morning). When I finally found the book I was looking for, I immediately got a list of products who were bought by other customers who also bought...

A typical dashboard or report has several widgets that require query execution in order to present up-to-date results. Some widgets may need to be updated frequently, some on a daily basis, or on a weekly basis - and so on. After you are done creating a dashboard, you can easily refresh it (by clicking...