Top "Business-intelligence" questions

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.

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 …

database data-warehouse business-intelligence
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 …

sql reporting business-intelligence
How to change the date format in Oracle BI Publisher?

How do I change the format of the date while creating a report using data model which I created using …

oracle oracle11g business-intelligence obiee bi-publisher
Adding SSDT BI Templates in Visual Studio 2015

I have a new laptop with Visual Studio 2015 Enterprise and SQL Server 2016 CTP 3.1 installed on it. I want to develop …

sql-server visual-studio business-intelligence
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 …

iis reporting-services business-intelligence
Using RELATED function in DAX with USERELATIONSHIP

I am trying to pull in a field from another table in my BISM model using the "RELATED" function. Since …

business-intelligence tabular dax
Data flow task executing successfully but not writing any rows to Excel file

I am working on SSIS package that is fetching data from SQL server and inserting into Excel file... in Data …

sql ssis business-intelligence
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 …

reporting data-warehouse business-intelligence database-normalization
Can I create a new Group by column in OBIEE analytic Report?

Here I have a report: ProductID Price LCD1 12 LCD2 11 LCD3 10 TV 100 GAME 50 I hope to add a new column on …

business-intelligence obiee
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 …

ssas business-intelligence powerbi dax ssas-tabular