Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Overview Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2014 11:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:04 AM
Points: 3, Visits: 18
Let me start off by admitting I know very little about SSAS. I have been using SQL Server for several years now and and consider myself fairly proficient in t-sql, sp's, functions, SSIS, and SSRS but have never breached SSAS. The company I work for has a standard license for SQL 2k8R2 but does not have SSAS installed yet. My director has given me the green light to build a business case for implementing it. Can you guys (and girls) help me understand what exactly SSAS is and can do for my organization?
Post #1590444
Posted Tuesday, July 8, 2014 2:31 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 611, Visits: 2,115
It seems a bit strange to start with learning about a tool, and then using it to define one's needs. Usually people come at it the other way and end up asking how.

In a nutshell, SSAS helps you build business intelligence solutions on top of a data warehouse. These can either be in the form of a traditional OLAP cube (which any number of ad hoc and reporting tools, including excel, can access), or a tabular model, which can be leveraged using sharepoint, excel, and power pivot.

Long story short, it helps you take a LOT of data and build very fast reports and/or ad hoc reporting/analysis capability to decision makers.
Post #1590527
Posted Tuesday, July 8, 2014 2:55 PM This worked for the OP Answer marked as solution


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 556, Visits: 2,581
To add Nevyn...

SSAS is one of the three core products that are considered part of what is commonly referred to as the "Microsoft BI Stack". You mentioned SSIS and SSRS; SSAS is the third part of the BI Stack. SSAS is about two things primarily: Analysis and Data mining. With respect to Analysis - you can use SSAS to create a cube. What a cube offers over reports from a data warehouse is the ability to "slice and dice" your data. I have spend a few years do SSRS reports off of cubes and the biggest benefit I have seen is the ability to, instead of creating a bunch of SSRS reports to fullfill every user requirement, create a cube with that multiple several reporting requirements then make that cube available to end users via MS Excel. This give us the ability to deliver meaningful content to end users in a format that they can slice and dice the data however they wish.

If you end up using SSAS for Analysis my advice is to also learn MDX. MDX is an invaluable (and very marketable) skill to have if you are working with SSAS.


-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1590535
Posted Wednesday, July 9, 2014 1:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:04 AM
Points: 3, Visits: 18
Thanks for the info, it was what I was looking for.
Post #1590936
Posted Wednesday, July 9, 2014 2:02 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 556, Visits: 2,581
stephen.salowitz (7/9/2014)
Thanks for the info, it was what I was looking for.


No prob. Glad to help!


-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1590937
Posted Wednesday, July 9, 2014 2:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:04 AM
Points: 3, Visits: 18
Do you know of any great (online preferably) resources that I can use to learn more about SSAS?
Post #1590940
Posted Wednesday, July 9, 2014 3:27 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 556, Visits: 2,581
stephen.salowitz (7/9/2014)
Do you know of any great (online preferably) resources that I can use to learn more about SSAS?


Two key books:
I don't know what version you are considering but the Ultimate Guide to Microsoft BI IMHO is The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset. Though it's not specifically about SSAS it puts the who BI stack in Context. Anyone doing BI should study that book to death.

For SSAS specifically: I recommend Microsoft® SQL Server® 2008 Analysis Services Step by Step It's the best book for SSAS newcomers that I have read. Great tutorials.

Web Sites:
I wish SSC had a stairway to SSAS. The next best thing would be Bill Pearson's Stairway to MDX. Though it's about MDX there's plenty to learn about SSAS in there.

Microsoft Technet / BOL is a solid free resource. Check out: http://technet.microsoft.com/en-us/library/bb500153(v=sql.110).aspx

Other Resources:

SQL PASS, SQL in the City, SQL Saturday and my SQL BI User group have been indispensable.


-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1590957
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse