Visual Analytics and SQL Server Data Mining

The Association for Computing Machinery produces a regular journal called SIGKDD Explorations, where SIGKDD is an acronym for Special Interest Group on Knowledge Discovery and Data Mining. I would classify the journal as academic, even though private-sector consultants or companies may be coauthoring articles.

In a recent issue, there is an article titled “Visual Analytics: How much visualization and how much analytics?”. The article makes the following claims:

  • Visual Analytics is the science of analytical reasoning supported by interactive visual interfaces.” (page 5)
  • “The term Visual Analytics has been around for about five years now.” (page 5)
  • “The core of our view on Visual Analytics is the new enabling and accessible analytic reasoning interactions supported by the combination of automated and visual analytics.”(page 5)

Altogether, these statements mean that Visual Analytics is a relatively new academic buzzword to define a specific field of research, namely the combination of automated analysis and visual representation. Someone might ask, how much does that description look like what people do with Excel? I would at first pass answer that Excel 2010 has exceptional graphic and visualization capabilities, but it does not inherently provide automated data analysis. However, SQL Server Data Mining adds the automated portion of this equation.

Continue reading “Visual Analytics and SQL Server Data Mining” »

Writing Data into Analysis Services

Microsoft SQL Server 2008 Analysis Services Unleashed Book Review Chapter 16

This chapter discusses writing back data into Analysis Services. The chapter talks about a detailed and technically challenging sequence of actions which have to happen to:

  1. allow temporary writebacks from any session
  2. allow writeback to be turned on per SSAS partition, and therefore accept changes into a writeback partition (separate from the original data)
  3. sequence a writeback through the current session and other session temporary writeback partitions

What’s additionally exciting on this topic is that writeback is now available from Excel 2010, and I will provide screenshots which were not available when this book was written. Visually, this new feature seems to unlock the final goal for writeback, namely providing a desktop user the ability to change specific values. However, the hard lifting happened by the time this book was written, and represents the core commitment technology required to synchronize not just one user’s writebacks with the cube, but all possible users altogether.

Continue reading “Writing Data into Analysis Services” »

Applied Data Mining using Microsoft Excel 2007

Data Mining with Microsoft SQL Server 2008 Book Review Chapter 2

This chapter starts with a recommendation to http://trymicrosoftoffice.com which gives anyone a free trial for Office 2007. I have a Technet subscription so I already have Office 2010 (the “RTM”, release to manufacturing, version). I have heard that Office 2010 will ship to retail outlets this summer 2010. Continue reading “Applied Data Mining using Microsoft Excel 2007” »