Today we published the draft of the paper ''SQLBI Methodology at work''. We applied the SQLBI Methodology to the well-known Adventure Works. As usual, we look forward to get your feedack in the dedicated forum.

This post is part of a Methodology discussion - other posts will follows. I will be happy to get your feedback! I am proud to announce a public draft of the first paper about the SQLBI Methodology. I and Alberto Ferrari tried to define a consistent methodology which covers the construction of the back-end of a BI Solution using Microsoft SQL ...

This post is part of a Methodology discussion - other posts will follows. I will be happy to get your feedback! Building a BI solution (like any kind of software project), it is normal to look for existing methodologies and best practices, just to avoid pitfalls and get better results. Usually, a methodology is not related to a particular ...

This post is part of a Methodology discussion - other posts will follows. I will be happy to get your feedback! One interesting question is “How do you measure the complexity of a BI solution?” If we need to decide whether a specific technique is suitable for a solution or not, it is very important to be able to classify that solution. We want to ...

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) ...