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
16
votes
2 answers

How to load an XML file into a database using an SSIS package?

I am using SSIS in Visual Studio 2008. I have many XML files that I need to process and place into an existing DB structure (SQL Server 2005). This is my first attempt at using SSIS and am a little stuck. I have found the XML Data Flow task,…
Ben
  • 3,926
  • 12
  • 54
  • 87
16
votes
7 answers

Business Intelligence - SSDT for Visual Studio 2013

I was searching for Business Intelligence SSDT tools on Visual Studio 2013. I found SSDT for Visual Studio 2012 here, http://www.microsoft.com/en-in/download/details.aspx?id=36843 Can we install the same to install for VS 2013? If not where can i…
16
votes
5 answers

Installation of SQL Server Business Intelligence Development Studio

I have installed Microsoft SQL Server 2005. This consists of the configuration tools (SQL server configuration manager, SQL Error and usage Reporting, SQL Server Surface area configuration, Reporting Services configuration) and SQL Server Management…
Sheetal
  • 853
  • 6
  • 15
  • 22
15
votes
2 answers

The best MDX references on the net

What is the best references/links,cheatsheets for the MDX language? Here are a few starters that I have collected. Please share yours…
Anders Rune Jensen
  • 3,758
  • 2
  • 42
  • 53
14
votes
2 answers

Database - fact table and dimension table

When reading a book for business objects, I came across the term- fact table and dimension table. Is this the standard thing for all the database that they all have fact table and dimension table or is it just for business object design? I am…
Jack_of_All_Trades
  • 10,942
  • 18
  • 58
  • 88
14
votes
2 answers

What options do I have for creating OLAP cubes with Postgres and making it accessible via .net webservices/wcf?

We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from this (updated daily) to run reports off of. To make this more flexible (as lots of different users require different…
Mr Shoubs
  • 14,629
  • 17
  • 68
  • 107
13
votes
2 answers

SSIS Execute Process Task Python script

I'm trying to execute a python scrip from SSIS Execute Process Task. I followed all the tutorials of how to do this an still the script is failing from the start. when i execute the python script out of SSIS it runs perfectly. This is my Python…
Elad L.
  • 629
  • 1
  • 10
  • 25
13
votes
2 answers

Business Intelligence Development Studio 2008 installation

I'm feeling like a bit of a moron, but I can't find how to install Business Intelligence Development Studio 2008. I have 2005 currently, but need to upgrade for some features. I'm pretty sure that it's included with SQL Server 2008 Standard, but I…
Tracy Barker
  • 133
  • 1
  • 1
  • 6
13
votes
4 answers

Microsoft business intelligence platform vs QlikView

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research Report 2012, QlikView is in the top quadrant together with Microsoft, Oracle, SAP and IBM (leaders and visionaries). I am interested in…
AlejandroR
  • 5,133
  • 4
  • 35
  • 45
12
votes
2 answers

What should I have in mind when building OLAP solution from scratch?

I'm working for a company running a software product based on a MS SQL database server, and through the years I have developed 20-30 quite advanced reports in PHP, taking data directly from the database. This has been very successful, and people are…
12
votes
4 answers

Are there any adhoc report builder libraries available in Java/ Groovy ? That generate SQL queries based on dimensions/measures selected

Ideally the library needs a detailing of what tables/columns/aggregation each dimension/measure map to. Then when given the list of selected ones it generates the SQL querie(s)
Shantaram
  • 133
  • 1
  • 7
11
votes
3 answers

Is there any releavance for "ROW PER BATCH" AND "MAX INSERT COMMIT SIZE" IN SSIS PACKAGES?

I've have SSIS Package that is exporting 2.5 GB OF DATA containing 10 million records into Sql Server Database which has 10 partitions including PRIMARY FILE GROUP. Before Changing default Max Insert Commit size i.e."2147483647" and Row per…
11
votes
1 answer

Component OLE DB source has no input

I am new at doing SQL server data tools on VS 2010. However what I try do is: I have created a textfile and imported it as a flatfile I try to connect the flat file (with the green arrow) with a OLE DB but get the error: Component OLE DB source…
11
votes
5 answers

Difference between Talend Open Studio for Data Integration and Talend Open Studio for Big Data

I'm confused by the different products that Talend offer. It seems that Talend Open Studio for Data Integration and Talend Open Studio for Big Data are the same product but just with different components installed by default. Is that right? If I use…
alan
  • 4,247
  • 7
  • 37
  • 49
10
votes
7 answers

No QUARTER() in DAX? Really?

While building a Calendar table with PowerQuery for a PowerPivot model in Excel 2013 I use its Date.QuarterOfYear function to get the number of the quarter. Building the same thing in SSAS Tabular requires some workarounds. There's no equivalent…
erop
  • 1,510
  • 1
  • 14
  • 27