THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Methodologies to build BI Solutions

In the last years I spent most of my time working on BI solutions based on the SQL Server platform. I had experiences with other architectures but I mostly used Kimball's methodology to design relational databases feeding SSAS cubes. However, Kimball only describes the relational side of a BI solution and gives you a basic model (the star schema) that is the pillar of all the SSAS projects I made. The Kimball's model is product-agnostic and leveraging the modeling capabilities of SSAS requires you to make some decisions about how to model data, where to put some definitions and calculations and so on.

I and Alberto Ferrari worked together on several projects and we realized that today we use a methodology that is the result of years of experience and selection. We want to share our knowledge looking for flaws, comments and suggestions. I will start with some post with "Methodology" tag and very soon we will publish some whitepapers on SQLBI site. Please feel free to contact me for any feedback!

Published Friday, September 5, 2008 10:47 AM by Marco Russo (SQLBI)
Filed under:


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement