Import data from the Yelp Web API (JSON) using Power Query.Please also make sure to read the Yelp API Terms of Use before using this API. You will need to sign up for an API key before being able to connect.Microsoft Power Map for Excel (GeoFlow).For the purpose of this post, we will focus on the King County area (Redmond, WA). In order to achieve this, we will look at publicly available data using the Yelp API to look at ratings and reviews for restaurants. We would like to show you how Power Query and Power Map can help you gather some insights to make a good decision. Let’s say your 10 year anniversary is approaching and you might be thinking about a good place to have a nice dinner with your partner. Similarly, Power Map was previously known as Project codename “GeoFlow”. Note that Power Query was previously known as Codename “Data Explorer”. But as you will see in this post, self-service BI can become truly personal depending on the nature of the questions that you are trying to answer.
Together, these two tools enhance the self-service business intelligence experience in Excel by allowing you to discover, combine, refine and visualize your data. Power Query and Power Map are two of the new Excel features for Power BI announced this morning at the Worldwide Partner Conference. Update: Visit our Getting Started with Excel and Power BI Series post to access updated training