Excel would be a go to choice. You can do all sort (mostly) of analysis on data easily. (unless you've nested array). Apply pivots, infer tables, generate graphs.

If the data size is huge, you can also try MySQL and do queries in traditional manner.

You could check out MongoDB Atlas Data lake: https://www.mongodb.com/blog/post/mongodb-atlas-data-lake-now-generally-available

It can allow you to upload the json file into Atlas and then you can run queries on it using the MongoDB Query Language.