MSBI online training

MSBI online training starts from Feb 15th 2017. Interview support will be provided for both male and female candidates. To enroll/ for any queries pls reach out to us on +91 9703727925.

Recent MSBI interview question faced by our student from CTS.

Q-How to load all excel sheets in a folder into single table
A- Using File enumerator in For each loop container
For more details(training/Support) please contact us on 9703727925

Recent MSBI interview question faced by our student from CTS.

Question-Find Last Day of Any Month – Current Previous Next
Answer-
----Last Day of Previous Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
LastDay_PreviousMonth
----Last Day of Current Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
LastDay_CurrentMonth
----Last Day of Next Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))
LastDay_NextMonth

For more details(training/Support) please contact us on 9703727925

For course curriculum details, please visit our website
http://vsigninfotech.com/msbi/

SQL Server – Vsign Infotech Duration : 20 hours Faculty : Real time experience 24*7 Technical Support Assignments – End of the each session, assignments will be given and expected to submit w...

SQL server and MSBI online/classroom training by 8+ years of real time experts from Deloitte and Microsoft.
For more details please contact us on 9703727925/[email protected].
FB page- https://www.facebook.com/vsigninfotech/
Website- http://vsigninfotech.com/