Home > Uncategorized > MS BI Workshop #15 – Why SSAS?

MS BI Workshop #15 – Why SSAS?

Assuming that now we’ve loaded our data warehouse. The rest of my notes are all about SSAS.

  • SSAS is a service that can pre-aggregate data and make it faster to query data. According to the workshop presenter, it took only 2 seconds to query a 24 terabytes data (in grocery industry)
  • Reduce report backlogs because SSAS allows your users to create complex ad hoc reports without having to involve IT.
  • With SSAS, users can create report via familiar interfaces like Excel or Reporting Services with drag & drop.
  • With SSAS, all the reporting logics are centralized.
    From a developer’s perspective, SSAS really means that no more bad SQL queries, no more waiting for 2 minutes for a report.
    Categories: Uncategorized
    1. No comments yet.
    1. No trackbacks yet.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: