reporting services - SQL Server Metrics -

We are using SQL Server as our database server. We have created a consumer product and are creating a dashboard for creating matrix based on our user base.

We are a team of two and wondering if the SSAS or TSQL is the way to get the matrix.

Caveats

• We are not up to speed on SSAS, so there will be a learning curve
• Need to collect data / Denormalized so that we can get DB

If you have to collect data and slice it To make it available and to think at the speed of thought, you should use SSAS. In this regard, a multi-functional database (created by aka cube or SSAS) and relational There is no comparison between one.

You can attach many things to SSAS. Microsoft's product performancepoint and proximity, but Excel comes with a native connector. If you have SharePoint, it can basically be attached to the SSA with the KPI. You can also use SSRs to submit data. With the cube, you will be amazed at how much you can do except for seeing some metric. It's really amazing and powerful stuff, along with the cube, you can use data mining and likes more easily.

I have to say, however, you have to build a mart in Star Schema to close the cube. There are so many great books about it, but I would recommend by Ralph Kimball gives a great overview of what it can do, and why you will use them. To choose the SSAS, there is, which guides you through the process of making a cube.

After spocing about how wonderful Cubes, I have to give this disclaimer: If you want to know all, some matrix from a small dataset, do not worry about the cube T-SQL is better (SSR Takes a better deal with TSQL with SSAS). If you really want to detect data and jump quickly on all types of consolidated levels, then you want a cube. After that, the presentation level is what makes you feel most comfortable. T-SQL and SSAS are compatible with the same MS products.