Presenters: Alberto Ferrari and Marco Russo, SQLBI
Session 15: September 16 at 14:00 GMT
When it comes to implementing a data warehouse using the SQL Server suite, you have to make several SQL Server-specific decisions about technology and implementation that could mean the difference between the success or failure of your data warehouse project. This session will introduce you to the SQLBI Methodology—an approach has been developed over the years to account for all the architectural and technological decisions that you have to make when implementing a complete Business Intelligence solution using SQL Server, Integration Services, and Analysis Services. This methodology is focused on medium to large data warehouses, but with a reduced overhead compared to the classic Kimball methodology, you can use it for small data warehouses too. The big advantage of the SQLBI Methodology is flexibility in terms of design and maintenance. You can download SQLBI Methodology draft papers at http://www.sqlbi.com/sqlbimethodology.
About the Speakers
Marco Russo is a Business Intelligence and software development consultant and trainer. He has particular competence and experience with BI solutions in financial services (including complex OLAP designs in the banking industry), manufacturing, and commercial distribution sectors. Marco wrote the paper “The Many-to-Many Revolution” about multidimensional modeling and is a co-author of the “SQLBI Methodology” and of the books Microsoft PowerPivot for Excel 2010: Give Your Data Meaning, Expert Cube Development with Microsoft SQL Server 2008 Analysis Services, and Programming Microsoft LINQ. He has spoken at previous PASS Summits and at the Microsoft BI Conference.
Alberto Ferrari is a BI development consultant and trainer in Italy. His main interest is in the methodical approaches to BI development, which he and Marco Russo lay out in SQLBI Methodology. He spent several years working with SSIS and SSAS for the banking and manufacturing industries and typically works as a consultant for software developers interested in building complex BI solutions.
Register now for 24 Hours of PASS!