MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Business Intelligence.

  Asked By: Jean    Date: Aug 25    Category: MOSS    Views: 1646

Our Organization is looking for a good BI solution and SharePoint is
one of the options?
In our environment we have lots of data and we don't have a cube of
any sort.
My assignment is to put together how SharePoint 2007 can help us!

Scenario 1. I have to show what MOSS 2007 can do out of the box with
Excel 2007 and SQL databases.(We have Excel Services Avialable).

Scenario 2. BI abilities in MOSS 2007 after creating a cube of some
sort and Excel.

Scenario 3. Abilities by using MOSS 2007 + Performance Point/Business
Scorecard Manager + Cube + Excel.

Can anyone please point me to apt resources to do my assignment as I
am a novice in these areas.
Any help is very much appreciated!



10 Answers Found

Answer #1    Answered By: Ted Gilmore     Answered On: Aug 25

Have you taken a look at the content at
www.microsoft.com/.../demos.mspx ?

Answer #2    Answered By: Monte Cooley     Answered On: Aug 25

I did see some BI demos but I did not get a feel of what I would get
without a cube  in MOSS 2007 and advantages of having a cube.

Answer #3    Answered By: Guadalupe Bullock     Answered On: Aug 25

Maybe I'm missing something, but what's a "cube", exactly?

Answer #4    Answered By: Nathanial Mcclure     Answered On: Aug 25

SQL Server Reporting Services does it's work via a pre-built structure
commonly referred to as a "cube".

Answer #5    Answered By: Lamar Mullins     Answered On: Aug 25

Actually, modern databases (including SQL Server) allow you to define
multi-dimensional aggregations of relational data  that can be
dynamically pivoted on by the end user. You can create something similar
using a pivot table in Excel.

For example, given the following tabular data for me and my siblings:

Name Age Gender
------- ------- ------
Todd 44 M
Troy 42 M
Tami 40 F
Tylene 36 F
Tiffany 34 F
T 25 M

You could pivot on Gender to produce the following details:

Gender Count
------- -------
F 3
M 3

And this pivot:

Gender AvgAge
------- -------
F 36.6
M 37.0

Check these out for more detail:

Answer #6    Answered By: Stefan Mcbride     Answered On: Aug 25

That was EXACTLY the definition I went to first. I was like
"er, what's Star Trek got to do with it?"

I have heard of pivot tables, but haven't worked extensively with
them. Thanks for the links - I'll do a bit of reading.

Answer #7    Answered By: Lee Black     Answered On: Aug 25

For those of you that need a visual:

I think this one was my favorite:

Answer #8    Answered By: Fred Rios     Answered On: Aug 25

Thank you for all your contributions, can anybody tell me the major
differences between Business scorecard manager and Performance Point

Answer #9    Answered By: Donnie Drake     Answered On: Aug 25

Pretty much all of the SQL functionality in those demos is done via a

Didn't find what you were looking for? Find more on Business Intelligence. Or get search suggestion and latest updates.