I think you can easily load JSON data into Pandas DataFrame. Then you can create visualizations and compute statistics. Python might be usefule for that.
... and if you (the parent comment author) wants a really easy tool for creating a UI for the Python code, I'd recommend looking at Streamlit: https://streamlit.io/