Clustering is the process of grouping the data into classes or clusters so that objects within a cluster have high similarity in comparison to one another, but are very dissimilar to objects in other clusters. Dissimilarities are assessed based on the attribute values describing the objects.
There are a large number of clustering algorithms. The ...

The Association Rules algorithm is specifically designed for use in market basket analyses. This knowledge can additionally help in identifying cross-selling opportunities and in arranging attractive packages of products. This is the most popular algorithm used in web sales. You can even include additional discrete input variables and predict ...

Data mining is the most advanced part of business intelligence. With statistical and other mathematical algorithms, you can automatically discover patterns and rules in your data that are hard to notice with on-line analytical processing and reporting. However, you need to thoroughly understand how the data mining algorithms work in order to ...

Business Intelligence Markup Language (Biml) is a SQL Server Integration Services (SSIS) design patterns engine.
A Story of Productivity
A while back I was contacted by a client experiencing a familiar issue. The Production SQL Server instance was experiencing performance issues due to conflicts between customers and enterprise reporting needs. ...

If you’re into Data Warehousing, you may be interested in attending to the workshop I’ll deliver at PASS Summit 2014 in Seattle on November 4th.
http://www.sqlpass.org/summit/2014/Sessions/PreConferenceSessions.aspx
The workshop is entirely dedicated to explaining why and how a *successful* Data Warehouse can be thought, designed, architected, ...

I am proud and glad I can announce two top pre-conference seminars at the PASS SQL Saturday #356 Slovenia conference. The speakers and the seminars titles are: Stacia Misner - Power Up Your Data with Excel and Power BI Kevin Boles - Tune Like A Guru! Both seminars will take place on Friday, December 12th, in the classrooms of our sponsor ...

Sessions of the event 24 Hours of PASS: Summit Preview Edition (which was held on last September 9th) were recorded and now they are available for online streaming!
If you have missed one session in particular or the entire event, you can view it or review your preferred sessions; you can find all details here.
What could you aspect from ...

In the last month, I’ve been working on the slide deck of my Agile Data Warehousing workshop. In order to give to it additional value that goes beyond the pure technical aspects, and since now the “Agile” approach is becoming more and more mainstream also (and finally!) on BI, I did a small research to check what one can find on the web regarding ...

Which sessions you can expect to find at the next PASS Summit 2014 ? Find it out on September 09, 2014 (12:00 GMT) at the free online event: 24 Hours of PASS: Summit Preview Edition.
Register now at this link.
No matter from what part of the world you will follow the event, the important thing is to know that they will be 24 hours of ...