Analyzing BestBuy Data with Power BI


The BestBuy Developer APIs provides interesting product, store, category and customer review data that can be queried using Power Query for Excel. To signup for an API Key go to: https://developer.bestbuy.com/

I decided to test out the API using Power Query for Excel and try to build out some visualizations using Power View and Power Map.

For my test, I used the following APIs:

Search and return products based on review criteria: The Best Buy Products API provides a simple, REST-based interface for the entire product catalog. To search based on review criteria you can specify the customerReviewAverage "customerReviewAverage=4" or the "customerReviewCount>400".

This is the URL that I used for querying the API:

http://api.remix.bestbuy.com/v1/products(customerReviewAverage%3E4&customerReviewCount>400)?show=customerReviewAverage, customerReviewCount,name,sku&format=json&apiKey=YourAPIKey

I wanted to build a list of products at BestBuy that had an average review of 4 and a review count for more that 400. I copied the above URL and used my API Key in Power Query. The results showed me the top 10 products with an average review of 4 and with more than 400 customer reviews:















AvgReview ReviewCount ProductName SKU
4.8 499 12 Years A Slave (Blu-ray Disc) 3282128
4.8 476 12 Years A Slave (DVD) 3282137
4.3 948 300: Rise of an Empire (Blu-ray 3D) (Ultraviolet Digital Copy) 5836425
4.3 975 300: Rise of an Empire (Blu-ray Disc) (2 Disc) (Ultraviolet Digital Copy) 5836383
4.3 926 300: Rise of an Empire (DVD) (Special Edition) 5836416
4.4 509 Acer – 20" LED HD Monitor 8816192
4.5 402 Amana – 6.5 Cu. Ft. 11-Cycle Electric Dryer – White 4961432
4.5 642 Amazing Spider-Man 2 (Blu-ray Disc) (Only @ Best Buy) 7615006
4.5 404 Amazon – Fire TV 5782223
4.6 922 Amazon – Kindle Fire HD – 8GB – Black 2216082

image

image

Store Availability: The Stores API with the Products API allow you to perform store availability queries for a specific product. Store availability queries will return only those stores that have a given product in stock.

This is the URL that I used for querying the API:

http://api.remix.bestbuy.com/v1/products(sku=1221963)+stores?format=json&apiKey=YourAPIKey&show=sku,stores

I wanted to build a list of Best Buy stores that carried the highest rated product indicated in the query above. I decided to pick the product that had highest number of customer reviews:   300: Rise of an Empire (Blu-ray Disc) (2 Disc) (Ultraviolet Digital Copy). I used the SKU number in the above query URL using Power Query. This Query returned the stores where the product was in stock.

image 


Comments (0)

Skip to main content