There has been a lot of buzz from SQLPass and in the SQL Server community about the Business Intelligence Semantic Model (BISM), which will be used to 'power' access to the data for the Microsoft Business Intelligence applications such as Excel, Reporting Services (SSRS) and Sharepoint. It is also intended that Project Crescent, the new… Continue reading Project Crescent in Denali: BISM Summary
What is Project Crescent? The Microsoft SQL Server team blog describes Project Crescent as a 'stunning new data visualisation experience' aimed at business users, by leveraging the 'self-service business intelligence' features available in PowerPivot. The idea is to allow business users to serve themselves to the data by interacting, exploring and having fun with it.… Continue reading Project Crescent in Denali: A Kuhnian paradigm shift for business users?
From what I've read and understood, Project Crescent is best applied to ad-hoc, undirected analysis work rather than directed reports, displaying current operational data activity. This blog aims to understand more about Project Crescent, and when it is best applied to business questions.From the front-end reporting perspective, Project Crescent is a major new Business Intelligence addition to… Continue reading Project Crescent: When is it best applied?
I'm often asked, as I was yesterday by Rob Farley: do you think that Microsoft would consider purchasing Tableau? For those of you who don't know, Tableau is 'rapid-fire' self-service business intelligence, aimed at the business user masses; simple data visualisation, made easy with connections to the Microsoft DataMarket, Teradata, SQL Server, Oracle, Excel and so… Continue reading Project Crescent in Denali: great news for business users, but what about Tableau?
Microsoft have provided a first taste of the latest version of SQL Server, codenamed "Denali". Denali focuses on mission-critical systems, scaleability, multi-site clustering and high availability, with facilities for data integration and data management tools to reliably deliver robust data. Denali also offers advanced data visualisation, supported by column-based accelerations in query performance. Given these… Continue reading Does Microsoft SQL Server Denali put us in denial about the ODS?
What does Microsoft Reporting Services give you, that Excel doesn't? Excel offers accessibility of data, and is, in my experience, the most popular BI tool that I encounter. On the other hand, Reporting Services is less accessible for people who don't have strong Excel skills, but offers you a great deal of fine-grained control over… Continue reading SSRS & Excel; Visualising Large Datasets
One of the key issues in Business Intelligence is the display of data concisely, appropriately and correctly. In particular, Reporting Services (SSRS) and Excel, in the wrong hands, can lead to incorrect data visualisations since it's very easy to produce charts, graphs and so on, without thinking about the data in question, and the business… Continue reading SSRS and Excel: Business Intelligence is more than just producing reports!