Stack Overflow
Stack Overflow

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

Render multiple pages in SSRS report into single page

I have a SSRS report to show values from a stored procedure in SQL Server Business Intelligence Studio. The stored procedure will return 120 rows, each row will be displayed as a table format in my report. So now I have 120 pages, each page having…
Baiju C
  • 3
  • 1
  • 5
0
votes
1 answer

SSAS: Show distinct count measure with unknown member

I have a measure that counts distincted ID's on some fact table. Let's say it looks like this: [id] [linkedtableid] [datecolumn] 1 someid date1 2 someid date1 3 someid date1 4 someid date1 5 null date1 You may see that for date1 there is 5…
K V
  • 23
  • 5
0
votes
0 answers

SSIS foreach ADO Enumerator duplicate rows in object

Hello i am building a SSIS package which get the delta snapshot date's and processed them to the SCD 2 Dimension. Everything goes fine except the "Foreach ADO enumerator" which caused duplicate SNAPSHOTS except the last row. To realize this i look…
Erik hoeven
  • 1,442
  • 6
  • 26
  • 41
0
votes
0 answers

Distributing cost to user date range in DAX

In a retail environment, I have a cost associated with an Item/Offer that has a start and end date. By dividing the cost by the total number of days, I can get the per day cost of each product in each offer. How can I get the total cost of each…
Dave.Gugg
  • 6,561
  • 3
  • 24
  • 43
0
votes
0 answers

Integrate playAxis in custom written bubble charts

I am using the slider for making the bubble chart in motion. Can we Integrate Power View PlayAxis in our Bubble charts using java script.
Raju Rajoriya
  • 23
  • 3
0
votes
1 answer

Error in metadata manager. An error occured when loading the read access database role

Full Process Dimensions :Error ,Error in metadata manager. An error occured when loading the read access database role, from the file, "\?\L:\OLAP\DATA(CubeName).0.db\Role.2.role.xml" I fixed this error by redeploying from my backup solution and…
Rohan Girotra
  • 51
  • 6
0
votes
3 answers

What language should I use to build a small Costing App?

Am trying to build a Small Cost Calculation and Quotation App. Since Its not so big App, I was planning to use plain Javascript rather than using frameworks like Angular JS because i am not much familiar with it. Am I doing it right. This will…
Manish Jain
  • 7
  • 1
  • 5
0
votes
0 answers

IIF ISNOTHING Expression

I'm launching a sub-report to a separate window in reporting services by a JavaScript function as seen below, =iif(Fields!PERIOD.Value <= Cint(right(Parameters!YEARPERIOD.Value, 2)), "javascript:void(window.open('" & Globals!ReportServerURL …
surGe
  • 135
  • 2
  • 11
0
votes
1 answer

How to play videos in BOARD BI

I recently started to work in BOARD BI(is a Business Intelligence and Corporate Performance Management software). How to play video in BOARD BI from a database or local folder?.I cannot find a control in dashboard to play a video Note: I've…
rimboche
  • 87
  • 1
  • 12
0
votes
1 answer

Restore the app from file in C:\ProgramData\Qlik\Sense\Apps folder after reinstall Qliksense server

After changing host name, I got some issue to access QMC and Hub address of Qliksense, then I uninstall and re-install Qliksense server after backup C:\ProgramData\Qlik\Sense\Apps folder. How can I restore all apps in that folder to new server…
kidgu
  • 413
  • 1
  • 8
  • 18
0
votes
1 answer

How to show Excel's charts via smart devices

I have experienced in SAP BOBJ and I knew that we can connect between smart devices (ipad,etc) and BOBJ server to show dashboards. At present, I only used MS Excel 2013 to build dashboards and it did not use the external data.I find the solution to…
ZerO
  • 74
  • 1
  • 6
0
votes
2 answers

JSon to BI - Reports or Tables

I am having a very complex json with 4 level of hierarchy. i am looking for any tool or options where i can convert that json object to a Table. I tried Power BI , any fw other jquery to table options, not able to find a good report. My ultimate…
Night Monger
  • 770
  • 1
  • 10
  • 33
0
votes
1 answer

How does orderby work on an collection key attribute in analysis services - SSAS

Let's say I have a simple hierarchy of Date dimension: Year - Month - Day. As it is known the the Month has to have the keycolumns the month and the year. It would be a collection. Otherwise if it had only the month wouldn't work. For more info…
elvainch
  • 1,369
  • 3
  • 15
  • 32
0
votes
2 answers

How to deploy an existing PerformancePoint dashboard to a new site?

Apologies if the question is not worded appropriately. I've created a dashboard using the dashboard designer and succesfully deployed it to our development server. Now I'd like to deploy it to our staging server - is there a way to do that? I've…
Phil Gan
  • 2,813
  • 2
  • 29
  • 38
0
votes
2 answers

Appending CSV files with same type of data but different column names

Hope you are doing well. I need some help. Just for example, I have 3 csv files: 1) File1.csv with 2 records / rows firstname | lastname | city | country | emailaddress ----------------------------------------------------- alexf sdfsd mumbai…
IT-geek
  • 9
  • 2
1 2 3
…
99
100