Speaker: Dan Bulos, President of Symmetry Corp

Join us for an introduction to Analysis Services focusing on when to use it and how to use it effectively. Dan will cover the three pillars of multidimensional databases: Aggregation Management, Embedded Metadata, and the Calculation Engine.

For analytical applications, performance management, or just about anything with a KPI, Analysis Services is the perfect companion for SQL Server. These are complementary databases that do different things well. Using the right tool for the right job will make development faster and usability easier.

Dan will give a demo which will take us on a short walk though the BI Development Studio – developing dimensions & cubes.

You Will Learn:

• How SSAS aggregation management saves development time and runs faster

• How the embedded metadata (semantic layer) of SSAS creates a more usable application

• The benefits of using MDX as calculation language

• How to make effective use of both the relational & multidimensional SQL Server databases

Dan Bulos is president and founder of Symmetry Corporation, a leading business intelligence consulting firm based in the San Francisco Bay area. He has over 25 years of experience consulting to both commercial clients and software vendors on the design and implementation of reporting and analytical applications. Dan is a recognized authority on analytical database technology and how to best use it to provide real-world solutions for business users. He created DAPT™, the first database design methodology tailored specifically to analytical applications and has been a featured speaker at Business Intelligence and Data Warehouse conferences in the U.S. and in Europe.

Note: This is not a class on how to build an SSAS database.