SQT03 Analysis Services 2012 End-to-End

11/19/2013

9:30am - 10:45am

Level: Introductory to Intermediate

Craig Utley

Craig Utley

Mentor

SolidQ

Are you interested in designing, building, and deploying an Analysis Services database that follows best practices and best delivers value to your organization? This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more. The areas of source code control, deployment, promotion from test to production, processing efficiency, and other areas will be discussed. Craig Utley has experience designing, implementing, and troubleshooting Analysis Services databases at dozens of companies worldwide through his more than 11 years of experience with the Microsoft BI stack. Far from a theoretical discussion, this seminar will present real-world lessons learned about what works in production environments. By attending this session, you will learn the proper design and implementation of your Analysis Services databases, allowing you to avoid common pitfalls while delivering the maximum value to your clients.

You will learn:

  • How to build an SSAS database using best practices
  • Understand the decision points for UDM and Tabula
  • To design an SSAS solution for performance and scalability