Välkomna att delta via LiveMeeting!
Tues April 26th 12PM EST(US)
Developing Date and Role-Playing Dimensions
Speaker: Sandra Mueller
Let's go from Cradle to Grave with the one dimension in 99.99999% of cubes, the dreaded Date dimension. Without this dimension users wouldn't know if it is worth staying open on a holiday or which day of the week the most fresh produce ships or even what their bonus will be. What should be included in the dimension? Should you use the wizard to generate? In this session, we will explore a generic date dimension load script and configuring SSAS to use the table as the time dimension. We will explore performance considerations of attribute hierarchies compared with usability benefits of user hierarchies. Finally, we will address the advantages of role-playing dimensions to make Order Date, Ship Date and Received Date dimensions. Session Level: Intermediate
Sandra A. Mueller is a 16 year MCT. She started with Administration in 1997 and moved into Database Design and performance optimization. In 2004 after activation with the military focus turned to SQL Server 2005 and its Business Intelligence capabilities. She is currently working as a Senior BI Architect with SQL Server 2008R2 OLAP solutions. Sandra blogs on http://www.SandraAMueller.com and is Chapter Leader and founder of the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org).
Contact URL: http://www.SandraAMueller.com
Wed April 27th 12PM EST(US)
Tuning Analysis Services Processing Performance
Speaker: John Welch
You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.
John Welch is BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. John has been working with business intelligence and data warehousing technologies for 9 years, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server BI topics.
Fri April 29th 12PM EST(US)
Creating dynamic calculations using DAX formulas in PowerPivot
Speaker: Javier Guillen
Data Analysis Expressions (DAX) is the expression language used to create custom calculations in PowerPivot. In a similar way to MDX, it can evaluate an expression in different ways depending on the context in which the calculation occurs. The ability to manipulate formula evaluation context enables the creation of reports that involve complex business calculations. This session will explore DAX formula evaluation context and how to manipulate it. A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing how calculations should resolve their outputs.
Javier Guillen (MCTS/MCITP Sql Server 2008 BI) is a Business Intelligence consultant for Mariner, in Charlotte NC. He has designed and developed BI implementations in Microsoft and SAP environments primarily for financial organizations. Prior to being a BI consultant, he was a .Net / C# application developer for a number of years. He is very interested in SSAS/MDX & PowerPivot/DAX, as well as the extensibility of Microsoft BI tools through their programmatic interfaces.