Forecasting Sales data with Excel mining – Step by Step Guide

Mining is a service and can be coded.  This means that it is enterprise ready. Mining can be done using Excel SSDT PowerShell and SSMS Analysis Services service should be “ON” for mining to run Using a combination of basic PowerPivot and Mining Plugins for Excel 2013, let us create a forecasting model. Open Excel…


Business Intelligence Semantic Model (BISM)

Hi,  The attached pdf was presented at Teched Bangalore and Pune in March 2013. Many of you have asked for slides to be shared and hence I am uploading the same here. Will look forward to your questions and views here BI Semantic Model.pdf


Data Cubes

The term “Cube” is not new.  Most of us would associate it with Rubik cubes, invented by the Hungarian sculptor and professor of architecture in 1974.  It was so popular that in 1980 Germany recognized it as “German game of the year”   Children or the childlike would associate it with dice. A six faced…