Monthly Archives: Nov 2014
Wow I’ve Just Seen this fantastic video. shows a new fantastic service on the cloud: Azure Data Factory. This is a service to allow developers to integrate disparate data sources. It is a platform to manage the data you have both on-prem and in the cloud. It provides access to on-premises data in SQL Server and cloud data […]
DAX Studio: A tool for running DAX queries against Excel PowerPivot models or Analysis Services Tabular models. DAX Formatter is a free tool that transform your raw DAX formulas into clean, beautiful and readable code.
Was released the update SQL Server 2012 SP2 Cumulative Update 3 Public KB Article
Clear cache tabular <ClearCache xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”> <Object> <DatabaseID>Namer</DatabaseID> </Object> </ClearCache>
There is three tables: City,Calendar,Pdp. Pdp is the fact tables with 20.000.000 rows. execute the script below and analyze the query plan with profiler evaluate summarize( ‘Pdp’, ‘Calendar'[year], ‘City'[City], “Sales”, SUM(‘Pdp'[Price]) ) the profiler shows that VertiPaq engine get years and cities with a scans the fact table if i take the year and the city […]
Speaker: Marco Pozzan Contents: _ Business Intelligence e Business Analytics _ Big Data _ Hadoop _Hadoop + Business Intelligence = Analisi di grandi quantità di dati _ Excel, lo strumento di analisi View overview