SSWUG Free Expo Event: Understanding SQL Server Analysis Services

Guys,

SSWUG.ORG’s virtual expo will review various aspects of SQL Server Analysis Services (SSAS), which enables the server to be used for analytical processing and data mining. Through in-depth sessions with four of the leading experts in the information technology (IT) and business intelligence (BI) fields, we will see many demonstrations and examples on designing, creating and managing data from multiple sources. By the end of our event, we should have the tools and understanding needed to bring added functionality, automation and insight into your data. 

Please register now to learn from four acclaimed SSAS experts for free on Friday, May 20! Click here to Register.

Friday, May 20, 2011
9 a.m. - 1 p.m. PDT

Sessions will cover the following topics:

 

• Common Mistakes with SSAS Cube Designs  Sudhir
• SSAS Partitioning and Aggregation Strategies 
• Properly Using the SSAS Query Cache 
• Overcoming SSAS Implementation Issues 
• Building a Scalable SSAS Solution 
• Best Practices for Performance and Tuning Techniques

 

Introduction to MDX video & slides by Business Intelligence architect and MDX expert Bill Pearson

Guys,

To explore the basic functions of MDX and view many practical examples on using the query language in SSWUG.ORG’s "Introduction to MDX" webcast series. In three, in-depth sessions, Business Intelligence architect and MDX expert Bill Pearson will focus on the basic components of MDX, as well as provide information on crafting simple MDX expressions and queries that generate result sets. By the end of this three-part series, we should have the information needed to meet many real-world business needs.

The first session will concentrate on crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. Bill will review the structure of a cube, using the sample "Adventure Works" cube as an example and is available to anyone installing SQL Server Analysis Services 2008 R2. He will also outline the components of simple MDX syntax, explain how to begin writing basic expressions and queries, expose basic member functions and introduce filters (or “slicers”). Finally, we will have the chance to explore core MDX functionality, including calculated members and named sets.

Click here to register for the video and presentation slides.

All the best & happy learning.

Sudhir

Singapore SQL Server User Group on 28th April

Hi,

Welcome to SQL Server User Group Singapore. Following are details of this months meeting on 28th April at Microsoft.

Topic:

Introduction to Business Intelligence – Renaud/Michael will deliver the details of Decision support process , needs and BI From Business needs to Business Intelligence Solutions, The "Boss"questions, Applied Example, Real life project demo

What’s new in SSRS 2008 R2?– SSRS 2008 R2 is a minor version upgrade from SSRS 2008, however, there are many features which are very useful to aid in the development of reports using SSRS. Come and join me about a whirlwind tour about the various features in SSRS 2008 R2.

Date: April 28th, 2011
Time: 7:00PM – 9:00 PM
Registration starts at 6:30 PM
Venue: NTUC Building 22CF-12, Microsoft Office One Marina Boulevard

Speaker profile:
Renaud HARDUIN is ESSILOR European IT Singapore Developement Service Manager, in Singapore (ESSILOR ITSS / 38 people / 6 teams). He is in charge of Europe IT Development Team and support for various Business Support. Renaud is is MVP on SQL/BI since 2005

Michael LABASTIDA is ESSILOR BI Technical Leader & BI Expert In charge of one of the major BI ESSILOR Project in ESSILOR ITSS.

Alvin Lau is your average Joe in the application space and is a large advocate of .NET technologies since 2005. In his spare time, he runs SGDOTNET, a Singapore-based .NET user group, and loves to share his experience and knowledge. His area of interests includes ASP.Net, Agile development, SharePoint and Microsoft BI.

Our website of sql user group : http://sgsql.org

Please confirm your attendance by sending email to SGSQL@LIVE.COM

See you there on 28th April, 2010

Enjoy

Sudhir

Designing Cubes for Performance by Stacia Misner

Guys,

If you are a SQL Server BI developer, who wants to enhance his/her skills on Cube performances then please click on below links to view presentation & recordings of session given by MVP Stacia Misner.

I am sure this will be really helpful.

Enjoy & Happy Learning

Sudhir
Follow this link for the details:

Click here to download Slides

Stairway to SSRS Part 1-> SSRS in Flash

Guys,

If you are interested in learning about SSRS (SQL Server Reporting Services) then have a look at this article. This article from Jessica Moss (SQL Server MVP) shows how we can get started in SSRS.


We can learn following from this article:

• What is SQL Server Reporting Services?
• What can we do with SSRS reports?
• What components does SSRS use?

To read complete article, click here.
 
Happy Learning
 
Sudhir