Interactive Data Visualization: What Outdoor Activity is most popular with 18-24 yr olds?

Bing Ads Intelligence is a powerful keyword research tool that allows you to build and expand on your keyword lists using the familiar Microsoft Office Excel interface. It enables you to easily gauge the performance of relevant keywords on the Yahoo Bing Network, and then apply those insights to improve your keyword selection and campaign performance.

I have discovered that the Bing Ads Intelligence Addin can give Retailers amazing insights into popularity of products and services over time and the variations of the popularity across different times of the year. The information that can be acquired using the Bing Ads Intelligence Addin also includes a breakdown of geographic location where certain search terms are popular than others. In addition, I also like the capability of analyzing the demographic mix by age and gender for specific search terms.

I recently met up with an Outdoor Gear retailer and we analyzed the popularity of several outdoor activities across the country and correlated this information to store locations. In addition, it was interesting to see where in the country, camping was more popular than, say Kayaking, or what activity was popular with the 18-24yr olds vs the 50-64 yr olds.

The Bing Ads Intelligence Addin can be downloaded from LINK. I used Power View for Excel 2013 to build the visualizations.

Here is an interactive view of the visualization that I built using Power View. Feel free to use the slicer to filter specific activities and interact with the data.

Here is a full screen version of the Interactive Visualization.

Comments (5)

  1. Jen Underwood says:

    This is a HUGE win…  can't wait to give it a try myself.  Awesome.  Love your work Shish.

  2. Ruth says:

    When Will the functionality of embeding anonymous power view files be available? Thanks

  3. S h i S h says:

    sorry, Not sure of specific availability dates.

  4. Arthur Jenkins says:

    Hi Shish. I've been trying to do something like this with some slicers and a pivottable connected to a data model in Excel 2013. I followed Jenn Underwood's instructions. I get an error message that reads "The workbook contains external data connections or BI features that are not supported." I have a Power BI subscription so I created a service issue. Microsoft's solution was to send me an Excel Web Access Web Part, which works until I put my public facing site online. Then it tells me I need an Enterprise license. Any ideas? Thank you.

  5. Tom S. - MSFT says:

    Arthur, please see my blog.

    Excel Online – This workbook contains external data connections or BI features that are not supported.…/excel-online-this-workbook-contains-external-data-connections-or-bi-features-that-are-not-supported.aspx

Skip to main content