Download SQL Server 2012 SP1 Data Mining Add-ins for Office. This package includes two add-ins for Microsoft Office Excel (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2010 (Data Mining Templates).
"...In the end we come up with a solution where we only have to add the intermediate table (Individuals) and the bridge table (TargetsForIndividuals) to our CALCULATE-functions to resolve the many-to-many relationship – pretty nice, isn’t it?"
Summary: This paper introduces the security model for tabular BI semantic models in SQL Server 2012. You will learn how to create roles, implement dynamic security, configure impersonation settings, manage roles, and choose a method for connecting to models that works in your network security context.
Today was the 1st day of the SQL PASS Summit and the keynote was full of some great announcements and demos. The keynotes are a massive with almost all of the 3894 conference attendees from 57 different countries.
Today at PASS Summit 2012 there have been several announcements during the keynote. Moreover, other news have not been highlighted in the keynote but are equally if not more important for the BI community.
Summary: This paper introduces DirectQuery, a mechanism for directly querying a SQL Server data source for Analysis Services tabular models. Readers will learn when and how to use DirectQuery in SQL Server 2012.
The LobsterPot HTML5 PivotViewer is a cross browser, cross platform version of the Silverlight PivotViewer control produced by Microsoft. The control has been written as jQuery plug-in and utilises features available in HTML5.
Data modeling is a discipline that has been practiced for many years by BI professionals with one common goal: organizing disparate data into an analytic model that effectively and efficiently supports the reporting and analysis needs of the business. As data modeling evolves through the years with new technologies and tools, organizations face the growing challenge of effectively blending their modeling paradigms in a seamless and coherent manner that not only satisfies diverse analysis needs but also provides a common analysis experience to the business. With the release of SQL Server 2012, Microsoft addresses this goal and challenge with the introduction of the BI Semantic Model (BISM), a single model that can support a broad range of reporting and analysis while blending two Analysis Services modeling experiences behind the scenes: