Questions tagged [business-intelligence]

Business intelligence(BI) refers to the process of analyzing an organization's business data, by various (often computer-aided) means, to assist in the organization's decision making. BI technologies are capable of handling large amount of unstructured data to help identify, develop and create strategic opportunities.

Business Intelligence explains the process that a system uses to gather raw data from different types of sources and processes it into practical information to determine the effectiveness of business process.

It involves three levels of processes. STAGING, INTEGRATION, ACCESS

Staging involves the process of giving the raw data and manipulating it.

Integration involves the process of categorising the raw data and logically storing it according to the requirement of the end-user.

Access involves the process of giving the categorised and logically stored data to the users in a coherent way that is easy to understand.

There are many tools available for Business Intelligence. Some of the popular tools (in no particular order) are:

  1. IBM Cognos
  2. Microsoft Business Intelligence
  3. Oracle Business Intelligence Enterprise Edition (OBIEE)
  4. Business Objects Enterprise XI
  5. Jaspersoft (Open Source)
  6. Talend Open Studio (Open Source), Talend Enterprise or Platform (with subscription)
  7. Pentaho software (have open source version)
  8. Qlikview Comprehensive BI Platform
  9. MicroStrategy
  10. Tableau

Business Intelligence helps an Organisation for its growth by analysing required business data.

Links

2057 questions
10
votes
2 answers

Is a fact table in normalized or de-normalized form?

I did a bit R&D on the fact tables, whether they are normalized or de-normalized. I came across some findings which make me confused. According to Kimball: Dimensional models combine normalized and denormalized table structures. The dimension…
10
votes
2 answers

joining across multiple fact tables with a dimension in between

What's a good approach to data warehouse design if requested reports require summarized information about the same dimensions (and at the same granularity) but the underlying data is stored in separate fact tables? For example, a report showing…
10
votes
4 answers

hadoop vs teradata what is the difference

I've touched a Teradata. I've never touched hadoop, but since yesterday, I am doing some research on that. By description of both, they seem quite interchangable, but in some papers it is written that they serve for different purposes. But all I…
John
  • 503
  • 2
  • 10
  • 25
9
votes
7 answers

alternatives to jpivot?

JPivot, even with all it's functionality, seems a bit outdated... last version at http://sourceforge.net/projects/jpivot/ is from 2008-03-17... is there any other lightweight client olap cube browser, that could take advantage of modern RIA kits,…
opensas
  • 60,462
  • 79
  • 252
  • 386
9
votes
3 answers

Can someone please explain data mining, SSIS, BI, ETL and other related technologies?

I was talking with a co-worker yesterday regarding a situation where he used SSIS (or something like that) to do some really cool thing with an SSIS Package where he passed in a name like "Dr. Reginald Williams, PhD." and based on some weighting…
Micah
  • 111,873
  • 86
  • 233
  • 325
9
votes
2 answers

Pivot transformation using t-sql

In SSIS there is a task called Pivot transformation that changes columns into rows, but how to do the same task in sql server using t-sql ? this is my sample table location product qty ----------------------- delhi PEPSI 100 GURGAON CAKE …
vhadalgi
  • 7,027
  • 6
  • 38
  • 67
9
votes
3 answers

Can we compare saiku with Pentaho Analyzer?

I'm currently in an internship and i have to create a whole BI application. I think i'll use pentaho, and I have to use just open source component. I know that Pentaho Analyzer is not free My question is: Is saiku an equivalent of analyzer? If yes,…
joris
  • 435
  • 1
  • 7
  • 18
9
votes
1 answer

Qlikview Rolling 12 Month Fiscal

This forum seems to be more geared toward more programming issues but I would be interested if someone would look at the logic issue in the link below. My issue is about how to calculate the previous 12 months' total using the calendar already…
octopus_guy
  • 91
  • 1
  • 1
  • 3
8
votes
2 answers

Dashboard supporting d3

I'm interested in a web-based dashboard with some sort of d3.js library widget or more general javascript support. I've been trying geckoboard's HighCharts widget but I'm not especially happy with the results (a little limited for what I'm looking…
the franc
  • 133
  • 1
  • 7
8
votes
4 answers

How can I get SSIS Lookup transformation to ignore alphabetical case?

Hopefully this is easy to explain, but I have a lookup transformation in one of my SSIS packages. I am using it to lookup the id for an emplouyee record in a dimension table. However my problem is that some of the source data has employee names in…
rrydman
  • 501
  • 3
  • 9
  • 15
8
votes
7 answers

SSDT 2017 Setup Failed The configuration registry key could not be opened

We have been using VS 2017 Shell version for BI development for a few months without problems but today it stopped unexpectedly and restarted on its own. After the restart, we got an error: Could not load file or assembly …
8
votes
1 answer

SSIS Data Flow Items and SSIS Contol Flow Items Tab missing in Visual Studio 2013 from _Choose Toolbox Items_

I have a VS 2013 installed, and successfully installed "Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013" All BI project templates are OK, all toolbox items are OK. I also can create a new Integration Services project,…
g.pickardou
  • 32,346
  • 36
  • 123
  • 268
8
votes
2 answers

Is Qlik Sense a new version of Qlikview or a new different product?

I've heard both scenarios from different sources and there seem to be some impression on Qlik's product strategy for the future. So, has someone understood if QlikSense is a new version of Qlikview or a new different product?
Krowar
  • 581
  • 2
  • 8
  • 18
8
votes
1 answer

How can Kafka limitations be avoided?

We're trying to build a BI system that will collect very large amounts of data that should be processed by other components. We decided that it will be a good idea to have an intermediate layer to collect, store & distribute the data. The data is…
Stephan
  • 8,000
  • 3
  • 36
  • 42
8
votes
1 answer

Does SSRS Report server run on top of IIS?

I am new to SSRS and Microsoft BI stack, and want to know if SSRS Report server runs on top of IIS or is it a separate entity (server) that runs independent of IIS? Secondly how to give public access to a report server? Also is it necessary or the…
SpeedBirdNine
  • 4,610
  • 11
  • 49
  • 67