Tag Archives: SSRS

Data Mining (Fundamentals & Time Series Algorithms)in SSAS

This short article is completely Q & A based on Data Mining in SSAS(SQL Server Analysis Services)where we will discuss fundamentals and Time Series Algorithms. So below are the questions and its proposed answer which will help reader to improve … Continue reading

Posted in MSBI Interview Question, Uncategorized | Tagged , , , , , , , | Leave a comment

How to perform Script Task and send email using Script Task?

Script Tasks are used to send an email or do any web related tasks where customization is required. In Script Task for doing the customization we have to write C# code. It would be helpful for the MSBI training candidate … Continue reading

Posted in MSBI, Uncategorized | Tagged , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on (SSIS, SSAS and SSRS)MSBI

What are partitions in SSAS? SSAS let us create cube. Cube is a multi-dimensional database. Data will be stored inside cube as dimensions and Fact Tables. By default in order to store Fact tables (measure group tables) partitions will be … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

SSIS, SSAS and SSRS(MSBI) interview questions: – Explain Data Flow Tab and Data Flow Task in SSIS?

When we think about creating any SSIS package, after we open the SQL server data tools or Business Intelligence development studio we will landed into SSIS designer window. As you can see SSIS designer contains many tabs at the top. … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | 1 Comment

SSIS, SSAS and SSRS(MSBI) interview questions: – Explain the following terminologies in SSIS

Control Flow In SSIS Package Control Flow defines the tasks to be executed. Example: We define operations such as “Execute TSqlCommand on Database”, “Send Mail” etc. in Control Flow. Precedence Constraints In the control flow section of SSIS designer we … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

SQL Server interview question:- Explain SSIS, SSAS and SSRS?

All these 3 things are related to Business intelligence. Business intelligence is all about making meaning of your data, forecasting using that data, making more business sense from the data. In order to do the same we first need to … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment