Category Archives: Excel
Analyze a Twitter feed with Excel 2013, DataExplorer and GeoFlow
I recently got access to a csv file that contains twitter feeds filtered by Azure. I want to do some simple analytics on where the twitter users live in a visual way. I am going to load the csv file into Excel using DataExplorer (download add-in for Excel 2012 here). And I select Import from [...]
NBA team spending and their results with Excel, PowerPivot and Data Explorer
Ok truth be told I am a big time Lakers fan and this season is a big disappointment for me, one of the things that irks me is that the Lakers are being paid the most of all the teams in NBA but lack the results. In this blog post I am going to compare [...]
What is eating up my memory the PowerPivot / Excel edition
A common question asked is what columns in my model are using the most memory. Earlier I created a workbook that was able to get the memory for a Tabular server which you can download here but that didn’t work with an embedded Excel Data model or PowerPivot workbook. But I recently found a new way that would [...]
PowerPivot Use Case: Getting the active products between a date range using DAX
I have been getting this question a few times in the last week, e.g. in my ask a questions page here, on how we can get the number of active products between two time intervals in Excel. Lets answer the question on my ask a questions page in todays blog post. The question was: DESIRED [...]
Templated Excel workbooks with PowerPivot and Macro’s
A often asked question is: “Can I create a templated report where I can create a PowerPivot workbook for my customers that will point to a database on the customers network”. This can be very useful for example as an ISV where you have a product that is installed on a customers domain and has all its [...]
Import data into the model using a Macro in Excel 2013
In Excel 2013 Macro’s now can talk to the Embedded Analysis Services engine. Here is an example created by my colleague Allan Folting that will import a table from the Azure datamarket into the Model using the Excel OM. The first thing you want to do when you want to create macro’s is enable the Developer ribbon [...]
PowerPivot case: Does a value exist in both columns ?
I had a interesting question on my ask a questions page that I wanted to answer by solving it using PowerPivot. The following question was asked: If i have a powerpivot table whith phone numbers in two different columns. Can i make some kind if a search formula if i want to search a specifik number [...]
Why SharePoint 2013 (ECS) is great for Multi dimensional!
The new ECS in SharePoint 2013 is pretty awesome, the Extel team has worked hard to make ECS on par with Excel. But wait what do these changes have in common with MOLAP? Well since most of the underlying Excel code is shared, a lot. Let me show you. I created this Pivot table in [...]
Login