August Questions

Q. What is the difference between PowerPivot Excel workbooks and Regular Excel workbooks?
Ans. PowerPivot Excel workbooks offer a mechanism to relate between different tables which regular Excel workbook doesn't.

Q. What is the difference between DAX (Data Analysis Expressions) formulas and Excel formulas.
Ans. DAX formulas are designed to be as similiar as possible Excel formulas. But, DAX works with tables rather than cells in tabular fashion. DAX never uses cell coordinates (B2, C3 and so on). Also, DAX doesn't work on cell ranges.To work with ranges, you can use DAX
functions to apply filters to narrow down the data you are interested in.

Here is a simple example of a DAX formula:
=FactSales[SalesAmount]-FactSales[TotalCost]


Q. Which features make Excel an excellent BI client tool.
Ans. PivotTables and PivotCharts.

Q. How to automatically refresh PowerPivot Data in SharePoint?
Ans. Refer the below links
          https://msdn.microsoft.com/en-us/library/gg413467%28v=sql.110%29.aspx
          https://ptgmedia.pearsoncmg.com/images/9780735643406/samplepages/9780735643406.pdf

Q. How can you filter SharePoint list view based on membership group?
Ans. http://techtrainingnotes.blogspot.in/2012/10/sharepoint-filtering-view-by-group.html 

Q. How will you load EcmaScript function in SharePoint 2010 and in SharePoint 2013 ?
Ans. In SharePoint 2010, we can load EcmaScript function by
        jQuery(document).ready(function() {

 ExecuteOrDelayUntilScriptLoaded(myfunction(), "sp.js");
});

In SharePoint 2013, we can load EcmaScript function by

 jQuery(document).ready(function() {
 SP.SOD.executeFunc('sp.js', 'SP.ClientContext', myfunction);
});

Q. What is the difference between item.Update() & item.SystemUpdate() ?

Ans. With item.Update(), we update the changes that are made to the list item. Is that all what it does?
 No, internally it also updates the “ModifiedBy” and “ModifiedOn” fields as per the current logged in user and 
current server time. Optionally it also updates the version of the item if the Versioning option is turned on for that
 specific list.

So, at any point if we wish not to update these extra things i.e. the “ModifiedOn”, “ModifiedBy” and the “Item Version”, then the solution for it is to use item.SystemUpdate() instead of item.Update(). This will help you in updating only those fields which are specified within your code blocks.