Stack Overflow
Stack Overflow

Questions tagged [msbi]

MSBI (Microsoft Business Intelligence) is a suite of tools providing solutions for Business Intelligence Queries. These tools use Visual studio along with SQL server.

MSBI stands for Microsoft Business Intelligence. This suite is composed of tools which helps in providing best solutions for Business Intelligence Queries. These tools use Visual studio along with SQL server. It empower users to gain access to accurate, up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

MSBI is divided into 3 categories:-

SSIS – SQL Server Integration Services. SSAS – SQL Server Analytical Services. SSRS – SQL Server Reporting Services.

Source: http://www.phpring.com/what-is-msbi-microsoft-business-intelligence/

309 questions
-1
votes
1 answer

Incremental Upload data from sql server to Amazon Redshift

Our Raw Data is in SQL SERVER,Data keep on growing,Growth rate is high,We need to load the data incrementally to Redshift for Analytics.Can you please point out me a good practice to load the data.How feasible with SSIS to load directly to Redshift…
Sravan K Reddy
  • 1,082
  • 1
  • 10
  • 19
-2
votes
2 answers

How to see how many people are accessing a ssas cube?

I wanted to know how many people are accessing a particular ssas cube. Please let me know the process to find them.
Sharath Reddy
  • 1
  • 1
-2
votes
1 answer

SSIS - how to pass good record from file in SSIS instead of failing the package due to bad record

I am trying to import a csv file having multiple record, but whenever a bad record occur it is failing the whole package and whole file, how can i prevent that? Looking for solution: if a file is having 10 record and out which 2 records are bad then…
Tarun Rajput
  • 1
-2
votes
1 answer

SSIS Package to restore

I have a requirement to create SSIS package to restore .bak files and while restoring, package have to shrink .mdf files?will the package fulfil the requirement? Thanks.
Amelia
  • 159
  • 1
  • 3
  • 17
-2
votes
1 answer

How to merge two or more queries with different where conditions? I have to reuse the code which is being used in 1st where code

---below query gives all the customers from fact irrespective of condition SELECT count( dbo.Fact_Promotion.customerid) as Mailquantity FROM dbo.Fact_Promotion INNER JOIN dbo.Dim_Promotion ON dbo.Fact_Promotion.PromotionID =…
vamshi13
  • 1
  • 1
-2
votes
1 answer

How to get details about msbi and tibco?

I had completed MCA in 2013. I am not comfort with programming. so i want to learn other courses beside programming languages. presently which courses have more job opportunities? suggest me a course from following list: MS-BI TIBCO SAP(If sap, then…
Seetha veligonda
  • 11
-3
votes
2 answers

Importing tables from Salesforce to SQl server

Is it possible to Extract all tables of sales force into SQL server Like import in SQL server or SSIS
sonu kumar
  • 13
  • 2
-3
votes
1 answer

i want to find a number from a string and get the number beside that letter in sql server

hi I want to find the number beside a letter in a string , like I have "LOTS 1, 2 & 3 -50 X 140 EACH-" "PLOTS 17 & 18 -50 X150' EACH-" these kind of data in a column . now I want to find X from the data and pull the number which…
Mukesh
  • 55
  • 4
-3
votes
1 answer

How to insert,update records from execute sql task in ssis without using any transformation?

we have oledbCommand Transformation for Update,delete pupose in SSIS it works fine but it will reduce the performance when we have huge amount of data so we can write a query in execute sql task in control flow pane in ssis for insert,update record…
sandhiya
  • 133
  • 2
  • 3
  • 17
1 2 3
…
20
21