May 16, 2008

Webdashboard: Dashboarding made easy

Interesting looking product here, and at 95 Euros per license, competitively priced too.

image

It connects to the Microsoft and SAP BW BI platforms, making it something I will be extremely interested in. I’ll be downloading a version and giving it a run out over the next few weeks.

Permalink • Print • 1 Comment

March 20, 2008

Panorama Pivot Table for Google Docs

This looks interesting …. see the link here 

Panorama Pivot Table for Google Docs is an interactive table that automatically extracts, organizes, and summarizes your data. You can use this report to analyze the data, make comparisons, detect patterns and relationships, and discover trends. In just a few steps any users can find answers such as the best selling region, and best selling product or analyze results of an academic research. With Panorama Pivot Tables for Google Spreadsheets, you can interact with the data and look at it in various ways in a simple drag and drop environment.

The Pivot Table for Google Docs is developed by Panorama, who were, interestingly enough, the original inventors of Microsoft Analysis Services OLAP (Online Analytic Processing) engine. So now, part of Panorama code will be inside two of the biggest software companies in the world!

With this new feature, every Google spreadsheet user will have access to powerful OLAP, as a free BI SaaS add-on to Google Docs. In my opinion - a very wise move by Google to continue to push Google Docs into enterprises.

In order to compete with Excel, among many other features, Google spreadsheets lacked specific business functionality needed to analyze vast amounts of data stored in these spreadsheets. With Panorama free add-on Google spreadsheets, users can now take advantage of this lightweight - but still very respectable and powerful - OLAP engine. Yes, out of the box native pivot tables in spreadsheets can do basic analysis on rows and columns of data, but Panorama takes it much farther with more powerful OLAP functions like (I don’t actually know yet what subset of full Panorama OLAP functionality is available as Google add-on):

  • Drill up/down
  • Drill across / Drill through / Drill anywhere
  • Allocations
  • Combine/merge/split dimensions
  • Exception handling and conditional formatting
Permalink • Print • 1 Comment

March 3, 2008

What’s in a name?

 John Walkenbach found this buried in the Excel 2007 help files. Nice to see that some humour can still get outside of those large corporates….

tallytoil

 ;)

Permalink • Print • 1 Comment

February 26, 2008

SQL Server 2008 Feb CTP6 Installation Experience

Dan has blogged a nice little walk-through of his installation experience with the final CTP of SQL Server 2008. 

Dan English’s BI Blog: SQL Server 2008 Feb CTP6 Installation Experience

Permalink • Print • 2 Comments

February 23, 2008

SQL Server 2008 CTP6 Released

The final CTP for SQL Server 2008 (aka Katmai) has recently been released.

This release is mooted to have the full functionality of the final RTM version.

You can get it here

Permalink • Print • Comment

February 13, 2008

Microsoft BI Blog launched

Welcome to what we hope will become the definitive blog on business intelligence, THE BI Blog.  Not too huge of a goal or vision, huh?  There are already some great blogs out there on all different aspects of business intelligence and performance management–from those dedicated to showing how to build applications, to those that take a more business oriented approach to the discipline of BI and EPM.  Our expectation is that we’ll have a little bit of both sides of the fence represented in this blog as we kick-it off and establish what’s fast becoming the biggest community in the industry around Microsoft BI solutions.

Microsoft is doing some great things in business intelligence, and whether it’s from the customer, partner, developer, implementer, or marketing side of things, we’ll be on top of it here to ensure you’re up to speed on this fast growing business.

Off we go!

Guy Weismantel

THE BI Blog

Permalink • Print • Comment

February 7, 2008

SqlBits II coming to Birmingham - March 1st 2008

This looks great - and what’s more it is totally free - the only slight downside being that it takes up a whole Saturday…. I’m definitely going as given the quality of the speakers, i just know i will learn some new stuff. You can see the agenda and register here. But hurry, I read somewhere they have had around 300 registrations already!!

SqlBits - Agenda

Permalink • Print • Comment
Made with WordPress and a healthy dose of Semiologic • Electric Kubrick skin by Denis de Bernardy