This month I presented at the Sydney Business and Technology User Group on the topic of MOSS (Microsoft Office Sharepoint Server) and BI.

You can read Craig Bailey's review of the session here: http://blog.craigbailey.net/2007/07/sbtug-report-on-last-meeting-online.html.

This month I presented a talk at the Sydney SharePoint Users Group about Business Intelligence.

There is an overview of the session in a great blog post by Nick Kellett here: http://planetmoss.blogspot.com/2007/06/yesterday-i-attended-monthly-sydney.html.

Nick also has some other great posts on SharePoint over at his Planet Moss Blog.

Thanks for the post Nick!

Come and see how Office SharePoint 2007 "lights up" Business Intelligence.

What is business intelligence? It is simply "turning data into knowledge"

We have extraordinarily powerful quiver of tools for building knowledge from data in SQL Server including:

1. SQL Engine - data storage
2. Analysis Server - multidimensional database
3. Integration Services - move and transform data
4. Reporting Services - creation, management, deployment of reports.

Office SharePoint 2007 gives us the best vehicle to integrate and expose this knowledge through collaboration and document management. In this session we get a whirlwind tour of:

- KPI's / Dashboards
- Server based Excel and data visualization
- Report Centre
- BI Web Parts
- Business Data Catalog

This is the session presented by Grant at TechEd 2006 in Australia and China

Microsoft Office SharePoint 2007 is in Beta 2 now and will be release late this year...

For more details see http://www.sqlserver.org.au/Events/RegisterMeeting.aspx?EventId=220

Business Intelligence "lights up" with Office SharePoint 2007

Ever wondered what Microsoft offers the users for Business Intelligence?

What is possible with tools you already own...

Plumbing - BI Architecture SQL2000 v's SQL2005
Exploring - What tools are best when
Gluing - What do we use to bring it all together

Perception is that Microsoft has a market leading back end in with Analysis Server, but has not had decent front end tools. This no longer true! There are now a range of technologies available including:

- Office Web Components,
- BI Portal,
- Sharepoint,
- Reporting Services,
- Report Builder,
- Excel,
- Data Analyzer,
- Excel Accelerator for OLAP,
- Scorecard Accelerator.

In this session we will explore some of these offerings demonstrating the rich BI delivery platform Microsoft now offers with real world examples.

For more details see http://www.sqlserver.org.au/Events/RegisterMeeting.aspx?EventId=90