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
190
votes
11 answers

Difference between Fact table and Dimension table?

What is the difference between fact tables and dimension tables? An example could be very helpful.
user2467545
103
votes
5 answers

I lost datasets pane in Visual Studio

I'm developing a report in the Business Intelligence studio and I lost my dataset. The pane was near toolbox, and it is gone. What is the name of the pane I should to reopen?
user194076
  • 8,787
  • 23
  • 94
  • 154
38
votes
9 answers

Pentaho vs Microsoft BI Stack

My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've…
Tomas
  • 3,384
  • 2
  • 26
  • 28
34
votes
12 answers

What is "business intelligence" software?

Is "business intelligence" a buzzword that has no real meaning to software developers, or does the term carry some implied meaning in terms of what the software does or how the software does it (in a general sense)? It appears to be a real business…
Thomas Owens
  • 114,398
  • 98
  • 311
  • 431
26
votes
1 answer

What's the difference between additive, semi-additive, and non-additive measures

I have searched in the net what's the difference between additive, semi-additive, and non-additive measures in a data warehouse. I have found some results but I have difficulty understanding the differences because they aren't an example. Could you…
user2460074
  • 1,252
  • 3
  • 11
  • 28
25
votes
5 answers

Generating Reports - What works for you?

I'm looking for a templating tool that allows powerful manipulation of data and report building. JasperReports is powerful, but is it the best out there? I generally don't need the ability for fancy colors or gradients, but I do need the ability to…
Stefan Kendall
  • 66,414
  • 68
  • 253
  • 406
24
votes
10 answers

How to change pivot table data source in Excel?

I want to change it from one database to another. There don't appear to be any options to do this on the pivot table context menu
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
20
votes
2 answers

Data Mining in a Django/Postgres application

I need to build in a analytics (reporting, charting & graphing) system into my Django application. In an ideal world I could just query my Postgres DB and get the data I want but when the amount of data in the DB goes through the roof, I'll hit…
Mridang Agarwalla
  • 43,201
  • 71
  • 221
  • 382
20
votes
3 answers

How to get month name from month number in Power BI?

I have Year number and Month Number in my data. How using DAX can I get the month name out of month number? In SSRS its very easy. But how to achieve that using DAX?
Serdia
  • 4,242
  • 22
  • 86
  • 159
19
votes
5 answers

How to use SQL Server stored procedures in Microsoft PowerBI?

I want to generate reports from my SQL Server tables. I have some already made stored procedures that I would like to use to generate reports from. I haven't found a way to do so. Only by rewriting the queries. Thanks :)
19
votes
23 answers

What is your reporting tool of choice?

Every project invariably needs some type of reporting functionality. From a foreach loop in your language of choice to a full blow BI platform. To get the job done what tools, widgets, platforms has the group used with success, frustration and…
jason saldo
  • 9,804
  • 5
  • 34
  • 41
18
votes
2 answers

Sql Server Services - Overview anyone?

In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These…
James
  • 7,877
  • 7
  • 42
  • 57
18
votes
5 answers

open source business intelligence solutions

which open source business intelligence solution would you recommend? All I need is to build some cubes and let the end user play with dimensions, filter data, sort, etc, and once it's done being able to export it to excel... I'd like the solution…
opensas
  • 60,462
  • 79
  • 252
  • 386
17
votes
11 answers

Easy to use web-based reporting tool

I'm looking for recommendations for an easy to use reporting/business intelligence tool that can interface with an sql server or access database. It can be web-based or a desktop tool. Ideally it would be freeware or low cost, and easy to use for…
SuperFurryToad
  • 423
  • 3
  • 8
  • 13
17
votes
8 answers

Advice for someone who wants to start in Business Intelligence?

What advice would you have for someone who wants to start in the BI (Business Intelligence) domain? I where and what I should start with: Books, Blogs, WebCasts... What I should pay attention to and what I should stay away from. Are the Microsoft…
Alexandre Brisebois
  • 6,599
  • 12
  • 50
  • 69
1
2 3
99 100