I afraid we have little choice of the books for this topic in English non-Swedish:
- Frost, Robert I. The Northern Wars: War, State and Society in Northeastern Europe 1558–1721. London: Longman, 2000: is without doubt the most important (especially in English) and one of the very few academic literature for this topic in English. In other words, we should take any book in non Swedish on the Great Northern War published in the 21th century and does not consult this work with a grain of salt. (Added) The review of this book by Prof. Gunner Lind (specialized in early modern Danish military history) and the response from the author himself is also worth checking.
- Englund, Peter. The Battle That Shook Europe: Poltava and the Birth of the Russian Empire. London: I. B. Tauris, 2002: is alternative to Frost, but I vastly prefer Frost's to this book as an academic history book. If you are interested more in military history in a narrow sense, this book might be to go.
- (Added): Kirby, David. Northern Europe in the Early Modern Period: The Baltic World 1492-1772. London: Routledge, 1990. This old overview book does not solely focus on the Great Northern War itself (ca. 20pp. at most, if I remember correctly), but like Frost, the author illustrates the power struggle and the shifting power structure around the Baltic in the 17th and 18th century.
- (Added) If you don't mind the classic, Michael Roberts' The Swedish Imperial Experience, 1560–1718, Cambridge: Cambridge UP, 1979 is still worth checking at least in Anglophone works.
If you can read Swedish, the situation will become totally different......
(Added) Reference: