Arizona SQL Server Users Group

Next Meeting: Wed, Nov 12 2014

AZ SQL Server User Group Nov Mtg: SSAS Design and Performance Best Practices

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

Title: SSAS Design and Performance Best Practices

Synopsis:

A journey through best practices in relation to scalable SQL Server Analysis Services cube design.  From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization.  After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

Takeaways:

·  Best practice design patterns

·  High level understanding of the SSAS internal engine and what role it plays

·  Tuning techniques that provide performance gains

·  Emphasis on the importance of solid multidimensional database design

Duration:  45 – 60 minutes

Alan Faulkner Bio:

Alan is an IT professional with over 20+ years of progressive technical experience managing, consulting, data integration architecture, data warehousing, and business intelligence development projects. The focus of his work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. He specializes in Business Intelligence and Data Warehousing database architecture.  Currently, a Senior BI Consultant with Pragmatic Works.

Email Address: afaulkner@pragmaticworks.com

Speaker Blog:  http://falconteksolutionscentral.com/

Linked In URL:  www.linkedin.com/pub/alan-faulkner/31/b79/932

Twitter Name:  @FalconTekNic

When

iCal
UTC : Wed, Nov 12 2014 23:30 - 01:00
Event Time : Wed, Nov 12 2014 16:30 - 18:00 (UTC-07:00) Arizona
Your Local Time: Wed, Nov 12 2014 23:30 - 01:00

Where

60 E Rio Salado Parkway, 12th Floor
Tempe, Arizona

Direction: None

Featured Presentation

SSAS Design and Performance Best Practices

Speaker: Alan Faulkner, BI Consultant Pragmatic Works

Summary: A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment. Takeaways: · Best practice design patterns · High level understanding of the SSAS internal engine and what role it plays · Tuning techniques that provide performance gains · Emphasis on the importance of solid multidimensional database design Duration: 45 – 60 minutes

About Alan: I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation.

Attachments

Meeting Archive

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids