skip to Main Content

Guest Post from Kasper! Excel 2013, Power View, top 10, “long tail” and how DAX helps

Welcome to 2013!

Hi folks, welcome back Smile  Over the holidays, Kasper submitted a post – yes, THAT Kasper.  Appropriately for the year 2013, it is focused on Excel 2013.  Not many people have 2013 on their desktops yet (even me really – I just have one “test” laptop running it), but over the course of this year I’ll be slowing “rotating” Excel 2013 topics onto the blog.

Anyway, Kasper and I decided to “hold” his post until today so that everyone sees it. 

Over to Kasper…

image

“I’ll be back” – Kasper de Jonge

Ok its been a while since I blogged an actual scenario here on PowerPivotPro but here is another one 🙂 . Its that time at the end of the year and folks here at Microsoft are out enjoying their vacation so lots of meetings get cancelled,  this gives me the opportunity to do one of the the things I love, helping users of our products get the solution they need and write some blog posts :).

A few days ago I met a internal user who had 3 million rows of occurrences, products and dates in a SQL database and wanted to get some insights out of it, preferably in a highly visual output. We are fortunate here at Microsoft that we always get to play with the latest bits, so we have access to Excel 2013 that includes Power View.

In this blog post we will look at how we can show a top 10 list of best selling products in Power View and how we can solve a long tail problem that will allow us to visualize only the top best selling products in a chart and ignore the rest. I know these things are pretty straightforward in Excel (if you know where to find it) but it needs the help of DAX in Power View.

Read the Rest

Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros

image

Our First Post on Excel 2013 Beta!

Guest post by…  Kasper de Jonge!

Notes from Rob:  yes, THAT Kasper de Jonge.  We haven’t seen him around here much, ever since he took over the Rob Collie Chair at Microsoft.  (As it happens, “de Jonge” loosely translated from Dutch means “of missing in action from this blog.”  Seriously.  You can look it up.)

1) Excel 2013 public preview (aka beta) is out, which means that now we’re not only playing around with PowerPivot V2 and Power View V1, but now we have another new set of toys to take for a spin.  I am literally running out of computers – I’m now running five in my office.  Kasper is here to talk about Excel 2013.

2) I’ve been blessed with a number of great guest posts in a row, and there’s already one more queued up from Colin.  This has given me time to seclude myself in the workshop and work up something truly frightening in nature that I will spring on you sometime next week.  But in the meantime, I hand the microphone to an old friend.

Back to Kasper…

Inspired by all the great blog posts on doing a Dynamic Top X reports on PowerPivotPro I decided to try solving it using Excel 2013. As you might have heard Excel 2013 Preview has been released this week, check this blog post to read more about it.

The trick that I am going to use is based on my other blog post that I created earlier: Implementing histograms in Excel 2013 using DAX query tables and PowerPivot. The beginning is the same so I reuse parts of that blog post in this blog.

Read the Rest