A collective term for the field of developing reporting and analytic systems, often associated with data warehousing.

learn more… | top users | synonyms

-7
votes
3answers
239 views

Business Intelligence = Technical OR Business Project? [closed]

Do you consider a project of Business Intelligence to be a technical or business project?
0
votes
1answer
236 views

Using N-Tier in Business Intelligence

I have read that you also can apply N-Tier for Businesss Intelligence based on these criteria: *Presentation *Functional logic *Data What is your experience when you are using N-Tier? // ...
0
votes
1answer
181 views

Recommended Data profiling tool for BI developer

What recommended data profiling tool to retrieve a lot of information and enable to visulize the data into graphical statistics? The data is coming from the source database.
2
votes
2answers
366 views

Data warehouse: using day number in Epoch in a date dimension

In Chapter 2 Retail Sales of Ralph Kimball's The Data Warehouse Toolkit, the author describes a date dimension with three fields which appear totally alien to me: Date Key (PK) Date Full Date ...
1
vote
1answer
140 views

SSAS cell permission

I'm trying to restrict the access to the cube to certain dimension members. I Used the following function on the "Cell Data" tab of the role editor: [Magatzems].[Codi Magatzem].CURRENTMEMBER = ...
5
votes
1answer
241 views

How to report on sparse areas of sparse fact table

A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student ...
5
votes
1answer
419 views

Fact table design - Level or contribution measures

I am trying to come up with a dimensional model for the following: The source data comes from game machines as meter messages. Basically, the game machine accepts payments and sends a snapshot of the ...
3
votes
2answers
600 views

Combining retail sales and payment OLAP cubes

I'm using SQL Server 2005 Standard Edition Analysis Services (SSAS). I'm trying to build cubes from a retail OLTP database that can answer these kinds of questions: List down all products that were ...
13
votes
2answers
2k views

Open Source Business Intelligence/DWH solutions [closed]

I wonder that this question hasn't already been asked. Google only has very few results for me that don't show a high quality tool What are some Open Source (also free is ok) solutions for Data ...