Topic: Excel

        Page 2 of 57 posts
article –

Prepare Data for Power View Forecasting in Power BI

The new forecasting capabilities in Power View for Office 365 has certain requirements for the column used in x-axis. This article provides a guide to make your data model compatible with the new forecasting feature.  Read more

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