Presentations from 2011 Q1 MEETING!!!
Tuesday March 22, 2011 from 2:30 PM to 7:00 PM
In Depth Analysis Services and PowerPivot
Presentation 1 : Analysis at the speed of thought with SQL Server Analysis Services
Analysis At the Speed of Thought - Mustafa Hussain.pdf
Microsoft SQL Server Analysis Services is the semantic layer in the Microsoft BI technology platform that allows users to see and interact with their information in a faster and more dynamic way compared to static reports. Analysis Services provides business users the ability to perform analysis and mine their Data to understand and uncover business issues/drivers leading to better decisions and new business opportunities. This session covers
- Analysis vs. Reporting: End user experience of performing analysis and creating reports using an Analysis Services Cube.
- Building your first Analysis Services cube and using cubes to answer questions at the speed of thought.
Speaker Bio: Mustafa Hussain is a Sr. Solutions Architect with GNet Group. He has 12 years of experience in the Information Technology industry. Mustafa has helped several large enterprise clients implement Business Intelligence solutions using the Microsoft BI stack (SharePoint, Performance Point, ProClarity, SQL Server , SSAS,SSIS and SSRS).
Presentation 2: SQL Server Analysis Services Tips and Tricks
The Cube Tips and Tricks Neelesh Raheja March 22.pdf
This session cover best practices, cool tips and trick to optimize SQL Server Analysis Services Cube design to enable easy yet powerful analysis.
Speaker Bio : Neelesh Raheja, the VP of Consulting Services at GNet Group, has over 15 years of experience in enterprise consulting focused on analytics, data architecture, information governance and business intelligence. He has led teams to deliver solutions that empower data driven strategies across a wide spectrum of industries - Manufacturing , Retail, Education, Telecom, Customer Services, Financial Services, Logistics & Transportation. He has been delivering BI solutions, training and mentoring BI professionals since the first version of SQL Server Analysis Services 7.0 and now SQL Server 2008 R2.
Presentation 3: Leveraging PowerPivot
LeveragingPowerPivot Dan English.pdf
Video: Leveraging PowerPivot by Dan English
No this is not about ‘PowerPoint’, but rather ‘PowerPivot’. During this presentation we will explore the new self-service BI capabilities provided by PowerPivot, compare this technology with Analysis Services (UDM), and dive into creating a PowerPivot solution. By the end of the session you will have an understanding of the positioning of PowerPivot within the Microsoft BI toolset and will know the capabilities that it provides to end-users.
Speaker Bio : Dan English is a SQL Server MVP and has been developing with Microsoft technologies for over 12 years and over 5 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 through 2008 R2 and is exploring ‘Denali’. Dan has screencasts and videos on Vimeo, is an avid blogger, and tweets. Dan helped run the PASSMN user group the past two years and is now helping out with the Microsoft BI user group