World Statistics Day was yesterday, but we’re celebrating all week long! This celebration means acknowledging the impact statistics has on our world. Who is your favorite statistician? Share with us who they are and why they top your favorites list.
Choose Language Hide Translation Bar

Using REST API Through HTTP Request and JMP Maps to Understand German Brewery Density (2020-EU-EPO-388)

Level: Intermediate


Alexa Baltazar, JMP Data Scientist, JMP
Andy Zhou, JMP Technical Intern, SAS


Did you know that there are approximately 1,300 breweries in Germany producing over 5,000 brands of beer? With enough beer options to drink a different German beer every day for 15 years, we want to use JMP to understand the density of breweries in different German states.

In this presentation, you will learn how we used a REST API to bring German brewery data into JMP and then enhance it with geographic data to create interactive, density maps in JMP. REST API data requests can be executed using JMP’s HTTP Request, with the data often formatted as a JSON file. This JSON file can be imported into JMP using JMP 15’s newest feature, Import Wizards. JMP 15 has built in mapping tools that will allow us to show brewery density in Germany. These findings will then be published to JMP Live, JMP's collaborative analytics software for sharing interactive reports.




Can you also share the jsl file behind this presentation?


The jsl file for the BreweryDB API is now attached as a file. There are two things to keep in mind before you give it a try:

  • BreweryDB requires a paid monthly subscription in order to access the full database
  • BreweryDB has a query limit of 200 pages per day, so running the full query will take more than one day as there's more than 200 total pages worth of breweries.

Let me know if you have any other questions!