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.

Difference between Fact table and Dimension table?

When reading a book for business objects, I came across the term- fact table and dimension table. I am trying …

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

sql-server sql-server-2005 business-intelligence bids
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 …

excel business-intelligence xls pivot-table
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 …

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

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

visual-studio-2010 reporting-services business-intelligence
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 …

business-intelligence powerbi dax
Package Validation Error

I'm trying to use a foreach loop container to import several excel files into a table, I specified the folder …

sql-server excel ssis business-intelligence sql-server-2012-datatools
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 …

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

data-warehouse business-intelligence