Multidimensional Thinking: Making the leap from SQL to MDX
Use SQL Server Analysis Services to enable leaders to understand their business at a deeper level, and with much less effort. With Multidimensional Expressions (MDX) and cubes, you can easily design simple queries and reports to provide business insight that would be complex and inefficient in SQL. It’s easier than you think. We will quickly design a cube from the ground-up and then do a side-by-side comparison of common and useful SQL and MDX queries that produce similar results. You will learn to appreciate the power of the cube and this simple and elegant query language.
Paul is a Manager of Specialized Services / BI Solution Architect for Hitachi Consulting. He is part of Hitachi’s national Business Intelligence and Process Management team and works from HItachi’s regional office in Portland, Oregon.
Paul has been architecting, managing and developing applications and business intelligence solutions for large and small businesses since 1992. He has developed custom database, BI and reporting solutions for many companies including Microsoft, Nike, Disney, Hewlett-Packard and Boeing. His expertise includes project lifecycle management, database modeling and design using SQL Server versions 6.0 through 2008, application development and user interface design using ASP.NET, and enterprise BI solutions using SQL Server Reporting Services, Integration Services and Analysis Services. He teaches, develops training courseware, speaks at industry conferences and has authored and co-authored several technical books. He has presented at the Professional Association for SQL Server (PASS) global summit since 2004.
Paul is an MSDN forum moderator for SQL Server Reporting Services and a SQL Server MVP. He has been a Microsoft Certified Solution Developer (MCSD) since 1996 and maintains certifications in software architecture and development, database administration (MCDBA) and project management methodologies (MSF & IT Project+.) He holds the current MCTS and MCITP certifications for SQL Server BI.
Paul has authored and co-authored several books and training courses including:
Paul’s blog: http://sqlserverbiblog.com/