A collective term for the field of developing reporting and analytic systems, often associated with data warehousing.
0
votes
1answer
25 views
BI and Self Service Reporting Tools that Support Web (HTML) Interface? [closed]
Hopefully a simple question. What BI tools (commercial or OSS) support self-service reporting or self-service BI via an HTML web interface?
I specified HTML because I know of at least one that can ...
3
votes
1answer
180 views
How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?
Apparently this feature was available in previous versions but has now been removed.
What are some alternatives?
-2
votes
1answer
35 views
How to learn oracle business intelligence enterprise (OBIE) from scratch? [closed]
Hi I am a electronics and communication graduate but i want to learn Oracle Business Intelligence Enterprise(OBIE).I have some theoretical knowledge of RDBMS and SQL which i learnt during my ...
2
votes
3answers
3k views
Which business intelligence tool is better for use with a PostgreSQL database?
I'm trying to find a good BI tool which can be connected to a PostgreSQL database.
I need the following abilities:
Reporting Services
Dashboards
OLAP
Data Mining.
The BI server should work on ...
1
vote
2answers
101 views
Using SQL Server 2012 for Business Intelligence Features Only, No Database Engine
I would like to implement SQL Server 2012 purely for the Business Intelligence Features: SSIS, SSAS and SSRS on its own server.
I current have SQL Server 2008R2 Database Engine installed on another ...
14
votes
1answer
731 views
Recalculate Time Dimension in BIDS
I'm using BIDS to create a cube in SSAS 2008 r2.
I used the wizard to create a time dimension. Part of that configuration is selecting a date range.
After creation, I realized that I needed a wider ...
6
votes
2answers
126 views
How should I configure these disks on a SQL Server for a BI configuration?
Assuming constant memory (32gb) and CPU (4), 2 x disk arrays, I have the following disks
2 x 150 (10k)
6 x 150 (15k)
They are all local disks.
My requirements
My DB is 350gb and set to default ...
3
votes
3answers
352 views
How do you roll up header-level values on a fact table with line-item granularity?
From what I've read, the recommended granularity for a fact table based on an order header / line item structure is at the line item level. In the process, any additive values that apply only to the ...
0
votes
1answer
123 views
What are good resources on data modelling for business intelligence? [closed]
We are a SaaS startup offering purchase & procurement solutions. The data model for operational transactions has been created (relational DB). We also want to offer analytics on those transactions ...
1
vote
0answers
54 views
Advices for modeling facts, time hierarchies based on two conditions
Sorry if my question does not belong to that SE but I tried to find the best place and it ended up here.
My problem is this :
I've got a table modeled as this in our datawarehouse env. :
MYTABLE ...
2
votes
1answer
405 views
What are the differences between Cognos and SPSS modeler products?
My school wants to start doing some data mining, and probably go with an IBM product. I've done a fair amount of searching, but the differences between the two products seem cloudy to those of us who ...
5
votes
2answers
194 views
Solutions for reporting off of an EAV structured database?
Existing setup SQL Server 2005 with standard EAV table that users want to slice and dice with a BI tool (Cognos).
Is there any hope that we can transform this data into a format that we can report ...
2
votes
2answers
142 views
Advice on how to approach data cleaning & importing
I am importing and cleaning data from a datasource that have records like this:
The data needs sorting and rearranging based on the Event Type.
The destination schema would be something like ...
1
vote
1answer
46 views
debugging an ssis package which is invoked from a .net application?
can we attach a debugger to an SSIS package which is invoked to execute from a .net assembly?
0
votes
1answer
172 views
sys.dm_exec_requests does not show short lived requests?
We have a third party BI tool. The BI Tool consists of a server service that builds cubes, and an IIS Service that renders dashboards to users. The cube service and the dashboard service are ...
13
votes
4answers
577 views
Can you give me one example of Business Intelligence?
I don't really understand what Business Intelligence is all about. If I start from having a corporate DB, what is it that a BI person would do? I found plenty of material on the web, but it usually is ...
0
votes
1answer
137 views
BI development in Microsoft BI
I need to learn how to create a dimensional modelling for an organisation that do not has a BI tool and BI model.
Where can I learn more about BI development that should be used in a company?
IT's ...
0
votes
0answers
54 views
Biztalk + BI = where? [closed]
I have heard that you can use Biztalk in to transfer data to the Business intelligence.
Exactly where do you put the Biztalk's integration in relation to the architecture of Business Intelligence?
13
votes
2answers
2k views
What are the arguments in favor of using ELT process over ETL?
I realized that my company uses an ELT (extract-load-transform) process instead of using an ETL (extract-transform-load) process.
What are the differences in the two approaches and in which situations ...
3
votes
1answer
179 views
Methodology & Architecture to Create ETL Process
What book or webpage can I read the architecture and methodology for creating ETL process?
In other words, I'm looking for "how to do it" to create a ETL process when you have many source system to ...
0
votes
0answers
32 views
Identifying interesting data for further analysis
I frequently come across this kind of situation where i have a timeseries based data with lots of categories.
What i'd like is some tool that can scan my data and tell me which categories are ...
-1
votes
2answers
155 views
Tutorial in datamining [closed]
Where can I find about tutorial of datamining in SQL server 2012 or 2008 R2?
The purpose is to improve my knowledge in datamining.
4
votes
2answers
258 views
Using surrogate key after merging the person's data?
This question is about business intelligence with sql server 2008 R2.
If you have a person named Jim Brown with his birthdate and social security number (SSN) being located in three different source ...
6
votes
3answers
191 views
Find material for improvement in Microsoft BI
Which websites, books etc. can you recommend me to improve my basic knowledge in Microsoft Business Intelligence 2008, SSAS, SSIS and SSRS?
Please remember that I'm a newbie in technical BI tool.
If ...
0
votes
1answer
90 views
Chart creation in BIDS 2008
Due to low reputation point i am not able to include the picture.
I am trying to make u guys understand what i am asking for:
I had created a report. And that Report contains these fields and ...
-7
votes
3answers
188 views
Business Intelligence = Technical OR Business Project? [closed]
Do you consider a project of Business Intelligence to be a technical or business project?
2
votes
1answer
196 views
Review Technical ETL process for knowledge management
I'm looking for source code and all related component/material to review technical ETL process between source database and Data Warehouse in order to increase my knowledge in technical Business ...
0
votes
1answer
136 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?
// ...
1
vote
1answer
191 views
Right Tool for Data Mapping in Relation to Business Intelligence
When you are working as a BI developer you also need to create a data mapping between dimensional modeling and source system. What kinda application to visualize a data mapping?
// Fullmetalboy
0
votes
1answer
114 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
185 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
82 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
156 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 ...
6
votes
3answers
510 views
What advantages does in-memory OLAP have over traditional systems with significant memory?
Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)?
For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...
5
votes
1answer
322 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
385 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 ...
11
votes
2answers
1k views
Open Source Business Intelligence/DWH solutions
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 ...
