Microsoft announced yesterday the availability of the Community Technology Preview (CTP) of Microsoft SQL Server 2012 With Power View for Multidimensional Models (aka DAXMD). As a participant of the CTP program and I'm very excited about this enhancement. Now customers can leverage their investment in OLAP and empower business users to author Power View ad-hoc reports and dashboards from Analysis Services cubes. Previously, Power View…
Read articleI'll be presenting What's New in Excel 2013 and SharePoint 2013 BI at our Atlanta BI Group on Monday, December 3rd. Microsoft has recently released the 2013 version of Excel and SharePoint. Both technologies include major enhancements for self-service and organizational BI. Join us to review these new features. Learn how business users can quickly analyze and understand data in Power Pivot which is now…
Read article
As I wrote before, Power View in Excel 2013 and SharePoint with SQL Server 2012 SP1 supports mapping. The map region supports geocoding and it allows you to plot addresses, countries, states, etc, or pairs of latitude-longitude coordinates. The key for getting this to work is to mark the columns with appropriate categories. Using latitude-longitude If you have a SQL Server table with a Geography…
Read articleI've recently had the pleasure to read the book "Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model" by Marco Russo, Alberto Ferrari, and Chris Webb. The authors don't need an introduction and their names should be familiar to any BI practitioner. They are all well-known experts and fellow SQL Server MVPs who got together again to write another bestseller after their previous…
Read articleI hope you watched the SQL PASS 2012 Day 1 Keynote live. There were important announcements and I was sure happy to see BI being heavily represented. For me, the most important ones were: The availability of SQL Server 2012 Service Pack 1 For some reason, this announcement went without being applauded from the audience although in my opinion it was the most important news…
Read article
As you've probably heard the news, Microsoft rebranded their Big Data offerings as HDInsight that currently encompasses two key services: Windows Azure HDInsight Service (formerly known as Hadoop-based Services on Windows Azure) – This is a cloud-based Hadoop distribution hosted on Windows Azure. Microsoft HDInsight Server for Windows – A Windows-based Hadoop distribution that offers two main benefits for Big Data customers: An officially supported…
Read article
