Category Archives: Excel

it is possible to identify users without the need to configure Kerberos delegation

EffectiveUserName is a property for the connection strings for SQL Server Analysis Services contains the name of the user who logs on. And ‘possible to use this property along with Excel Services and PerformancePoint Services to pass the identity of the user viewing the report or dashboard in SQL Server Analysis Services. Examples: Provider=MSOLAP.5;Integrated Security=SSPI;Persist […]

Connect to DB access with encryption from Powerpivot

So to connect to powerpivot 2010/2013 at a DB access with encryption you have to go in powerpivot ribbon choose other data sources as shown in the picture Then choose ODBC as shown in the picture And finally you write the connection string into textbox as seen in the photo but you also write here […]

Great site for the automation of powerpivot with VBA

http://blog.gobansaor.com/2011/09/01/automating-powerpivot-refresh-operation-from-vba-the-code/

Alternative way to build Date Table

I recommend you see this link  Kasper de Jonge illustrating an alternative way to build a temporal dimension to be used in PowerPivot DAX formulas of our sheets.

GeoFlow for Excel delivers 3D data visualization

Beautiful tool “Geoflow” 3d views to excel in: http://blogs.office.com/b/microsoft-excel/archive/2013/04/11/public-preview-of-geoflow-for-excel-delivers-3d-data-visualization-and-storytelling.aspx. Today I got to try it and it is a truly remarkable. Microsoft adds more blocks to Excel to extend the range of self-service BI.

Data Explorer

Microsoft ha recentemente rilasciato un nuovo componente aggiuntivo chiamato Explorer Data. Questo è un componente aggiuntivo per Excle 2010 Excel ed Excel 2013 che può essere scaricato qui. Data Explorer ci dà una nuova scheda della barra multifunzione, da dove siamo in grado di importare, trasformare e unire i dati da una varietà di fonti. […]

Switch to our mobile site