Asking your questions to the data
During the first lockdown period I learned to work with Microsoft Power BI and the world of big data opened up for me. I used my limited competences to prepare dashboard on two datasets on scholarly journals: (1) the GOAJ5 dataset which is produced by Walt Crawford based on the DOAJ dataset and solely consists of fully Open Access journals (2) the dataset used by Quality Open Access Market, which aggregates data from JournalTOCs, DOAJ and CrossRef, and thus also includes hybrid journals.
The first dashboard I prepared together with Rob Johnson for a presentation at the OASPA conference in 2020 and the results were published at the blog of the site of Research Consulting.
The dashboard is fully interactive and clickable, and, with the Ctrl key, it is possible to click several items simultaneously. With the symbol in the bottom right corner, it is possible to enlarge the dashboard for greater visibility (as circled in red below).
The other dashboard is published at the site of QOAM and republished below:
There are two important differences between the two datasets: the GOAJ dataset does not include hybrid journals and the articles per journal title are hand counted by Walt Crawford (hats off to him!), while the article counts in the QOAM datasets are from CrossRef and thus includes only articles with a DOI.
Both datasets together give a rather accurate view on the journal landscape. However, questions remain: subscription journals are not included (and are estimated to have 6000 titles with about 500,000 articles a year). Also, there are thousands of Chinese and Japanese journal titles (J-Stage, Kiyo), often in their languages, some with English-language abstracts (and quite a lot are OA) that seem not included in these datasets. This also might explain the discrepancy between the total number of articles in these datasets (QOAM counts 2.1 million articles for the year 2019) and what Dimensions.ai shows (4.3 million articles in 2019). Another question is which journals are truly international. For example, Dutch authors publish only in about 10,000 journal titles of the about 40,000 journal titles. Clearly, there is more to study on the scholarly journal landscape and surely more dashboards will follow.