Topic: Excel

        Page 3 of 63 posts
blog post –

Videos about #DAX on Project Botticelli

More than one year ago, I and Alberto started recording videos for Project Botticelli, and now we have a set of videos about DAX that you can watch online. There are a few videos free, and others are available in the monthly subscription. If you are interested,  Read more

blog post –

Common request: export #Tabular model and data to #PowerPivot

I received this request in many courses , messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature  Read more

blog post –

PowerPivot Workbook Size Optimizer #powerpivot #tabular

Microsoft released the Workbook Size Optimizer for Excel , the first version of an Excel add-in for Excel 2013 that inspects the data model and suggest possible optimizations. Fundamentally, it tries to apply the best practices descripted in a white paper  Read more

blog post –

New PowerPivot 2013 book available! #excel #powerpivot

Our new book about PowerPivot 2013 is finally available in printed edition, too! The title is Microsoft Excel 2013: Building Data Models with PowerPivot and it is a partial rewriting of the previous book about PowerPivot for Excel 2010 . In the previous  Read more

blog post –

Execute a #DAX Query on #SSAS #Tabular in #Excel

Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option  Read more