Singapore SQL UG Meeting on 24th Sep

Hi,

It's the last thursday of the month and we have scheduled our Singapore SQL UG meeting on 24th Sep 2009 at Microsoft.

Venue: Microsoft Office, 22nd Floor One Marina Boulevard

Time: Session starts promptly at 7PM. Registration starts at 6:30 PM



Session 1:

Topic: Self Service BI

Speaker: Sudhir Chawla

On his session, Sudhir will discuss one of the features that we can expect for the next version of SQL – SQL Server 2008 R2.

Known as the “Project Gemini”, SQL Server 2008 R2 enables Excel users real self-service business intelligence. Users can import directly from Excel data from different sources, relate to each other and share and evaluate interactive pivot tables and charts. How to manage relationship, use DAX and perform analysis using Pivot Table & chart.

Session 2:

Topic: Data warehouse “how to” design session

Speaker: Prem Pandey

In our effort to empower our user group members for Business Intelligence, we have come up with 101 sessions that will jumpstart your knowledge for Business Intelligence. For this session we will focus on designing your data warehouse. Part 1 will purely focus on “dimension design” and Part 2 which will happen in future user group sessions will focus on fact/measure designs.

Here’s a quick overview of what you will expect on this session:

Understanding start and snowflake schema

Data Source Views

Creating AS dimension for

Star Schema

Snowflake Schema

Basic Elements of AS Dimension Design

Registration:

Send your registration at: sqlugsingapore@mvps.org